Topic 1 (HW 1): Spreadsheets

"The exact location of a cell within a spreadsheet"

• Cell Reference

• Cell Location

• Cell Area

What is the cell reference of the yellow cell?

• B5

• 5B

An individual box/square within a spreadsheet is called a ____

Select all correct cell references for the yellow cells

• D3:F4

• D3, E3, F3, D4, E4, F4

• 3D:4F

• 3D, 3E, 3F, 4D, 4E, 4F

Spreadsheets allow you to organise large amounts of data

• True

• False

Which of the following keyboard symbols is used to represent multiplication in a spreadsheet?

• *

• /

• #

• ~

Spreadsheets cannot be used to carry out calculations

• True

• False

Select the correct formula to display the total of these two numbers in the yellow cell

• =sum (B4 + C4)

• =sum(4B + 4C)

• sum (B4 + C4)

Select the correct formula to display the multiplication of these two numbers in the yellow cell

• =sum (B4 * C4)

• =sum(4B * 4C)

• sum (B4 * C4)

Which keyboard symbol must be included at the beginning of a formula?