REVIEW QUIZ

In MS EXCEL, which of the following is NOT an example of functions?

• Average

• Add

• Min

• Max

In MS EXCEL, what do you call the combination of letters and numbers?

• Text Box

• Cell Address

• Cell Name

• Cell

Refer to the picture. What is the cell address of the subject "English"?

• A4

• B4

• C4

• D4

Refer to the picture. What is the cell address of the word "Average"?

• F16

• E16

• D16

• C16

Refer to the picture. What is the cell address of the final grade "84”?

• F9

• E9

• D9

• C9

Refer to the picture. What formula should be used to know the lowest grade in 2^nd Grading?

• MIN(C3-C15)

• MIN(C3:C15)

• =MIN(C3:C14)

• =MIN(C3:C15)

Refer to the picture. What formula should be used to know the highest grade in 4^th Grading?

• =MAX(E3-E15)

• MAX(E3-E15)

• =MAX(E3:E15)

• MAX(E3:E15)

Refer to the picture. What formula should be used to know the total number of grades in Journalism subject?

• =Add(B15-E15)

• Sum(B15,B16,B17,B18)

•        Sum(B15:B18)

• =Sum(B15:E15)

Refer to the picture. What is the formula used in cell F7?

• =AVE(   B7,C7,D7,E7) 

• Ave(B7,C7,D7,E7)

• =Average(B7:E7)

• Average(B7:E7)

Refer to the picture. What is in the cell address E8?

• 82

• 83

• 80

• 85