Spreadsheets

Front 1

4 advantages of spreadsheet modelling

Back 1

Allows variables to be changed (1) to see answers to different questions (1)

Model can be emailed (1) multiple people can use the model (1)

Allows different scenarios to be viewed (1)

Risk-free (1) costs less than testing it in reality (1)

Graphs can be created to easily understand data (1)

Front 2

What do computer models allow you to create?

Back 2

a virtual representation of the item within the computer

Front 3

Describe how rules are used in spreadsheets to answer 'What-if?' questions

Back 3

Can be used to limit entry (1) through validation (1) eg range (1)

Can be used to highlight important areas (1) eg conditional formatting (1)

Front 4

Describe absolute cell referencing

Back 4

don't change (1)

they refer to the same cell made absolute with $ (1)

When copied cell reference doesn't change (2)

Front 5

What do 'What-if?' questions allow?

Back 5

a user to change values and see what the effect would be on the end results

Front 6

Describe relative cell referencing

Back 6

Changes (1) if copying down the row/column (1)

When copied cell reference changes (2)

Front 7

What are constants?

Back 7

Values that are used in formulae but which cannot be changed by a user

Front 8

Give 4 reasons why computer modelling is used

Back 8

- it's less risky (safer and cheaper) than testing it in reality

- only one model needs to be created in a computer - it can be altered and changed

- a computer model can be backed up and shared

Front 9

3 advantages of computer modelling software

Back 9

- Allows 'What if? to be used (differnet scenarious can be tried to find best one (1)

- Variables can be used (1) these can be changed to try different scenarioswithout rebuilding the model(1)

- Time can be decreased (1) allowing the impact on a long time in the futureto be seen (1).

Front 10

Two advantages of using ranges

Back 10

Ranges can be named (1) making it easier to remember range when using it (1)

Easier readability of functions/formulae (1)

Multiple cell ranges difficult to work out (1)

Less change of error (1) rather than highlighting individual cells (1)

Front 11

Advantages of storing data across multiple worksheets

Back 11

Organisation (1) neater; less information on the screen makes it simpler to interpret (1)

Data that isn't used much can be hidden away (1) less chance of it being changed by mistake (1)

Can be used to hold data from different locations on different sheets (1)

Front 12

Describe what a variable is

Back 12

Can be changed (1) used as a reference in a calculation (1)

Front 13

Describe what a function is

Back 13

built into software (1) complex formulae (1) uses reserved words eg SUM (1)

Front 14

Two elements that could be tailored in a spreadsheet

Back 14

menu bar (1) drop-down menu that can have options (1)

icons (1) small images at top of screen (1) linked to commands/macros (1)

buttons (1) press/toggle and run commands (1)

error messages (1) specific to the spreadsheet being created (1) tells you what you've done wrong and how to solve it (1)

Front 15

2 advantages of tailoring a spreadsheet

Back 15

novice users can use the system (1)

minimal training required, saving costs (1)

quicker for users to find what they need - more productive (1)

Front 16

What is Goal Seek?

Back 16

a target is given and the value of the variables required to achieve that target is given (1)

Front 17

Advantages of a computer model

Back 17

Model can be backed up (1) if original lost, there is a copy (1)

cheaper to build computer models (1) than many manual ones (1)

inbuilt calculations (1) less chance of an error in calculating (1)

Front 18

Describe what a worksheet is

Back 18

collection of sheets (1) holds data on similar topics (1)

collection of cells/rows and columns (1)

Front 19

Describe what a cell is

Back 19

An individual box (1) containing text, number, formula, function... (1)

Front 20

Describe what a range is

Back 20

A collection of cells