7.2 Lesson 3

What software can we use to organise data so it is easy to use?

• Word Document

• PowerPoint Presentation

• Spreadsheet

• Email

A cell reference tells you ...

• What data is in the cell

• Where the cell is on the spreadsheet

• What letter the column is

• What number the row is

What cell reference is highlighted?

• 4

• B4

• A4

• 4A

What cell reference is highlighted?

• C2

• 2C

• 2D

• D2

What cell range is highlighted?

• A4 : C4

• A5 : C5

• 5A : 5C

• 4A : 4C

What must always be at the start of a formula?

• +

• -

• *

• =

Which is the correct formula if I want to add the two numbers together?

• =A1 + B1

• A1 + B1

• =A1 + C1

• A1 + C1

Which is the correct formula if I want to divide the two numbers together?

• =A1 + B1

• =A1 / B1

• =A1 - B1

• =A1 * B1

Which is the correct formula if I want to multiply the two numbers together?

• =A1 + B1

• =A1 / B1

• =A1 - B1

• =A1 * B1

Which is the correct formula if I want to subtract the two numbers together?

• =A1 + B1

• =A1 / B1

• =A1 - B1

• =A1 * B1