Technology-Chapter 14

Question 1

the two basic principles for setting up effective spreadsheets

Answer 1

focus on form, and explain everything

Question 2

focus on form means

Answer 2

make the form logical, the layout clean, and the entries clear and easy to use

Question 3

explain everything means

Answer 3

it should be possible to know immediately what every cell means

Question 4

Conditional formatting

Answer 4

allows us to apply an interpretation to the data-payments are within budget, payments are over budget- and express that interpretations in an easily perceived manner

Question 5

scenario

Answer 5

is named alternative to a spreadsheet based on different inputs

Question 6

filtering

Answer 6

selects only certain rows from a list