Which of the following is capable of producing a spreadsheet Tick all that apply?
Microsoft Office Excel
Microsoft Office Word
What word is used to describe re-organising the order of data?
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?
Which of the following tasks would a spreadsheet be best used for (tick all that apply)?
Present promotional information about a new television channel
Creating a budget for a party
Keep track of money raised at a charity event
To write a letter of complaint
Which tool is best used to duplicate information from cell to cell?
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Because Mr Obhan can use bar charts
Because they don't require you to enter any formula.
Because you do not need to enter any data
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? (Tick all that apply)
Resize a cell to fit the text inside
Put a background on a cell containing text
Put a border around a cell containing text
Put text that is longer than the width of the cell on more than one line within the same cell
The software can help guide us through the process of creating a chart. This is called a...?
What term describes changing the horizontal or vertical position of text?
Getting cells to change colour automatically based on the contents of the cell is called...?
Which function would we use to calculate the total of a column or a row?
When we select a group of cells together to use in a formula this is called a..?
What function do we use to join a group of cells together to make a larger cell ?
Spreadsheets can (tick all that apply)...?
Complete mathmatical calculations
Present data in a visual way
Produce large written documents
Search large amounts of data