Have an account?
Skip to Content
Build your own quiz
Suggestions for you
.png)
25 questions
Show Answers
See Preview
- 1. Multiple Choice
Cells that run horizontally on a spreadsheet
Row
Column
Workbook
Range
- 2. Multiple ChoiceCells that run vertically on a spreadsheetRowWorkbookWorksheetColumn
- 3. Multiple ChoiceWhat is normally used to perform calculations in a spreadsheet?VariableFormulaConditional formatingMacro
- 4. Multiple ChoiceWhen you key a formula in a spreadsheet what do you key in first?Subtraction signEqual SignAddition signDivision sign
- 5. Multiple Choice
You can present your data graphically, using achartprintfontsort - 6. Multiple ChoiceTo show the quantities in particular categories use a?Column ChartLine GraphScatter GraphSort Chart
- 7. Multiple ChoiceWhich chart should you use to show changes over time?LineScatterPieBar
- 8. Multiple ChoiceWhich formula would subtract D12 from D13?=D13-D12=D12-D13=sum(D12-D13)=sum(D13-D12)
- 9. Multiple ChoiceWhat does cell B6 contain?230.450.5023
- 10. Multiple Choice
What symbol should be used to perform an adding calculation?
+
-
*
/
- 11. Multiple Choice
What symbol should be used to perform a subtraction calculation?
-
*
+
/
- 12. Multiple Choice
What symbol should be used to perform a multiplying calculation?
+
-
*
/
- 13. Multiple Choice
What symbol should be used to perform a division calculation?
/
-
*
+
- 14. Multiple Choice
What software do we use to create spreadsheets?
Word
PowerPoint
Sway
Publisher
Excel
- 15. Multiple Choice
What are spreadsheets used for?
To perform powerful calculations
Make graphs and charts
Analyse patterns in the data
To store information and data
- 16. Multiple Choice
A spreadsheet is made up of one "workbook" and can have have many "worksheets".
True
False
- 17. Multiple Choice
Worksheets appear as tabs at the bottom of the spreadsheet.
True
False
- 18. Multiple Choice
What is the name of each "box" on a spreadsheet?
Cell
Box
Rectangle
- 19. Multiple Choice
A cell reference is the specific location of the active cell (E.g. A1).
True
False
- 20. Multiple Choice
What is the correct order for the parts that make up a Cell Reference?
Letter then Number
Number then Letter
- 21. Multiple ChoiceAn individual box within a worksheet is known as?squarerangereferncecell
- 22. Multiple ChoiceWhich of the following would NOT be stored in a cell?FormulaTextNumberChart
- 23. Multiple Choice
What is normally used to perform calculations in a spreadsheet?
Magic
Formula
Conditional formating
Macro
- 24. Multiple ChoiceWhich of the following is an example of a cell reference?a. Column Cb. =SUMc. Row 1d. A5
- 25. Multiple ChoiceThe cell in which you are currently working is known as what?Active cellCell addressCell referenceSpreadsheet cell
- Answer choicesTagsAnswer choicesTags