Quiz
Spreadsheets Quiz
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (15)
1Which of the following is capable of producing a spreadsheet Tick all that apply?
- AGoogle Docs
- BMicrosoft Office Excel
- CMicrosoft Office Word
2What word is used to describe re-organising the order of data?
- ASearch
- BFilter
- CSort
3In a cell reference, for example A1, what does the letter refer to?
- AThe row the cell is in
- BThe column the cell is in
- CThe worksheet the cell is in
4Formulae must always start with which symbol?
- AEquals
- BAdd
- CBrackets
5Which of the following tasks would a spreadsheet be best used for (tick all that apply)?
- APresent promotional information about a new television channel
- BCreating a budget for a party
- CKeep track of money raised at a charity event
- DTo write a letter of complaint
6Which tool is best used to duplicate information from cell to cell?
- AAutosum
- BFill Handle
- CFilter
7Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
- ABecause Mr Obhan can use bar charts
- BBecause they don't require you to enter any formula.
- CBecause you do not need to enter any data
- DBecause the data is presented in a more visual way.
8Wrap text is an option which can be applied to cells in order to do what? (Tick all that apply)
- AResize a cell to fit the text inside
- BPut a background on a cell containing text
- CPut a border around a cell containing text
- DPut text that is longer than the width of the cell on more than one line within the same cell
9The software can help guide us through the process of creating a chart. This is called a...?
- ATeacher
- BWizard
- CHelp
- DMagician
10What term describes changing the horizontal or vertical position of text?
- AFont
- BAlignment
- CFormat
11Getting cells to change colour automatically based on the contents of the cell is called...?
- AContent formating
- BConditional formatting
- CCell formatting
12Which function would we use to calculate the total of a column or a row?
- ASUM
- BADD
- CPLUS
13When we select a group of cells together to use in a formula this is called a..?
- ABlock
- BSheet
- CRange
14What function do we use to join a group of cells together to make a larger cell ?
- AMerge
- BVerge
- CCombine
15Spreadsheets can (tick all that apply)...?
- AComplete mathmatical calculations
- BPresent data in a visual way
- CProduce large written documents
- DSearch large amounts of data
Information
- Description
- Diagnosis and testing quiz about spreadsheets
- Author
- mpapworth
- Language
- English
- Views
- 400
- Tags
- Rating
- 3.0 out of 5 · 3 ratings Rate this quiz