2023-24 - Y8 - Data Modelling EOU Assessment

Which of these statements is NOT true about spreadsheets?

• Spreadsheets calculate data using different operations and functions
• Spreadsheets with formulas do not update when values are changed
• Spreadsheets are used for storing, displaying, sorting and manipulating data
• Spreadsheets are used for modelling data

What is the correct name for the part of a spreadsheet labelled 'A'?

• Row
• Active Cell
• Cell
• Column

What is the correct name for the part of a spreadsheet labelled 'B'?

• Column
• Row
• Active Cell
• Cell

What is the correct name for the part of a spreadsheet labelled 'C'?

• Active Cell
• Column
• Cell
• Row

What is the correct name for the part of a spreadsheet labelled 'D'?

• Cell
• Active Cell
• Column
• Row

Which of these statements is NOT true about cell references?

• A cell reference is a combination of a column letter and row number
• A cell reference identifies a cell on a spreadsheet worksheet
• Each cell reference on a worksheet is unique
• A cell reference can only be used in one formula

What is the cell reference for the cell shown in orange?

• 2A
• AA
• A2
• 22

Which of these statements is NOT true about cell ranges?

• A cell range is represented by the cell reference of the upper left cell and the lower right cell
• The two cell references that make up a cell range are separated by a colon :
• A cell range is a block of two or more cells
• There is a limit of 30 cells in a cell range

What is the cell range for the cells shown in blue?

• E1:C1
• C1:E6
• CC:EE
• C1:C6

If in cell D3 you have =A1, what cell does D3 refer to?

• D3
• A1
• D1
• A3