Spreadsheet Formulas Quiz

Which symbol do you always start with to write a formula in a spreadsheet?

• +

• =

• -

• /

What does the formula =A1 + B1 do?

• Multiplies A1 by B1

• Adds the values in cells A1 and B1

• Subtracts B1 from A1

• Copies A1 to B1

Which formula will find the sum of cells A1 to A5?

• =SUM(A1:A5)

• =ADD(A1:A5)

• =TOTAL(A1:A5)

• =AVERAGE(A1:A5)

What does the formula =A1 - B1 do?

• Multiplies A1 by B1

• Adds A1 and B1

• Subtracts B1 from A1

• Divides A1 by B1

Which formula calculates the average of values in cells A1 to A4?

• =AVERAGE(A1:A4)

• =SUM(A1:A4)/4

• =MIN(A1:A4)

• =COUNT(A1:A4)

What does the formula =A1 * B1 do?

• Adds A1 and B1

• Subtracts A1 from B1

• Multiplies A1 by B1

• Divides A1 by B1

Which function finds the largest value in cells A1 to A10?

• =SUM(A1:A10)

• =MAX(A1:A10)

• =MIN(A1:A10)

• =AVERAGE(A1:A10)

What does the formula =MIN(B1:B5) do?

• Finds the smallest value in B1 to B5

• Finds the largest value in B1 to B5

• Finds the total of B1 to B5

• Finds the average of B1 to B5

What does the formula =A1 / B1 do?

• Adds A1 and B1

• Divides A1 by B1

• Multiplies A1 by B1

• Subtracts B1 from A1

What is the purpose of the =COUNT(A1:A10) function?

• Adds all the values in A1 to A10

• Counts the number of cells with numbers in them

• Finds the largest value in A1 to A10

• Finds the smallest value in A1 to A10