Qmb 4700 Test 1 Set 4

Front 1

Require more time and effort to build
Are much more difficult to debug

Back 1

complex spreadsheets

Front 2

Plan
Modularize
Start small
Parameterize
Design for use
Keep it simple
Design for communication
Document important data and formulas

Back 2

designing a spread sheet

Front 3

always begin with a

Back 3

sketch

Front 4

Spreadsheets’ lives are

Back 4

often longer than expected.

Front 5

Use informative labels
Use blank spaces
Use outlines, color, bold fonts, as appropriate

Back 5

visual cues that reinforce model's logic

Front 6

Record source for important parameters
Explain important formulas
Use Cell Comments to describe cell contents
Consider a separate module to list assumptions

Back 6

documenting important data and forumulas

Front 7

reasons for implementing workbook design

Back 7

Use separate sheets to group similar kinds of information
Design workbooks for ease of navigation
Protect workbooks from unwanted changes during use

Front 8

Lock cells not to be changed.
Use worksheet protection.
Use data validation.

Back 8

protect cells from unwanted changes

Front 9

--------reduces the potential for typographical errors.
-------- can also be a source of bugs.

Back 9

copying

Front 10

Any cell or range of cells may be named.
Name or cell reference may be used in formulas.
Names easier to debug and use

Back 10

range names

Front 11

testing a spread sheet

Back 11

Check that numerical results look plausible.
Check that formulas are correct.
Test that model performance is plausible.

Front 12

-------should react in a plausible manner to a range of inputs when testing model plausibility

Back 12

model

Front 13

Sensitivity testing is an important tool to test plausibility.

Back 13

Sensitivity testing

Front 14

most spread sheets contain

Back 14

errors

Front 15

users are

Back 15

over confident about their models

Front 16

Designing a spreadsheet
Designing a workbook
Building a workbook
Testing a workbook

Back 16

rules for spreadsheet modeling