Wednesday, 4 September 2013

8.1

The shakes spread sheet

Which band member wants the most crisps?
a)jason
Who prefers apples to crisps?
a)kym

In which cell can you find the highest number on the spreadsheet? Write the cell reference here: a)e8

Does cell F5 contain a variable or a rule?
a)variable

How many sandwiches does the venue need to buy for the band altogether?
a)10


What would the formula be for working out the total number of sandwiches?
a)=c7+d7+e7+f7

What new column would need to be added so that the venue could work out how much it the items were going to cost them?
a)total


1)     There is a data label missing from the chart opposite. What should it read?cost

9)     Text Box: You can read it betterWhat is one advantage of putting information in a chart like the one shown opposite?








10)                   Text Box: You have to add it up your self Can you think of one disadvantage?

No comments:

Post a Comment