Font size
WorksheetsYear 9 - Quiz Spreadsheets Recall
Total questions: 20
Worksheet time: 18mins
Microsoft Excel is ...
Software
Hardware
Utility
Operating System
Microsoft Excel is used to ...
Model Financial Scenarios
Model Games
Model Images and Text
Write reports
Which of the following is considered a cell reference?
C3
=
*
+
What formula should be placed in cell D2?
=C2-B2
=F2-B2
=A2-B2
=C2
What formula should be placed in cell D6?
=SUM(D2:D5)
=SUM(F2:F5)
=SUM(All)
=C2-D3
How many products are in this spreadsheet?
4
2
1
16
What is used to add the £ signs to the cells.
Formatting borders
Formatting Currency
Formatting fill colours
formatting text in bold.
(Don't press Enter, until you are finished typing)
What 3 things could you do to improve this financial model? What might you add to it?
Which formula might be most suitable to work out how to calculate a profit?
=number_sold*sale_price
=number_sold-sale_price
=number_sold/sale_price
=number_sold%sale_price
Which of these makes the most sense to do in Excel?
Don't add the pound sign yourself. Choose currency from the format type.
Do add the pound sign yourself. Choose currency from the format type.
Don't make numbers currency.
Don't keep everything in neat columns
(Don't press enter until you are finished writing, it will submit your answer)
In your own words, can you explain what 'making a profit is?'
How would you show this on a spreadsheet do you think?
(Don't press enter until you are finished writing, it will submit your answer)
Why is is better to use a spreadsheet on a computer, rather than create one on paper and use a pen?
If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:
=sum(C2:C11)
=sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)
=sum(D2:D11)
$13,442.90
If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:
=sum(C2:C11)
=average(C2,C11)
=average(C2:C11)
=average(B2:B11)
