Spreadsheets

TRUE or FALSE

Information is raw facts and figures without any meaning

• True

• False

TRUE or FALSE

Data is raw facts and figures with out any meaning

• True

• False

Information is data which has been processed to give it meaning and a context

• True

• False

Which of the following is capable of producing a spreadsheet?

• Microsoft Excel

• Microsoft Access

• Microsoft PowerPoint

• Microsoft Word

A1 is a . . .

• Cell reference

• Row

• Column

• Cell

A Spreadsheet is . . . .

• an application that allows data to be organised, stored and manipulated

• an application that provides for input, editing, formatting, and output of text, often with some additional features.

• an application used to correct exposure and colour balance, crop and straighten images, alter colours in your photograph.

Formulae must always start with which symbol?

• +

• =

• /

• *

Which of the following tasks would a spreadsheet be best used for?

• Present information about a new television channel

• Keep track of money raised at a charity event

• Manage the details of members at a gym

Which tool is best used to duplicate information from cell to cell?

• Autosum

• Fill handle

• Filter

Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?

• Because the data is presented in a more visual way.

• Because they don't require you to enter any formula.

• Because primary school children can use bar charts.