S1 Spreadsheets Functions/Formulae

Which symbol is used at the beginning of all formulae and functions?

• +

• -

• =

• $

Which symbol is used in a formula for adding?

• *

• -

• /

• +

Which symbol is used in a formula for subtracting?

• *

• -

• /

• +

Which symbol is used in a formula for multiplying?

• *

• -

• /

• +

Which symbol is used in a formula for dividing?

• *

• -

• /

• +

What is the formula to add up A1 and B1?

• =SUM(A1:B1)

• =A1+B1

• A1+B1

• =ADD(A1:B1)

What is the formula to work out A2 take away B2?

• A2-B2

• =A2-B2

• =SUB(A2:B")

• =A2MINUSB2

What is the formula to multiply A3 by B3?

• =MULTIPLY(A3:B3)

• =A3xB3

• =A3*B3

• =A3TIMESB3

What is the formula to divide A4 by B4?

• =A4÷B4

• =A4DIVIDEB4

• =A4\B4

• =A4/B4

What is the function to add up A1 to B5?

• =A1+A2+A3+A4+A5+B1+B2+B3+B4+B5

• =(A1:B5)

• =SUM(A1:B5)

• =ADD(A1:B5)