Flashcards

Ch 4 Exam Questions

royc001 ICT AS A2 Inglês 5 flashcards

Flashcards do conjunto (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.

Descrição: A2 ICT AS (Ch 4 - Spreadsheet concepts) FlashCards sobre Ch 4 Exam Questions, criado por royc001 em 13-04-2013.
Criado por: royc001
Visualizações: 44
Tags: ch 4 - spreadsheet conceptsict as
Avaliação