Which of the following is NOT capable of producing a spreadsheet?
Open Office Calc
Microsoft Office Excel
Microsoft Office Word
What word is used to describe re-organising the order of data?
Search
Sort
Fill
In a cell reference, for example A1, what does the letter refer to?
The row the cell is in
The column the cell is in
The worksheet the cell is in
Formulae must always start with which symbol?
Equals
Add
Brackets
Which of the following tasks would a spreadsheet be best used for?
Present information about a new television channel
Manage the details of members at a gym
Keep track of money raised at a charity event
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 primary school children can use bar charts.
Because they don't require you to enter any formula.
Because the data is presented in a more visual way.
Wrap text is an option which can be applied to cells in order to do what?
Put a border around a cell containing text
Put a background on a cell containing text
Resize a cell to fit the text inside
The software can help guide us through the process of creating a chart. This is called a...?
Help
Wizard
Magician
What term describes changing the horizontal or vertical position of text?
Font
Alignment
Format