Y7_Spreadsheets

Choose the correct cell reference for John's Science score.

• C5

• 5C

• 65

• John Science

Choose the correct cell reference for Eden's Science score.

• C6

• 6C

• 65

• John Science

Choose the correct cell reference that covers every score for all 4 students.

• B4:D7

• A4:D7

• B4:D4

• B4, B7, C4, C7, D4, D7

Which of these formula correctly shows multiplication?

• A

• B

• C

• D

Which of the following formula would not work correctly?

• =(C3+D3)

• =SUM(C3+D3)

• =C3+D3

• (C3+D3)

Which of the following tools would you use to reduce the number of decimal pointsbeing displayed?

• A

• B

• C

• D

Which of these formula will display the total of a set of cells?

• A

• B

• C

• D

Choose the correct result after the COUNT formula has been run on this data.

• 1308

• 12

Choose the correct result after the COUNT formula has been run on this data.

• 1308

• 12

Choose the correct result after the SUM formula has been run on this data.

• 1308

• 12