WorksheetsLO5 - Spreadsheets (2)
Total questions: 16
Worksheet time: 8mins
What are the individual boxes on a spreadsheet called?
Squares
Cells
Entry boxes
What can be used to uniquely identify each cell in a spreadsheet?
Cell reference
Column heading
Row number
What are the separate pages of a spreadsheet called?
Spreadsheets
Pages
Worksheets
What do you write to perform calculations in a spreadsheet?
Computer programs
Instructions
Formulas/Functions
Which of the following is the correct formula to calculate 8 divided by 2?
=8/2
8/2
=8*2
In what format should a cell with a money value entered into be in?
Currency
Text
Numbers
Which of the following is capable of producing a spreadsheet?
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
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
Formulas and functions must always start with which symbol?
Brackets
Add
Equals
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 everyone can use bar charts
Because they don't require you to enter any formula
Because the data is presented in a more visual way
How is the information in spreadsheets laid out?
In a circle
In a spider diagram
In rows and columns
What is the main function of a spreadsheet?
To organise information and automatically make calculations from the data in the cells
To spread data over a large surface area
To make data transparent so that the user can see the binary code
Which type of statement can check if a statement is true or false?
WHEN statement
HOW statement
IF statement
A series of instructions and/or actions that can be recorded and then set to run whenever you need to perform the same task in future is called what?
A macro
A micro
A mini
