Spreadsheet KS3

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which symbol must all formula begin with?

• =
• +
• (
• @

Which of the following formulas is not entered correctly?

• =10+50
• =B7+B8
• =B7+14
• 10+50

Columns go...

• Across
• Down

Rows go...

• Across
• Down

In a cell reference, for example A1, what does the letter refer to?

• The column
• The cell
• The row

Which of these symbols is used for divide on a computer?

• \
• *
• /
• |

Tags

CCSS.4.NBT.B.6

A cell name contains

• Cell name
• Column numbers and row letters
• Column letters and row numbers
• Cell locator coordinates

Which symbol means to multiply?

• /
• *
• SUM
• (  )

Tags

CCSS.5.OA.A.1

CCSS.5.OA.A.2

Which of these would correctly calculate the average of some data?

• Average = B3 - B8
• B3:B8(AVERAGE)
• =AVERAGE(B3:B8)
• =B3:B8