Font size
WorksheetsY7 Spring
Total questions: 20
Worksheet time: 10mins
Which things could be done to make the data on this spreadsheet easier to read
Use bold font for titles
Use different colours for each column on the table
Pick out titles and key information in a different colour
Use borders
What formula has been used to calculate the total price of copy paper
=A4*C4
=B4*C4
=B4+C4
B4*C4
Which cell holds the price of Post-it Notes
5B
A5
B5
B3
What would SUM(D4:D8) do on this spreadsheet
Add up all the prices
Add up the profit
Calculate the average price
Add up the revenue
Which cell holds the quantity of Staplers
6C
C6
C3
A6
How is profit calculated?
quantity x price
total price of all things sold
revenue+costs
revenue-costs
What is meant by revenue?
The profit made by a shop
The total money made from sales
The money it costs to run the shop
The difference between how much it costs to buy an item and how much you sell it for
What would be displayed in cell B7 if the function =SUM(B1:B6) was used?
41
20
30
40
What would be the correct function to type in to cell C8?
AVERAGE(C1:C7)
=AVERAGE(C1:C7)
AVERAGE(C1:C6)
=AVERAGE(C1:C6)
Which two formulas could have been used in cell E6?
=SUM(D1:D5)
=SUM(B6:D6)
=SUM(B1:D6)
=B6+C6+D6
Putting cells into A-Z order is called?
Sort Ascending
Sort Descending
Filter Ascending
Filter Descending
What filter has been applied in this table?
Gender - Male
Shoe Size - 10
Hair - Brown
Height - Ascending Order
Which of the following would you expect the results of this query to show?
All the suspects with a tattoo on their arm
All the suspects with size 10 shoes
All the suspect that either have a tattoo on their arm OR size 10 shoes
All the suspects with a tattoo on their arm AND size 10 shoes
Why are closed questions better in a questionnaire? tick all that apply
It cuts down on mistakes
It's gives less choices
It lets you anwer in whatever way you want
It makes it easier to search the information you have collected
