Step 2- In cell C1 type in 100, in cell C2 type in 80, in cell C3 type in 85, in cell C4 type in 90, in cell C5 type in 67, in cell C6 type in 70.
Step 3- In cell C8 type in =sum(C1:C6) and then press Enter on the keyboard.
Step
1- In cell A1 type in the Label Grade 1, in cell A2 type in the Label
Grade 2, in cell A3 type in the Label Grade 3, in cell A4 type in
the Label Grade 4, in cell A5 type in the Label Grade 5, and in
cell A6 type in the Label Grade 6, in cell A8 type in the Label Sum of
the Grades, in cell A9 type in the Label Average Grade, in cell A10
type in the Label Highest Grade, and in cell A11 type in the Label Lowest
Grade.
Step 2- In cell C1 type in 100, in cell C2 type in 80, in cell C3 type in
85, in cell C4 type in 90, in cell C5 type in 67, in cell C6 type in 70.
Step 3- In cell C8 type in =sum(C1:C6) and then press Enter on the
keyboard.
Step
4- In cell C9 type in =average(C1:C6) and then press Enter on the keyboard.
Step
5- In cell C10 type in =max(C1:C6) and then press Enter on the keyboard.
Step
6- In cell C11 type in =min(C1:C6) and then press Enter on the keyboard.
Step
7- Go to cell C9 and type in =average(C1:C6,10)
Step 8- Save your work.