SS02 Spreadsheets Exit Task

What formula would give the correct answer to 14 x 7?

Which icon performs the multiply function in Excel or Spreadsheets?

• X

• T

• *

• /

What formula would give the correct answer to the sum?

What formula entered will give you the correct answer to question 3?

​ ​ ​

• =C5*E5

• C5-E5

• =C5-E5

• =F5-C5

• =E5-C5

What formula would give the correct answer to 8 x 77?

What formula would give the correct answer to 764 / 4

What will be the result of the following formula?

=SUM(C20:C22)

• REF

• 6

• 8

• SUM(C20:C22)

What will be produced by the following formula:

=C22+D22

• #VALUE!

• 2*

• 4

• 6

Answer explanation

Correct! Value is produced if there is an error in the calculation. Trying to multiply a number by a letter is not possible