Font size
WorksheetsSpreadsheets
Total questions: 50
Worksheet time: 25mins
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
What is highlighted in yellow in the picture here?
B
A row
A column
Nothing
What do all formulas begin with?
=
f
sum
if
What is a formula?
A standard routine, used to perform tasks such as =sum()
A calculation in a spreadsheet, for example, =B1+F2
A compound, for example, A=P(1+r)
A list of ingrdients such as 3 parts of water + squash
What is a function?
A standard routine, used to perform tasks such as =sum()
A calculation in a spreadsheet, for example, =B1+F2
A compound, for example, A=P(1+r)
A list of ingrdients such as 3 parts of water + squash
What is the purpose of the following function: =sum(F2:F5)
Find the total value of the cells F2 to F5
Find the average value of the cells F2 to F5
Find the highest value of the cells F2 to F5
Find the lowest value of the cells F2 to F5
What is the purpose of the following function: =MIN(F2:F5)
Find the total value of the cells F2 to F5
Find the average value of the cells F2 to F5
Find the highest value of the cells F2 to F5
Find the lowest value of the cells F2 to F5
What is the purpose of the following function: =MAX(F2:F5)
Find the total value of the cells F2 to F5
Find the average value of the cells F2 to F5
Find the highest value of the cells F2 to F5
Find the lowest value of the cells F2 to F5
In a spreadsheet what is the symbol used to ADD two cells together?
- e.g. =B2-B3
* e.g. =B2*B3
+ e.g. =B2+B3
/ e.g. =B2/B3
In a spreadsheet what is the symbol used to MULTIPLY two cells together?
- e.g. =B2-B3
* e.g. =B2*B3
+ e.g. =B2+B3
/ e.g. =B2/B3
In a spreadsheet what is the symbol used to SUBTRACT one cell from another?
- e.g. =B2-B3
* e.g. =B2*B3
+ e.g. =B2+B3
/ e.g. =B2/B3
What does Conditional Formatting do in a spreadsheet?
Calculates the total of a group of cells.
Subtracts one cell from another.
Adds a specified colour and border to a group of cells whatever value is in the cell.
Adds a specified colour and border to a group of cells when a specific value is in the cells.
Which cell is highlighted here?
1A
A1
G5
E1
Which area is highlighted in the spreadsheet here?
A2:F4
A1:F5
2A:4F
G1:G5
What are the three types of information that appear in a spreadsheet?
text, integer, character
labels, numbers, formula
name, age, school
NOT, AND, OR
What is the purpose of a spreadsheet?
To process large amounts of data, for example school records.
To create typed documents, such as letters and reports.
To process numerical data, for example budgets and accounts.
To create presentations, such as an advertisement.
What is highlighted in yellow in the picture here?
B
A row
A column
Nothing
What is highlighted in green in the picture here?
4
A row
A column
Nothing
Which of the following is the correct function to find the total value of the cells shown in the picture?
=AVERAGE(B2:B4)
=SUM(B2:B4)
=MAX(B2:B4)
=MIN(B2:B4)
Which of the following is the correct function to find the average value of the cells shown in the picture?
=AVERAGE(B2:B4)
=SUM(B2:B4)
=MAX(B2:B4)
=MIN(B2:B4)
Which of the following is the correct function to find the lowest value of the cells shown in the picture?
=AVERAGE(B2:B4)
=SUM(B2:B4)
=MAX(B2:B4)
=MIN(B2:B4)
Which of the following is the correct function to find the highest value of the cells shown in the picture?
=AVERAGE(B2:B4)
=SUM(B2:B4)
=MAX(B2:B4)
=MIN(B2:B4)
What is the golden rule in a spreadsheet?
All formula begin with =
All data must be numbers
All data must be in colour
All formula begin with 'f'
Which of the following is not a use for a spreadsheet.
Creating budgets and accounts.
Presenting information in a graph.
Calculating totals, averages and applying conditional formatting.
Presentating information in a slideshow.
Which of the following is NOT an operator used in spreadsheets?
>
<
>=
+
What is the purpose of 'autofill'?
Widen a column to show the values.
Copy a formula into the adjacent cells.
Calculate the average value of a group of cells.
Adds a specified colour and border to a group of cells when a specific value is in the cells.
What is the term given when you drag a formula into the adjacent cells (using the square in the bottom right hand corner of the cell)?
Replicate
Autofill
Copy
Drag
Which of the 2 COUNT functions only includes number values in its total?
=COUNT
=COUNTA
Which of the following formula will give the result of 9?
=MIN (B3:D5)
=MAX (B3:D5)
=SUM (B3:D5)
=COUNT (B3:D5)
Select all correct cell references for the yellow cells
D3:F4
D3, E3, F3, D4, E4, F4
3D:4F
3D, 3E, 3F, 4D, 4E, 4F
What is the formula to work out A2 take away B2?
A2-B2
=A2-B2
=SUB(A2:B")
=A2MINUSB2
What is the function to find out the average of A1 to B5?
=(A1+A2+A3+A4+A5+B1+B2+B3+B4+B5)/10
=SUM(A1:B5)/10
=A1:B5)AVERAGE
=AVERAGE(A1:B5)
What is the difference between a formula and a function?
Nothing. They are exactly the same.
a formula uses words and functions use mathematical symbols.
A formula is input entirely by the user using cell references and mathematical symbols. A function uses a predefined formula, usually in the form of a word.
A formula starts with an = sign but a function doesn't.
Which of the following is a correct example of an IF function.
IF(A3>A6, "Yes", "no")
IF A3>A6, "Yes", "no"
IF(A3>A6) "Yes" "no"
IF A3>A6("Yes", "No")
What does a COUNTIF function do in excel?
Counts every value and outputs the result
Counts each value that meets a criteria and outputs the result
Counts how many times your spreadsheet has been viewed
None of the above
What is the name of the Google software used to model costs and make calculations?
Excel
Word
Docs
Sheets
