NEW
Font size
WorksheetsMOAC Excel 2016 Lesson 05
Total questions: 14
Worksheet time: 18mins
Which function calculates the TOTAL (adds all the cells in the range together)?
SUM
AVERAGE
MAX
MIN
Which function calculates the MEAN of a range of cells (adds all the cells together and then divides by the number of cells)?
MIN
AVERAGE
COUNT
MAX
You want to calculate the number of nonblank cells in your worksheet. Which function should be used?
SUM
COUNTA
MIN
MAX
Which function returns the highest value in a range?
SUM
AVERAGE
MAX
MIN
Which function returns the lowest value in a range?
SUM
AVERAGE
MAX
MIN
Which function would you use instead of this formula: =B1+B2+B3+B4+B5+B6+B7?
=SUM(B1:B7)
=COUNT(B1:B7)
=AVERAGE(B1:B7)
=MAX(B1:B7)
Which function would you use instead of this formula: =(B1+B2+B3+B4)/4?
=SUM(B1:B4)/4
=COUNT(B1:B4)/4
=AVERAGE(B1:B4)/4
=MAX(B1:B4)/4
Which function was used in E1?
=COUNT(A1:A9)
=COUNTA(A1:A9)
=COUNTBLANK(A1:A9)
Which function was used in E2?
=COUNT(B1:B9)
=COUNTA(B1:B9)
=COUNTBLANK(B1:B9)
Which function was used in E3?
=COUNT(B1:B9)
=COUNTA(B1:B9)
=COUNTBLANK(B1:B9)
Which function was used in E4?
=SUM(B1:B9)
=COUNT(B1:B9)
=AVERAGE(B1:B9)
Which function was used in E5?
=SUM(B1:B9)
=COUNT(B1:B9)
=AVERAGE(B1:B9)
Which function was used in E6?
=SUM(B1:B9)
=MIN(B1:B9)
=MAX(B1:B9)
Which function was used in E7?
=SUM(B1:B9)
=MIN(B1:B9)
=MAX(B1:B9)
