12D substitution 3/2/2025

What is the term used for each box in a spreadsheet?

• Cell

• Box

• Field

• Record

What is the term used for cells which appear going across the spreadsheet?

• Column

• Record

• Field

• Row

What is the term used for cells which appear going up and down the spreadsheet?

• Field

• Row

• Column

• Record

A cell can contain text, values and what else?

• Currency

• Percentages

• Formulae

• Dates

What symbol is used to multiply?

• /

• -

• +

• *

What symbol is used to divide?

• *

• +

• /

• -

How must a cell containing a formula start?

• SUM

• =

• +

• ( )

What function is used to add more than 2 cells?

• +

• =

• SUM

• ( )

Which formula would you use to multiply cell B4 by cell C4?

• =B4*C4
• =B4xC4
• =(B4:C4)
• B4xC4=

Spreadsheet rows are easily identified by:

• a. numbers.
• b. letters.
• c. Roman numerals.
• d. colors.