UNIT 4 LESSON 2

Question 1

With models we can do what?

Answer 1

With models we can
Change input to see what happens to output
Ask “What if” questions

Question 2

What is Relative Reference?

Answer 2

Relative Reference is when you are using a particular cell reference in a formula and you copy that formula into another cell, the cell reference changes. The “$” sign is not used in the cell reference.

Question 3

What is Absolute Reference?

Answer 3

Absolute Reference is when the cell reference used in a formula remains constant when copying that formula into another cell. The “$” sign is used while specifying the cell reference.

Question 4

What is a decision?

Answer 4

A decision has a yes or no answer. Then it takes one out of two possible paths.

Question 5

What are the benefits of using spreadsheets?

Answer 5

The benefits are
Take less time to calculate
Is more accurate
Automatic calculations