Spreadsheet Final Test

Which function is used to add numbers in a range?

• =ADD(A1:A5)

• =SUM(A1:A5)

• =TOTAL(A1:A5)

• =COUNT(A1:A5)

What will =AVERAGE(10, 20, 30) return?

• 20

• 30

• 15

• 25

Which function returns the smallest number in a range?

• =MAX(A1:A10)

• =MIN(A1:A10)

• =LOW(A1:A10)

• =AVERAGE(A1:A10)

If cells A1 to A5 contain 5, 8, 2, 10, 7, what is the result of =MAX(A1:A5)?

• 10

• 7

• 5

• 8

Which function counts only numeric values in a range?

• =COUNTA(A1:A10)

• =COUNT(A1:A10)

• =COUNTNUM(A1:A10)

• =SUM(A1:A10)

If cells A1 to A3 contain: 4, 6, "Hello", what is the result of =COUNTA(A1:A3)?

• 2

• 3

• 4

• Error

What is the correct formula to find the average of cells B1 to B4?

• =AVG(B1:B4)

• =AVERAGE(B1:B4)

• =MEAN(B1:B4)

• =SUM(B1:B4)/COUNT(B1:B4)

What will =IF(A1>50, "Pass", "Fail") return if A1 is 60?

• Fail

• Pass

• 60

• TRUE

Which formula finds the largest value between 3, 15, and 9?

• =LARGE(3,15,9)

• =MAX(3,15,9)

• =BIGGEST(3,15,9)

• =TOP(3,15,9)

If you want to count all non-empty cells in a range, which function should you use?

• =COUNTA()

• =COUNT()

• =COUNTIF()

• =SUM()