Spreadsheet Formulas

A ​ (a)   uses a rectangular ​ (b)   made up of rows and ​ (c)   to ​ (d)   and store data that requires some type of ​ (e)   .

• spreadsheet
• grid
• columns
• organise
• calculation

All spreadsheets consist of rows that run ​ (a)   across the screen and columns that run ​ (b)   down the screen.

• horizontally
• vertically

A cell is the ​ (a)   of a row and column. The position of the cell in the spreadsheet is called its ​ (b)   (or cell address).

• intersection
• cell reference

​ (a)   are instructions to perform a ​ (b)   .

• Formulas
• calculation
• Data
• action

What is the cell reference for the following data in the spreadsheet shown:

Monday = ​ (a)   | 18.92 = ​ (b)  

Airborne = ​ (c)   | 36.72 = ​ (d)  

• C8
• B3
• D8
• A7

Write down the data stored in these cells of the spreadsheet shown.

B2

• Title

• Ben Hur

• 9

• Rental Price

What data is stored in the cells of the spreadsheet shown: C4 =​ (a)   | E6 = ​ (b)   |

| G2 = ​ (c)   | F12 = ​ (d)   |​

• Galaxy
• Amount
• 22
• 175

What is a spreadsheet primarily used for?

• Sending Email

• Organizing and analysing data

• Draw pictures

• Playing games

A ​ (a)   in a spreadsheet is an ​ (b)   of a row and a​ (c)  

• cell
• intersection
• column.

The ​ (a)   of a spreadsheet ​ (b)   is to perform ​ (c)   on data such as numbers

• formula
• calculations
• function