3MD.04 — understanding that spreadsheets are made of rows and co

What is one small box you can click in a spreadsheet called?

• Page

• Cell

• Picture

• File

Answer explanation

In a spreadsheet, a small box that you can click is called a 'cell'. Each cell can hold data, such as text or numbers, making it a fundamental component of spreadsheet functionality.

What do you call the horizontal lines of cells across the page?

• Columns

• Boxes

• Rows

• Pages

Answer explanation

The horizontal lines of cells across the page are called rows. Each row contains multiple cells arranged side by side, distinguishing them from columns, which are vertical.

What do you call the vertical lines of cells going up and down?

• Lines

• Columns

• Rows

• Words

Answer explanation

The vertical lines of cells in a table are called columns. Each column contains data that is organized vertically, distinguishing it from rows, which are horizontal.

How do you tell a cell’s position by using letters and numbers?

• Colour and size

• Column letter and row number (e.g., A1)

• Font and style

• Page number

Answer explanation

A cell's position in a spreadsheet is identified by its column letter and row number, such as A1. This format allows users to easily locate and reference specific cells.

Where would you type your name in a spreadsheet?

• On the desk

• In a cell

• In a picture only

• In the printer

Answer explanation

In a spreadsheet, you type your name in a cell, which is the basic unit for data entry. The other options do not pertain to where text can be entered in a spreadsheet.

Which is true about a spreadsheet?

• It has only pictures

• It is only for drawing

• It has rows and columns of cells

• It cannot store numbers

Answer explanation

A spreadsheet is organized into rows and columns of cells, allowing for data entry, calculations, and analysis. The other options are incorrect as spreadsheets can contain numbers and are not limited to pictures or drawing.

If you click on cell B3 and type 5, where does 5 go?

• In the whole sheet

• Only in cell B3

• In every cell automatically

• In the printer tray

Answer explanation

When you click on cell B3 and type 5, the value 5 is entered only in cell B3. It does not affect other cells or the entire sheet.

What happens when you press Enter after typing in a cell?

• The computer turns off

• The entry is stored in that cell and the cursor moves

• All cells delete

• The font changes color only

Answer explanation

When you press Enter after typing in a cell, the entry is stored in that cell, and the cursor moves to the next cell. This allows for efficient data entry in spreadsheet applications.

Which shows a cell name correctly?

• 3A

• Row1

• C4

• Box5

Answer explanation

The correct cell name is C4, which follows the standard format of a column letter followed by a row number. Other options like 3A, Row1, and Box5 do not conform to this naming convention.

You want to put students’ names down the side. Which should you use?

• Columns across the top

• A column (one name per cell vertically)

• A picture file

• A row with all names in one cell

Answer explanation

To list students' names vertically, you should use a column with one name per cell. This format allows for clear organization and easy readability, unlike rows or pictures which do not effectively display names.