Unit 04 - Produce a range of spreadsheets

What do all calculations start with?

• =

• (

• -

• \

What symbol should be used to perform an adding calculation?

• +

• -

• *

• /

What symbol should be used to perform a multiplying calculation?

• +

• -

• *

• /

A spreadsheet is made up of one "workbook" and can have have many "worksheets".

• True

• False

What is the name of each "box" on a spreadsheet?

• Cell

• Box

• Rectangle

What is the name for a line of cells that go across the spreadsheet?

• Row

• Column

• Field

• Record

What is the name for a line of cells that go down the spreadsheet?

• Cell

• Row

• Field

• Record

• Column

A cell reference is the specific location of the active cell (E.g. A1).

• True

• False

What is the correct order for the parts that make up a Cell Reference?

• Letter then Number

• Number then Letter

The cell in which you are working, outlined in a darker color than the rest of the cells

• Last Cell

• Next Cell

• Active Cell

• Inactive Cell