Spreadsheet Starter

What is a spreadsheet used for?

• Editing photos

• Organising, calculating, and analysing data

• Calculate data only

• Writing up numbers

In a spreadsheet, what is a "cell"?

• A type of battery

• A special formula

• A row of numbers

• A single box where data is entered

What symbol is used to start a formula in a spreadsheet?

• @

• %

• +

• =

What is the purpose of the SUM function?

• To add up a range of numbers

• To format text

• To multiply numbers

• To sort data

What happens when you click on the bottom right corner of a cell and drag it down?

• It deletes the data in the selected cells

• It moves the cell to another sheet

• It copies the value and fills the cells below (AutoFill)

• It locks the cell so it cannot be edited

What symbol is used for division in spreadsheets

• /

• *

• ^

• +

The entire spreadsheet is composed of rows and columns of cells.

• True

• False

In spreadsheets, columns are marked with _________.

• Letters

• Numbers

• Signs

• Formulas

In spreadsheets, rows are marked with _____.

• Letters

• Numbers

• Signs

• Formulas

Which of the following is an example of a cell reference or cell address?

• =A1+A2

• B4

• 9

• C