AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Computing

Models and choices

Week 15 · 2.1 Spreadsheets and analysing data · 3 lessons
Answers are for parents and teachers.
1
A model is used to plan how much paint a school needs for its classrooms. Give two benefits and two drawbacks of using the model before ordering the paint.
2
A scooter hire shop charges 5 an hour, but only 4 an hour if the scooter is hired for more than 3 hours. The hours are in B2:B5, and the formula in C2 is =IF(B2>3,B2*4,B2*5). Work out the four costs.
C2fx=IF(B2>3,B2*4,B2*5)
ABC
1CustomerHoursCost
2a2?
3b3?
4c4?
5d6?
3
Baggage costs depend on the mass in B2: up to and including 7 kg is free (0), over 7 kg and up to 15 kg costs 20, and over 15 kg costs 40. Write the formula and work out the cost for 5, 7, 7.5, 15 and 16 kg.
4
This formula should show Cold below 10, Mild below 22 and Hot otherwise, but it does not work: =IF(B2<10,Cold,IF(B2<22,"Mild","Hot") Find both faults.
5
Explain what filling a formula down does. Use the formula =B2*4 in C2 filled to C3 and C4 as your example.