Comp Sci - KS3 - MS Excel Spreadsheet Formulas 1

What symbol is used for formulas ?

• =

• !

• £

• {

What symbol is used for addition?

• *

• /

• +

• -

What symbol is used for subtraction (take away)?

• *

• /

• +

• -

What symbol is used for division (divide)?

• *

• /

• +

• -

What symbol is used for multiplication (times)?

• *

• /

• +

• -

What is =B2 + C2 ?

• 2

• 10

• 1

• 11

What is =A2 - C1 ?

• 2

• 10

• 1

• 11

What is =B1 * B2 ?

• 2

• 10

• 1

• 11

What is =A1 + A2 + B2 ?

• 3

• 10

• 1

• 11

What is =C2 / B1 ?

• 3

• 10

• 1

• 11