WorksheetsSpreadsheets Assessment KS3
Total questions: 42
Worksheet time: 21mins
Which of these is an example of a appropriate use of a spreadsheet?
Writing a Letter for a Job
Presenting Information to students
Storing results of a Science Experiment
Creating an animation for a film
Which of the following is not part of a spreadsheet
Cell
Table
Column
Row
Box
What is the definition of "Cell Reference"
The address of a cell
Where a cell is
What data is referenced in a cell
How much data a cell can store
Which is the correct format for writing cell references?
Letter Number (A1)
Number Letter(1A)
Letter Letter (AA)
Number Number (11)
What cell is highlighted?
4C
B4
C4
4B
Which Cell should the total of the scores be entered?
D2
A3
B3
C3
What is the range of the cells highlighted?
A1:D1
A1,D4
A1:D4
A1:D3
What is the range of the cells not highlighted?
A1:D1
A4,D4
A1:D4
A4:D5
What would the answer be to =C1 + C2
7
20
21
4
What would the answer be to = A1 / A2
3
20
10
5
What would the answer be to = A1 + D2 + A2 - C1
20
22
25
5
Which of the following facts about spreadsheets is false?
Spreadsheets can be used for mathematical calculations
Spreadsheets are able to produce useful charts and graphs
Spreadsheets are helpful for people creating financial budgets
Spreadsheets are not very good at handling large amounts of data
Which of the following formulas will return the result 8
=D3-C2
=A1+B1
=A4-C2
=C1+D1+D2
Which of the following formulas will return the result 3
=A1/C1
=D2*C1
=A1-D1
=D3-D4
What would the result of = (B1-A1)*D1
15
25
3
12
What would the result of =Sum(A1:D1)
43
40
35
3
What would the result of =Average(D1:D4)
30
4
8
32
What would the result of =MAX(A1:D4)
27
56
12.75
86
What would the result of =MIN(A1:D4)
1
3
12.75
-56
Which of the following Formulas is wrong?
=A1+A2
=A1/A2
=Sum A1:A4
=Min(A1:A4)
Which of the following formulas add all the numbers in a range together?
=SUM
=AVERAGE
=MIN
=MAX
Which of the following formulas finds the average number from a range of numbers?
=SUM
=AVERAGE
=MIN
=MAX
Which of the following formulas finds the smallest number from a range of numbers?
=SUM
=AVERAGE
=MIN
=MAX
Which of the following formulas finds the biggest number from a range of numbers?
=SUM
=AVERAGE
=MIN
=MAX
What formatting has taken place in C1
Added Border
Colour Fill
Font Colour
Font Change
What formatting has taken place in B3
Bold Text
Colour Fill
Italic Text
Font Colour
Conditional Formatting is when...
A spreadsheet is formatted by the user
Data is formatted when a button is pressed
Spreadsheet is formatted when certain conditions are True
Spreadsheet is formatted in certain condtions by the user
If I wanted to highlight all the cells that had a value smaller than 1, which of the following rules should I use?
Format Cells if...
Greater Than 1
Less Than 1
Less Than or Equal to 1
< 1
Which of the following conditional formatting has been used on this table?
Format cells if...
Text is exactly 5
Text is less than 7
Less than 6
Greater than 0
What would be the result of the following formula?
=SUM(A1:D1)
36
33
35
9
Which of the following Cells is not highlighted?
C1
D1
C4
A2
Which Cell has the answer to the following formula:
=(SUM(A3:C3)-D3)-C4
Remember BODMAS!
C3
D1
A1
B3
Which formula would be used to calculate the number of target sales that were met?
=IF
=SUM
=COUNT
=COUNTIF
What should be used to highlight any sales figures over £1000
Formatting
Conditional Formatting
IF Statements
SUM function
Which formula has been used to calculate Total Stock
average
=Average
=Sum
Sum
Adding Borders, Colour Fill Cells and Bold and Underlining data is known as what?
Conditional formatting
Formatting
Formulas
Designing
What formula could be used to calculate the Sales figures for teddy bears?
=D2*F2
=D2/G2
=Sum(D2*G2)
=Multi(D2*G2)
To meet their sales targets, 60% of the must be sold. How many products did not meet this target?
3
4
8
5
Which product has the following product number: 11885
Monopoly
Uno
Fidget Block
Football
How many Barbies were sold?
75
50
25
35
How much is the Lego Set?
10
3
25
3125
Was the target sales met for the rugby ball?
Yes
No
Can't Tell
Maybe
