Topic 12 Flashcards
1
Q
What is the formula for AVERAGE?
A
=AVERAGE(E7:E14)
2
Q
Discuss with advantages two methods of simplifying data entry you used in your spreadsheet?
A
Combo box: restrict options to a list, reducing data entry errors.
Spinners: use a button to increase and decrease a value by 1, saves time
3
Q
What uses do simulation models have?
A
Weather forecasting= wind speed, temp and humidity can predict weather patterns
Car crash analysis= simulates car crashes help manufacture safer cars
4
Q
What are the advantages and dis advantages to using simulations models?
A
Ad:
- time is saved
- safer to use simulations than real life
- cheaper
- experience a lot more situations
Dis:
- only as accurate as the equations put in
- supercomputers are expensive
- difference between simulation and reality
- hard to model
5
Q
What is the formula for finding the SUM?
A
=SUM(G17:G24)
