WorksheetsFunctions
Total questions: 20
Worksheet time: 40mins
What is the correct formula using a function to find the sum of cells A1 to A12?
(a)
What is the correct formula using a function to find the average of cells B1 to B12?
(a)
What is the correct formula using a function to find the count of cells C1 to C12?
(a)
What is the correct formula using a function to find the maximum number in cells D1 to D12?
(a)
What is the correct formula using a function to find the minimum number in cells E1 to E12?
(a)
What is the correct formula using a function to find the sum of cells F1 to F12?
(a)
What is the correct formula using a function to find the average of cells G1 to G12?
(a)
What is the correct formula using a function to find the count of cells H1 to H12?
(a)
What is the correct formula using a function to find the maximum number in cells I1 to I12?
(a)
What is the correct formula using a function to find the minimum number in cells J1 to J12?
(a)
What is the correct formula using a function to find the sum of cells K1 to K12?
(a)
What is the correct formula using a function to find the average of cells L1 to L12?
(a)
What is the correct formula using a function to find the count of cells M1 to M12?
(a)
What is the correct formula using a function to find the maximum number in cells N1 to N12?
(a)
What is the correct formula using a function to find the minimum number in cells O1 to O12?
(a)
What is the correct formula using a function to find the sum of cells P1 to P12?
(a)
What is the correct formula using a function to find the average of cells Q1 to Q12?
(a)
What is the correct formula using a function to find the count of cells R1 to R12?
(a)
What is the correct formula using a function to find the maximum number in cells S1 to S12?
(a)
What is the correct formula using a function to find the minimum number in cells T1 to T12?
(a)
