Chapter 4 - Spreadsheets

Spreadsheet Rows Are Identified By

• Numbers

• Letter

• Roman Numerals

• Colours

Spreadsheet Columns Are Identified By

• Roman Numerals

• Numbers

• Letters

• Colours

Individual Boxes In Spreadsheets Are Called:

• Squares

• Ranges

• References

• Cells

Calculations Can Performed Using

• Variable

• Formulae

• Conditonal Formatting

• Macros

All Formulae Begin With

• !

• -

• +

• =

Name This Cell

• B10

• 5B

• B5

• you cannot know the name from this picture

What Is Displayed In A6?

• Monday

• Tuesday

• Wednesday

• Thursday

To Multiply In An Excel Formula Use:

• +

• -

• *

• /

Correct Order For A Cell Reference?

• Letter then Number

• Number then Letter

SUM, AVERAGE, MAX & VLOOKUP Are Examples Of

• Functions

• Tables

• Formulae

• Statistical Tools