Flashcards
Ch 4 Exam Questions
Cards in this deck (5)
- 1Describe two advantages of using a spreadsheet model to run the simulations [4]Automatic recalculation occurs, so that all related fields are updated with changes
You can make changes to the model to try different scenarios without having to build a new model - 2Explain how variables and functions could be used in the spreadsheet model. Examples should relate to the relocation of the business. [4]All cells could be locked except the variables, so users cannot break the model. E.g the cost of something can be changed, but not the name of the field.
Functions allow built in calculations to be used, such as adding up the costs of moving the business. - 3Give an example of the use of a range and a row in the spreadsheet used to simulate the relocation of the company. Must refer to the relocation of the business. [2]Range is used in a function to add up moving costs, and a row can be used to list the titles for costs.
- 4Describe two characteristics of spreadsheet software that the company could use to model future sales. [4]Automatic recalculation so when a value is changed all related functions and formula automatically update.
Graphs to show trends or predictions - 5Explain three advantages to the company of using spreadsheet software to answer what-if questions. [6]Make changes to the model to try out different scenarios.
See the effect of changes without having to build a new model.
No additional cost as the company is likely to already have the software.
Information
- Description
- A2 ICT AS (Ch 4 - Spreadsheet concepts) Flashcards on Ch 4 Exam Questions, created by royc001 on 13/04/2013.
- Created by
- royc001
- Views
- 44
- Tags
- Rating