Y8 spreadsheets L1 review

Which cell is the word “Fruit” in?

• B3

• C1

• B2

• C2

Which of the following would be an appropriate formula for cell D3

• =B3*C3

• =B3+C2

• =B3+C3

• =C3+D3

When working with spreadsheets which symbol represents “Multiply”

• x

• *

• /

• X

When working with spreadsheets which symbol represents “Divide”

• x

• ÷

• /

• X

Cells that run horizontally on a spreadsheet

• Row

• Column

• Workbook

• Range

Cells that run vertically on a spreadsheet

• Row
• Workbook
• Worksheet
• Column

When you key a formula in a spreadsheet what do you key in first?

• Subtraction sign
• Equal Sign
• Addition sign
• Division sign

I can find the lowest number in a range with the ... function

• MIN
• MAX
• AVERAGE
• COUNT

Which formula would subtract D12 from D13?

• =D13-D12
• =D12-D13
• =sum(D12-D13)
• =sum(D13-D12)

What function can be used to find the largest number in a range of numbers?

• =MIN
• =MAX
• =AVERAGE
• =SUM