Mastering Basic Spreadsheet Functions

Which of the following is the correct formula to calculate the sum of cells A1 to A10 in a spreadsheet?

• `=ADD(A1:A10)`

• `=SUM(A1:A10)`

• `=TOTAL(A1:A10)`

• `=COMBINE(A1:A10)`

What function would you use to find the average of the numbers in cells B1 to B5?

• `=MEAN(B1:B5)`

• `=AVERAGE(B1:B5)`

• `=MEDIAN(B1:B5)`

• `=MODE(B1:B5)`

Which function would you use to find the maximum value in a range of cells from C1 to C20?

• `=MAXIMUM(C1:C20)`

• `=HIGHEST(C1:C20)`

• `=MAX(C1:C20)`

• `=LARGEST(C1:C20)`

If you want to count the number of cells in the range D1 to D10 that contain numbers, which function should you use?

• `=COUNT(D1:D10)`

• `=COUNTA(D1:D10)`

• `=COUNTIF(D1:D10)`

• `=COUNTNUM(D1:D10)`

Which function would you use to find the smallest number in a range of cells E1 to E15?

• `=MINIMUM(E1:E15)`

• `=LOWEST(E1:E15)`

• `=MIN(E1:E15)`

• `=SMALLEST(E1:E15)`

What is the correct formula to calculate the product of the values in cells F1, F2, and F3?

• `=PRODUCT(F1:F3)`

• `=MULTIPLY(F1:F3)`

• `=PROD(F1:F3)`

• `=MULT(F1:F3)`

Which function would you use to determine the median value of a dataset in cells G1 to G10?

• `=MEDIAN(G1:G10)`

• `=AVERAGE(G1:G10)`

• `=MIDDLE(G1:G10)`

• `=CENTRE(G1:G10)`

If you want to count the number of non-empty cells in the range H1 to H20, which function should you use?

• `=COUNT(H1:H20)`

• `=COUNTA(H1:H20)`

• `=COUNTBLANK(H1:H20)`

• `=COUNTIF(H1:H20)`