Wednesday, 4 September 2013

8.1


THE SHAKES  SPRED SHEET.

1)    Which band member wants the most crisps?
JASON

2)    Who prefers apples to crisps?
KYM

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

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

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


6)    What would the formula be for working out the total number of sandwiches?
=SUM(C7+D7+E7+F7)

7)    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?
COST
8)    There is a data label missing from the chart opposite. What should it read?
BISCUITS


9)    What is one advantage of putting information in a chart like the one shown opposite?
Text Box: YOU CAN READ IT BETTER .




10) Text Box: YOU Have to add it up yourself. Can you think of one disadvantage?



THE SHAKES  SPRED SHEET.

1)    Which band member wants the most crisps?
JASON

2)    Who prefers apples to crisps?
KYM

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

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

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


6)    What would the formula be for working out the total number of sandwiches?
=SUM(C7+D7+E7+F7)

7)    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?
COST
8)    There is a data label missing from the chart opposite. What should it read?
BISCUITS


9)    What is one advantage of putting information in a chart like the one shown opposite?
Text Box: YOU CAN READ IT BETTER .




10) Text Box: YOU Have to add it up yourself. Can you think of one disadvantage?