Which of the following is capable of producing a spreadsheet Tick all that apply?
Google Docs
Microsoft Office Excel
Microsoft Office Word
What word is used to describe re-organising the order of data?
Search
Filter
Sort
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 (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?
Autosum
Fill Handle
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...?
Teacher
Wizard
Help
Magician
What term describes changing the horizontal or vertical position of text?
Font
Alignment
Format
Getting cells to change colour automatically based on the contents of the cell is called...?
Content formating
Conditional formatting
Cell formatting
Which function would we use to calculate the total of a column or a row?
SUM
ADD
PLUS
When we select a group of cells together to use in a formula this is called a..?
Block
Sheet
Range
What function do we use to join a group of cells together to make a larger cell ?
Merge
Verge
Combine
Spreadsheets can (tick all that apply)...?
Complete mathmatical calculations
Present data in a visual way
Produce large written documents
Search large amounts of data
