Spreadsheet Basics

What do we call each box in a spreadsheet?

• Cell

• Box

• Field

• Record

Answer explanation

In a spreadsheet, each individual box is called a 'cell'. Cells are where we type in data.

Identify the cell reference

• Column A

• Row 1

• F

• A2

Answer explanation

The cell reference is 'A2' where 'A' is the column and '2' is the row.

Which of these is the correct cell reference?

• 10A

• A-10

• 1A0

• A10

Answer explanation

The correct cell reference is A10 where A is the column and 10 is the row.

What is the cell reference?

• C11

• C10

• C9

• A1

Answer explanation

The cell reference C9 is the correct answer in the picture, while C10, C11, and A1 are different cells.

Which cell is the word “Fruit” in?

• B3

• C1

• B2

• C2

Answer explanation

The word 'Fruit' is located in cell B2, as indicated by the correct answer. The other options (B3, C1, C2) do not contain the word 'Fruit'.

Cells that run horizontally on a spreadsheet

• Row

• Column

• Workbook

• Range

Answer explanation

In a spreadsheet, cells that run horizontally are referred to as rows. Each row is identified by a number, while columns run vertically and are identified by letters.

Cells that run vertically on a spreadsheet

• Row

• Workbook

• Worksheet

• Column

Answer explanation

In a spreadsheet, cells that run vertically are referred to as columns. Each column is identified by a letter, while rows run horizontally and are identified by numbers.

What symbol is used for ADDITION?

• -

• +

• *

• /

Answer explanation

The symbol used for addition is '+'. It is commonly used in mathematics to indicate that two or more numbers should be added together.

What symbol is used for SUBTRACTION?

• -

• +

• *

• /

Answer explanation

The symbol used for subtraction is '-'. It is used for taking one number away from another.

What symbol is used for DIVISION?

• -

• +

• *

• /

Answer explanation

The symbol used for division in mathematics is '/'. It is used for dividing one number by another.