NEW
Font size
WorksheetsREVIEW QUIZ
Total questions: 15
Worksheet time: 8mins
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 2nd 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 4th 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
Refer to the picture. What is in the cell address A12?
*Music
*Arts
*PE
*Health
Refer to the picture. What is in the cell address A1?
REPORT CARD
AVERAGE
1ST
SUBJECTS
Refer to the picture. What is the cell address of "3RD"?
D1
D2
D3
D4
In MS EXCEL, which of the following formulas will possibly get an error message?
=Min(N2,N3,N4)
=AverageF3,F4,F5,F6
=Max(L1:L9)
=Sum(B9:B99)
In MS EXCEL, which of the following formulas will possibly get an error message?
=Min(N2,N3,N4)
=AverageF3,F4,F5,F6
=Max(L1:L9)
=Sum(B9:B99)
