2520 TEST BANK REVIEW SET COMPLETE
Q&A 2026 GRADED A+.
⫸ There is a systematic procedure that will lead to a single correct
spreadsheet model. Answer: F
⫸ The Plan-Build-Test-Analyze process should always be followed
step-by-step, from beginning to end: Plan then Build then Test then
Analyze. Answer: F
⫸ When building a model, it is often a good idea to start with a
small-scale version of the problem. Answer: T
⫸ When sketching out a spreadsheet, it is important to have selected
the formulas for all of the output cells. Answer: F
⫸ An absolute reference does not change when it is filled or copied
into other cells. Answer: T
⫸ The data is the first thing that should be entered in a spreadsheet
model. Answer: T
⫸ A relative reference does not change when it is filled or copied into
other cells. Answer: F
, ⫸ Once the data is entered into a spreadsheet model, it should never
be moved. Answer: F
⫸ Data (for example, prices or costs) should be entered directly into
every output cell as needed. Answer: F
⫸ When a number is needed in an output cell, it should typically be
entered there directly. Answer: F
⫸ It is better to use powerful functions in Excel to complete a
calculation in a single cell than to spread out a calculation over many
cells using simpler formulas. Answer: F
⫸ Whenever possible, the entire model should be displayed on the
spreadsheet. Answer: T
⫸ Colors and shading should be avoided on a spreadsheet because it
distracts from the model. Answer: F
⫸ The toggle feature in Excel switches back and forth between
viewing formulas and viewing values in the output cells. Answer: T
⫸ The auditing tools can be used to trace the cells that make
reference to a particular cell. Answer: T
Q&A 2026 GRADED A+.
⫸ There is a systematic procedure that will lead to a single correct
spreadsheet model. Answer: F
⫸ The Plan-Build-Test-Analyze process should always be followed
step-by-step, from beginning to end: Plan then Build then Test then
Analyze. Answer: F
⫸ When building a model, it is often a good idea to start with a
small-scale version of the problem. Answer: T
⫸ When sketching out a spreadsheet, it is important to have selected
the formulas for all of the output cells. Answer: F
⫸ An absolute reference does not change when it is filled or copied
into other cells. Answer: T
⫸ The data is the first thing that should be entered in a spreadsheet
model. Answer: T
⫸ A relative reference does not change when it is filled or copied into
other cells. Answer: F
, ⫸ Once the data is entered into a spreadsheet model, it should never
be moved. Answer: F
⫸ Data (for example, prices or costs) should be entered directly into
every output cell as needed. Answer: F
⫸ When a number is needed in an output cell, it should typically be
entered there directly. Answer: F
⫸ It is better to use powerful functions in Excel to complete a
calculation in a single cell than to spread out a calculation over many
cells using simpler formulas. Answer: F
⫸ Whenever possible, the entire model should be displayed on the
spreadsheet. Answer: T
⫸ Colors and shading should be avoided on a spreadsheet because it
distracts from the model. Answer: F
⫸ The toggle feature in Excel switches back and forth between
viewing formulas and viewing values in the output cells. Answer: T
⫸ The auditing tools can be used to trace the cells that make
reference to a particular cell. Answer: T
