Which of the following functions will return the total of a range of numbers?

• COUNT

• ADD

• TOTAL

• SUM

What will =AVERAGE(2,4,6,8) return?

• 4

• 6

• 5

• 10

The formula =MAX(A1:A5) returns:

• The smallest value in A1 to A5

• The average

• The highest value

• Count of values

What does =COUNT(A1:A10) count?

• Non empty cell

• All cell

• Only text

• Numeric value

COUNTA(A1:A5) counts:

• Only number

• Only formula

• All non empty cells

• Only errors

What will =MEDIAN(7, 3, 9) return?

• 3

• 9

• 7

Which function will count blank cells in a range?

• COUNT

• COUNTBLANK

• ISBLANK

• COUNTA

The function =STDEV.P(range) calculates:

• Median

• Sample standard derivation

• Population standard derivation

• Mean

To count cells where value is more than 100, which is correct?

• =COUNT(A1:A10,>100)

• =COUNTIF(A1:A10,">100")

• =COUNTA(A1:A10,100)

• =COUNTIFS(A1:A10>100)

What is the purpose of =ROUND(3.567,2)?

• 3.56

• 3.57

• 3.6

• 4