Numbers Fie Edit Insert Table Format Arrange View Share Window Help Grades -Edit
ID: 3053939 • Letter: N
Question
Numbers Fie Edit Insert Table Format Arrange View Share Window Help Grades -Edited View Zoom Formula Table Chart Taxt Shape Media Comment FA0B CSC 150 11 FA 08 Destiny Jules Grades Letter Last Name, First Name CTCS Test 1 Safety Paer Resume Test 2 E1 E2 Sylla PSC Internet Points Grade Grade 4 Destiny Jules 10 96 10 28 10142 0 10 10 1010 336 Total Possible Points 10 100 10 30 10 150 10 10 10 10 10 360 0 Instructions Merge and Center the Title, font should be 18, red, and Bold in cell A1 12 The subtitle should be your name Grades: EXAMPLE John Doe Grades 13 Center row 3, font size is 11, font face is Calibri Type your name in A4 and your grades in 84 -N4 15 Type the information as shown in row 6 Use a formula to compute the Total Polnts 17 Use a formula to compute the Total Possible Points Total Possible Points should equal 360 18 Use a formula to compute the Grade 19 Use a NESTED IF FUNCTION to compute the Letter Grade 20 Save the File as Grades 23Explanation / Answer
The following formula can help you to quickly calculate the letter grade as you need, please do as this:
Enter this formula: =IF(E2>=90,"A",IF(E2>=80,"B",IF(E2>=70,"C",IF(E2>=60,"D","F")))) into a blank cell next to your score data where you want to locate the letter grade, F2, for instance, and then drag the fill handle down to the cells that you want to contain this formula, and the letter grade has been displayed in each cell as follows:
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.