WorksheetsYear 8 Spreadsheets
Total questions: 25
Worksheet time: 13mins
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
