Spreadsheet Formula Quiz - Year 8

Cell A1 = 10, B1 = 5. What is the result of =A1 + B1?

• 50

• 105

• 15

• 5

Cell C2 = 12, C3 = 3. What is the result of =C2 / C3?

• 36

• 9

• 15

• 4

What does =SUM(A2:A5) do?

• Subtracts A5 from A2

• Adds values from A2 to A5

• Finds the largest value

• Multiplies A2 to A5

Cell E1 = 22, E2 = 7. What is the result of =E1 - E2?

• 15

• 14

• 5

• 29

Which formula adds values in cells C1, C2, and C3?

• =SUM(C1*C2*C3)

• =C1 x C2 x C3

• =ADD(C1:C3)

• =C1+C2+C3

Cell D2 = 6, D3 = 3. What does =D2 * D3 return?

• 3

• 18

• 9

• 2

Cell F1 = 100, F2 = 25. What does =F1 / F2 return?

• 75

• 125

• 4

• 25

What does the formula =AVERAGE(B1:B4) do?

• Calculates the mean of B1 to B4

• Counts the cells

• Adds B1 to B4

• Subtracts B4 from B1

Which formula finds the highest number from A1 to A5?

• =TOP(A1:A5)

• =HIGH(A1:A5)

• =MAX(A1:A5)

• =MIN(A1:A5)

What does =COUNT(B1:B10) do?

• Counts how many numbers are in B1 to B10

• Adds the values

• Multiplies them

• Finds the max