Chapter 8: spreadsheets

Question 1

Purpose of named range cells

Answer 1

Range referenced directly

Used as an absolute reference

Question 2

Describe the diff between a formula and a function

Answer 2

Formula: calculation formed by used using arithmetics and or functions

Functions: premade named complex calculations

Question 3

Verifying data on a spread sheet

Answer 3

Compare with source file

Question 4

Absolute vs relative cell referencing

Answer 4

• when cells replicated, absolute ref stays same whole relative ref changes in relation to the row or column

Question 5

What is Modelling

Answer 5

• the act of building a model
• computer representation of the real world process
• created through mathematical analysis of the real world
• created using modelling software/ spreadsheets
• ## e.g a computer network

Question 6

CAD

Answer 6

Computer aided deisign 
- model of a physical object 
- viewing in 2d or 3d 
- adding removing obj
- viewing in diff angle
- applying fx (color and lighting)
-

Question 7

Features of modelling `=

Answer 7

• variables can be chnaged
• formulas and functions can be used
• can ask what if questions to see result of changing variables
• automatic recalculation of formula function
• rules (how the model behaves)
• layers of abstraction (diff parts viewed and analyzed)

Question 8

Need for computer models

Answer 8

• Training
• no injury
• low cost
• unpredictable situations
• see what/how variables need to be changed to reach a certain outcome
• can be shared online / offlin

E.g.

• forecasting (weather )
• financial modelling
• construction

Question 9

Limitations of modelling

Answer 9

Will never be as accurate as IRL
will be close if formulas and fnctions are very complex

spreadsheet: only numbers

experts need to set up

• high cost
• long time
• training to use/ run

Question 10

Simulation:

Answer 10

computerised model to preidct how a rela life system may behave

• the process of using a model to study behaviour and performance of an actual or theoretical system \
• by controlling variables
• make evaluations / predictions

Question 11

Model vs simulation

Answer 11

• model aims ot be true to teh syste it represents

- simulations causes models to explore states that wpuld not be possible in the og system