G061 - Spreadsheet questions

1. / The financial records of a village show are kept on a spreadsheet.
Workbooks and ranges are used in the spreadsheet.
Explain the purpose of workbooks and ranges. Give an example of how each could be used for the village show’s financial records. / [9]
2514 January 2009 Q3
2. / A company uses a spreadsheet to store its accounts.
Describe the terms worksheets, cells and ranges and give an example of how each would be used in the accounts spreadsheet. / [6]
G061 January 2009 Q11
3. / A farmer grows organic vegetables which are sold at markets. The farmer is starting a delivery service of boxes of organic vegetables to homes in the local area. The delivery service will be called Crake Organics.
Crake Organics needs to purchase two vans to be used to deliver the boxes of organic vegetables.
A spreadsheet is to be used to model the financial implications of purchasing these vans.
(a) / Explain the advantages of using a spreadsheet for financial modelling. / [6]
(b) / Describe the following features of a spreadsheet that make it suitable for financial modelling for Crake Organics.
(i) / Rules
[2]
(ii) / Variables
[2]
(iii) / Functions
[2]
(c) / Absolute cell replication will be used to calculate the delivery cost of each box of organic vegetables.
Describe absolute cell replication. / [2]
2514 June 2009 Q3
4. / An airline uses a spreadsheet to work out the wages for its employees.
(a) / Describe how variables and functions could be used in the spreadsheet. / [4]
(b) / Describe absolute and relative referencing and give examples of each relating to the wages spreadsheet. / [2]
(c) / Give two disadvantages of using spreadsheet software to work out the wages for the employees. / [2]
G061 June 2009 Q10
5. / A company manufactures electronic tills for use in shops. The company uses a spreadsheet to model future sales.
(a) / The company can use formulae and functions within the software to create ‘what-if’ calculations.
Describe two other characteristics of spreadsheet software that the company could use to model future sales. / [4]
(b) / Explain three advantages to the company of using spreadsheet software to answer ‘what-if’ questions. / [6]
G061 January 2010 Q6
6. / A company is considering a move to new premises and is using a spreadsheet model to run simulations on the costs of relocating.
(a) / Describe two advantages of using a spreadsheet model to run the simulations. / [4]
(b) / Explain how variables and functions could be used in the spreadsheet model. / [4]
(c) / Give an example of the use of a range and a row in the spreadsheet used to simulate the relocation of the company. / [2]
G061 June 2010 Q9
7. / Over time, her landscape gardening business has grown and Miss Jones wants to take over a local competitor.
Miss Jones has been advised to use software to model the expansion of her business.
(a) / Using examples related to the landscape gardening business, describe how Miss Jones could make use of workbooks and ranges. / [4]
(b) / Using examples related to the landscape gardening business, describe how Miss Jones could use absolute and relative cell references. / [4]
G061 January 2011 Q5
8. / Progressville is a small village and is trying to raise money by hiring out its village hall.
The committee want to create a model to predict income from the hire of the hall over the next three years.
(a) / Explain three advantages of using a spreadsheet to create the model. / [6]
(b) / Explain, using examples, how functions and formulae could be used when creating the spreadsheet model. / [4]
G061 June 2011 Q5
9. / A furniture company is looking to expand its business with the purchase of an additional shop.
They have created a spreadsheet model to help them.
(a) / State two ‘what-if?’ questions the furniture business could use the spreadsheet model to answer. / [2]
(b) / Describe two advantages of using a spreadsheet to answer ‘what-if?’ questions. / [4]
(c) / Explain, using an example, how rules could be used in the spreadsheet model of the expansion of the business. / [4]
G061 January 2012 Q3
10. / A car dealership uses a tailored spreadsheet to monitor sales and profit in its showrooms.
(a) / Describe three features of a spreadsheet model that could be used to help predict the sales and profit over the next twelve months for the car dealership / [6]
(b) / Explain two disadvantages of using a spreadsheet model to create and run the predictions. / [4]
G061 June 2012 Q5