Question 1

In the example shown below, cell B3 is a data cell.

Accepted Answer

A) True 
 B)False

Question 2

The auditing tools can be used to determine which user last made changes to a particular cell.

Accepted Answer

A) True 
 B)False

Question 3

A manager prepared a spreadsheet to calculate employee wages. After pressing Ctrl+~, the formula view (shown below) appeared. What issues should be addressed on this spreadsheet?

Accepted Answer

A)  Data should be entered only once. 
B)  Simple formulas should be used rather than complex Excel functions. 
C)  Absolute references should be used. 
D)  Data should be entered only once and simple formulas should be used rather than complex Excel functions only. 
E)  Data should be entered only once, simple formulas should be used rather than complex Excel functions and absolute references should be used. 
A)  Data should be entered only once. 
B)  Simple formulas should be used rather than complex Excel functions. 
C)  Absolute references should be used. 
D)  Data should be entered only once and simple formulas should be used rather than complex Excel functions only. 
E)  Data should be entered only once, simple formulas should be used rather than complex Excel functions and absolute references should be used.

Question 4

Which of the following actions will toggle the worksheet between viewing values and formulas?

Accepted Answer

A)  Pressing Ctrl+~ on a PC. 
B)  Pressing Command+~ on a Mac. 
C)  Selecting the auditing tools to Trace Dependents. 
D)  Pressing Ctrl+~ on a PC and pressing Command+~ on a Mac. 
E)  Pressing Ctrl+~ on a PC, pressing Command+~ on a Mac, and selecting the auditing tools to Trace Dependents. 
A)  Pressing Ctrl+~ on a PC. 
B)  Pressing Command+~ on a Mac. 
C)  Selecting the auditing tools to Trace Dependents. 
D)  Pressing Ctrl+~ on a PC and pressing Command+~ on a Mac. 
E)  Pressing Ctrl+~ on a PC, pressing Command+~ on a Mac, and selecting the auditing tools to Trace Dependents.

Question 5

Data (for example, prices or costs) should be entered directly into every output cell as needed.

Accepted Answer

A) True 
 B)False

Question 6

A student is using a spreadsheet to calculate her monthly surplus/deficit as well as annual income. After pressing Ctrl+~, the formula view (shown below) appeared. What issues should be addressed on this spreadsheet?

Accepted Answer

A)  Data should be entered only once. 
B)  Simple formulas should be used rather than complex Excel functions. 
C)  Range names should be used. 
D)  Absolute references should be used. 
E)  No problems exist on this spreadsheet. 
A)  Data should be entered only once. 
B)  Simple formulas should be used rather than complex Excel functions. 
C)  Range names should be used. 
D)  Absolute references should be used. 
E)  No problems exist on this spreadsheet.

Question 7

When testing a spreadsheet model by entering values in the changing cells, which of the following are appropriate values to enter?

Accepted Answer

A)  Zeroes. 
B)  Values for which you know what the values of the output cells should be. 
C)  Large numbers. 
D)  Zeros, large numbers, and inputs for which you know what the values of the output cells should be. 
E)  All of the answer choices are correct. 
A)  Zeroes. 
B)  Values for which you know what the values of the output cells should be. 
C)  Large numbers. 
D)  Zeros, large numbers, and inputs for which you know what the values of the output cells should be. 
E)  All of the answer choices are correct.

Question 8

Which of the following tips can be helpful when you can't figure out what formula needs to be entered in an output cell?

Accepted Answer

A)  Visualize where you want to finish. 
B)  Test the model. 
C)  Do some calculations by hand. 
D)  Optimize the model. 
E)  All of the answer choices are correct. 
A)  Visualize where you want to finish. 
B)  Test the model. 
C)  Do some calculations by hand. 
D)  Optimize the model. 
E)  All of the answer choices are correct.

Question 9

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the formula information shown below to determine which of the following statements is TRUE.

Accepted Answer

A)  There is no error in the model. 
B)  The model is incorrect because it is using the wrong information for the employee hours. 
C)  The model is incorrect because it is using the wrong wage information. 
D)  The model is incorrect, but it is impossible to determine why. 
E)  The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true. 
A)  There is no error in the model. 
B)  The model is incorrect because it is using the wrong information for the employee hours. 
C)  The model is incorrect because it is using the wrong wage information. 
D)  The model is incorrect, but it is impossible to determine why. 
E)  The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true.

Question 10

In the example shown below, cells B7 through B18 are inputs to cell B4.

Accepted Answer

A) True 
 B)False

Question 11

In the spreadsheet shown below, changing the value in Cell B1 will cause which other cells to change?

Accepted Answer

A)  Cell B2. 
B)  Cell B3. 
C)  Cell B7. 
D)  Cell D18. 
E)  None of the answer choices are correct. 
A)  Cell B2. 
B)  Cell B3. 
C)  Cell B7. 
D)  Cell D18. 
E)  None of the answer choices are correct.

Question 12

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE.

Accepted Answer

A)  There is no error in the model. 
B)  The model is incorrect because it is using the wrong information for the employee hours. 
C)  The model is incorrect because it is using the wrong wage information. 
D)  The model is incorrect, but it is impossible to determine why. 
E)  The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true. 
A)  There is no error in the model. 
B)  The model is incorrect because it is using the wrong information for the employee hours. 
C)  The model is incorrect because it is using the wrong wage information. 
D)  The model is incorrect, but it is impossible to determine why. 
E)  The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true.

Question 13

Which of the following should be entered first when building a spreadsheet model?

Accepted Answer

