MOAC Excel 2016 Lesson 05

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)