Spreadsheet Functions Quiz

What is the purpose of the `=MAX()` function in a spreadsheet?

• To find the minimum value

• To find the average value

• To find the highest value

• To sum all values

If you have a list of 10 numbers in cells E1 to E10, what does the function `=COUNT(E1:E10)` do?

• Sums all the numbers

• Counts how many numbers are in the range

• Finds the maximum number

• Finds the average of the numbers

What does the function `=SUM(A1:A10)` do?

• Counts the number of cells in A1 to A10

• Finds the average of the values in A1 to A10

• Adds all the values in A1 to A10

• Finds the maximum value in A1 to A10

Which function would you use to find the highest value in the range B1:B5?

• MIN(B1:B5)

• AVERAGE(B1:B5)

• MAX(B1:B5)

• SUM(B1:B5)

What will the formula `=MIN(3, 7, 2, 5)` return?

• 3

• 2

• 5

• 7

What is the result of the formula `=SUM(10, 20, 30)` in a spreadsheet?

• 50

• 60

• 70

• 40

If you want to calculate the average of the numbers in cells D1 through D4, which formula would you use?

• =SUM(D1:D4)

• =AVERAGE(D1:D4)

• =MAX(D1:D4)

• =MIN(D1:D4)

If you have the numbers 5, 10, and 15 in cells A1, A2, and A3 respectively, what will the formula `=AVERAGE(A1:A3)` return?

• 10

• 15

• 5

• 20

If the values in cells C1, C2, and C3 are 8, 12, and 20, what will `=AVERAGE(C1:C3)` yield?

• 10

• 12

• 15

• 20

Using the `=SUM()` function, what will be the output of `=SUM(1, 2, 3, 4, 5)`?

• 10

• 15

• 20

• 25