Year 7 HT4 Spreadsheet basics

What is a cell in a spreadsheet?

• A single box where data is entered
• A whole row of data
• A formula
• A type of chart

How are columns labeled in most spreadsheets?

• Letters (A, B, C)
• Numbers (1, 2, 3)
• Roman numerals (I, II, III)
• Symbols (@, #, &)

What does B3 refer to in a spreadsheet?

• The cell at Column B, Row 3
• The third column in Row B
• A type of formula
• A type of function

What is A1:C3 an example of?

• A cell range
• A formula
• A function
• A table

What would the formula =A1 + B1 do?

• Add the values in A1 and B1
• Multiply the values in A1 and B1
• Subtract B1 from A1
• Display text "A1 + B1"

If a flag is created using A1:A3 is red, B1:B3 is white, which flag could it be?

• Poland
• Germany
• Japan
• Italy

A flag is designed with A1:A3 (green), B1:B3 (white), C1:C3 (green). Which flag does this resemble?

• Nigeria
• Ireland
• USA
• Sweden

Which of these is a correct range of cells in a spreadsheet?

• A1:A5
• 1A-5A
• Column B to Row 3
• A to 3

If a flag is designed with rows 1-2 (black), rows 3-4 (red), rows 5-6 (yellow), which flag does this represent?

• Germany
• Italy
• France
• Sweden

Which cell reference represents the fourth column and second row in a spreadsheet?

• D2
• 4B
• B4
• 2D