Chapter 8 (Spreadsheets)

Question 1

Purpose of named range cells

Answer 1

The Range referenced directly

Question 2

Describe the diff between a formula and a function

Answer 2

Formula: calculation formed by used using arithmetic and or functions

Functions: premade named complex calculations

Question 3

best way to Verify data on a spreadsheet

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

Features of modelling

Answer 6

• variables can be changed
• 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 7

Why the Need for computer models

Answer 7

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

Question 8

Limitations of modelling

Answer 8

Will never be as accurate as IRL (Inverse Reinforcement Learning)
will be close if formulas and functions are very complex

Question 9

Simulation

Answer 9

• computerized model to predict how a real-life system may behave
• the process of using a model to study behavior and performance of an actual or theoretical system
• by controlling variables
• make evaluations / predictions

Question 10

Model vs simulation

Answer 10

• model aims to be true to ten system it represents

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

Question 11

What is a worksheet?

Answer 11

A grid in the form of rows and columns. Spreadsheets are made up of a number of these

Question 12

What is conditional formatting?

Answer 12

allows cells to be shaded a particular color if a specific criteria is met

Question 13

What is a template?

Answer 13

a redefined document containing the main elements of the document it represents e.g budget template

Question 14

Can you import data into a spreadsheet and if so what is the most common format the data has to be in?

Answer 14

yes and CSV (comma separated value)

Question 15

What is the Vlookup function used for?

Answer 15

uses the value in a selected cell to ‘lookup’ a match in a column of a lookup table

Question 16

What is a relative cell reference?

Answer 16

Changes a formula’s cell reference to refer to the next cells

Question 17

What is an absolute cell reference?

Answer 17

the cell reference does not change as the formula is modified

Question 18

can macros be used in spreadsheets?

Answer 18

Yes

Question 19

What is data modelling?

Answer 19

uses mathematical formulas and calculations on data to predict outcomes for situations

Question 20

How are spreadsheets used for data modelling?

Answer 20

they can be used by companies to make better informed decisions