A)  The objective cell. 
B)  The data cells. 
C)  The changing cells. 
D)  The output cells. 
E)  The Solver parameters. 
A)  The objective cell. 
B)  The data cells. 
C)  The changing cells. 
D)  The output cells. 
E)  The Solver parameters.

Question 14

There is a systematic procedure that will lead to a single correct spreadsheet model.

Accepted Answer

A) True 
 B)False

Question 15

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE.

Accepted Answer

A)  There is no error in the model. 
B)  The model is incorrect because it is using the wrong information for the employee hours. 
C)  The model is incorrect because it is using the wrong wage information. 
D)  The model is incorrect, but it is impossible to determine why. 
E)  The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true. 
A)  There is no error in the model. 
B)  The model is incorrect because it is using the wrong information for the employee hours. 
C)  The model is incorrect because it is using the wrong wage information. 
D)  The model is incorrect, but it is impossible to determine why. 
E)  The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true.

Question 16

In the example shown below, cell B2 uses an Excel formula.

Accepted Answer

A) True 
 B)False

Question 17

When sketching out a spreadsheet, it is important to have selected the formulas for all of the output cells.

Accepted Answer

A) True 
 B)False

Question 18

In the example shown below, cell B4 is an input to cell B7.

Accepted Answer

A) True 
 B)False

Question 19

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.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is not an advantage of using range names?

Accepted Answer

A)  They make formulas easier to interpret. 
B)  They make the Solver entries easier to understand. 
C)  They make the model easier to modify. 
D)  They make the Solver entries easier to understand and they make the model easier to modify are not advantages of using range names. 
E)  All of the answer choices are advantages of using range names. 
A)  They make formulas easier to interpret. 
B)  They make the Solver entries easier to understand. 
C)  They make the model easier to modify. 
D)  They make the Solver entries easier to understand and they make the model easier to modify are not advantages of using range names. 
E)  All of the answer choices are advantages of using range names.

In the example shown below, cell B3 is a data cell.

The auditing tools can be used to determine which user last made changes to a particular cell.

A manager prepared a spreadsheet to calculate employee wages. After pressing Ctrl+~, the formula view (shown below) appeared. What issues should be addressed on this spreadsheet?

Which of the following actions will toggle the worksheet between viewing values and formulas?

Data (for example, prices or costs) should be entered directly into every output cell as needed.

A student is using a spreadsheet to calculate her monthly surplus/deficit as well as annual income. After pressing Ctrl+~, the formula view (shown below) appeared. What issues should be addressed on this spreadsheet?

When testing a spreadsheet model by entering values in the changing cells, which of the following are appropriate values to enter?

Which of the following tips can be helpful when you can't figure out what formula needs to be entered in an output cell?

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the formula information shown below to determine which of the following statements is TRUE.

In the example shown below, cells B7 through B18 are inputs to cell B4.

In the spreadsheet shown below, changing the value in Cell B1 will cause which other cells to change?

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE.

Which of the following should be entered first when building a spreadsheet model?

There is a systematic procedure that will lead to a single correct spreadsheet model.

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE.

In the example shown below, cell B2 uses an Excel formula.

When sketching out a spreadsheet, it is important to have selected the formulas for all of the output cells.

In the example shown below, cell B4 is an input to cell B7.

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.

Which of the following is not an advantage of using range names?

Introduction

Linear Programming: Basic Concepts

Linear Programming: Formulation and Applications

What-If Analysis for Linear Programming

Network Optimization Problems

Using Binary Integer Programming to Deal With Yes-Or-No Decisions

Nonlinear Programming

Decision Analysis

Forecasting

Queueing Models

Computer Simulation: Basic Concepts

Computer Simulation With Analytic Solver

Filters

Exam 4: The Art of Modeling With Spreadsheets

In the example shown below, cell B3 is a data cell.

The auditing tools can be used to determine which user last made changes to a particular cell.

A manager prepared a spreadsheet to calculate employee wages. After pressing Ctrl+~, the formula view (shown below) appeared. What issues should be addressed on this spreadsheet?

Which of the following actions will toggle the worksheet between viewing values and formulas?

Data (for example, prices or costs) should be entered directly into every output cell as needed.

A student is using a spreadsheet to calculate her monthly surplus/deficit as well as annual income. After pressing Ctrl+~, the formula view (shown below) appeared. What issues should be addressed on this spreadsheet?

When testing a spreadsheet model by entering values in the changing cells, which of the following are appropriate values to enter?

Which of the following tips can be helpful when you can't figure out what formula needs to be entered in an output cell?

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the formula information shown below to determine which of the following statements is TRUE.

In the example shown below, cells B7 through B18 are inputs to cell B4.

In the spreadsheet shown below, changing the value in Cell B1 will cause which other cells to change?

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE.

Which of the following should be entered first when building a spreadsheet model?

There is a systematic procedure that will lead to a single correct spreadsheet model.

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE.

In the example shown below, cell B2 uses an Excel formula.

When sketching out a spreadsheet, it is important to have selected the formulas for all of the output cells.

In the example shown below, cell B4 is an input to cell B7.

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.

Which of the following is not an advantage of using range names?

Introduction

Linear Programming: Basic Concepts

Linear Programming: Formulation and Applications

What-If Analysis for Linear Programming

Network Optimization Problems

Using Binary Integer Programming to Deal With Yes-Or-No Decisions

Nonlinear Programming

Decision Analysis

Forecasting

Queueing Models

Computer Simulation: Basic Concepts

Computer Simulation With Analytic Solver

Filters