Question 1

The data is the first thing that should be entered in a spreadsheet model.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following statements about a "good" spreadsheet model is FALSE?

Accepted Answer

A)  A good model is easy to understand. 
B)  A good model will always give the correct result. 
C)  A good model is easy to modify. 
D)  A good model has data entered in only one location. 
E)  A good model uses range names to make formulas easier to understand. 
A)  A good model is easy to understand. 
B)  A good model will always give the correct result. 
C)  A good model is easy to modify. 
D)  A good model has data entered in only one location. 
E)  A good model uses range names to make formulas easier to understand.

Question 3

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 4

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. The modeler has named cell B2 "Hourly_Wage" to make the model more understandable. What formula should be entered into cell C5?

Accepted Answer

A)  =B1*B5 
B)  =B1*$B$5 
C)  =Hourly_Wage*B5 
D)  =$B$2*Hourly_Wage 
E)  =Hourly_Wage +B5 
A)  =B1*B5 
B)  =B1*$B$5 
C)  =Hourly_Wage*B5 
D)  =$B$2*Hourly_Wage 
E)  =Hourly_Wage +B5

Question 5

The first step in spreadsheet building is to enter the formulas into their proper cells.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following are valid range names in Excel?

Accepted Answer

A)  Total Profit 
B)  TotalProfit 
C)  Total_Profit 
D)  All of the answer choices are correct. 
E)  TotalProfit and Total_Profit only. 
A)  Total Profit 
B)  TotalProfit 
C)  Total_Profit 
D)  All of the answer choices are correct. 
E)  TotalProfit and Total_Profit only.

Question 7

A spreadsheet developer enters the formula "=B9*$B$10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

Accepted Answer

A)  =B9*$B$10 
B)  =C9*C10 
C)  =$C$10*$C$11 
D)  =B9*$B$11 
E)  =C10*$B$10 
A)  =B9*$B$10 
B)  =C9*C10 
C)  =$C$10*$C$11 
D)  =B9*$B$11 
E)  =C10*$B$10

Question 8

How many cells should be used to represent each constraint?

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  3 
E)  4 
A)  0 
B)  1 
C)  2 
D)  3 
E)  4

Question 9

A spreadsheet developer enters the formula "=B9*B10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

Accepted Answer

A)  =B9*B10 
B)  =C9*C10 
C)  =C10*C11 
D)  =B9*B11 
E)  =B10*B11 
A)  =B9*B10 
B)  =C9*C10 
C)  =C10*C11 
D)  =B9*B11 
E)  =B10*B11

Question 10

Which of the following statements is TRUE about a good spreadsheet model?

Accepted Answer

A)  A good model is easy to understand. 
B)  A good model is easy to debug. 
C)  A good model is difficult for users to modify. 
D)  A good model doesn't use borders and shading. 
E)  A good model is easy to understand and a good model is easy to debug. 
A)  A good model is easy to understand. 
B)  A good model is easy to debug. 
C)  A good model is difficult for users to modify. 
D)  A good model doesn't use borders and shading. 
E)  A good model is easy to understand and a good model is easy to debug.

Question 11

A spreadsheet developer enters the formula "=$B$9*$B$10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

Accepted Answer

A)  =$B$9*$B$10 
B)  =C9*C10 
C)  =C10*C11 
D)  =B9*B11 
E)  =$B$10*$B$11 
A)  =$B$9*$B$10 
B)  =C9*C10 
C)  =C10*C11 
D)  =B9*B11 
E)  =$B$10*$B$11

Question 12

Which of the following are valid range names in Excel?

Accepted Answer

A)  Unit_Cost 
B)  Unit Cost 
C)  Cost per Unit 
D)  All of the answer choices are correct. 
E)  Unit Cost and Cost per Unit only. 
A)  Unit_Cost 
B)  Unit Cost 
C)  Cost per Unit 
D)  All of the answer choices are correct. 
E)  Unit Cost and Cost per Unit only.

Question 13

The Plan-Build-Test-Analyze process should always be followed step-by-step, from beginning to end: Plan then Build then Test then Analyze.

Accepted Answer

A) True 
 B)False

Question 14

Once the data is entered into a spreadsheet model, it should never be moved.

Accepted Answer

A) True 
 B)False

Question 15

In the example shown below, cell C7 uses absolute reference.

Accepted Answer

A) True 
 B)False

Question 16

Colors and shading should be avoided on a spreadsheet because it distracts from the model.

Accepted Answer

A) True 
 B)False

Question 17

A relative reference does not change when it is filled or copied into other cells.

Accepted Answer

A) True 
 B)False

Question 18

Before staring work on a spreadsheet, Julie sketches a rough draft of how the finished spreadsheet might look. Julie is performing which step of the modeling process?

Accepted Answer

A)  Plan. 
B)  Build. 
C)  Test. 
D)  Analyze. 
E)  None of the answer choices are correct. 
A)  Plan. 
B)  Build. 
C)  Test. 
D)  Analyze. 
E)  None of the answer choices are correct.

Question 19

When building a model, it is often a good idea to start with a small-scale version of the problem.

Accepted Answer

A) True 
 B)False

Question 20

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.

The data is the first thing that should be entered in a spreadsheet model.

Which of the following statements about a "good" spreadsheet model is FALSE?

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.

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. The modeler has named cell B2 "Hourly_Wage" to make the model more understandable. What formula should be entered into cell C5?

The first step in spreadsheet building is to enter the formulas into their proper cells.

Which of the following are valid range names in Excel?

A spreadsheet developer enters the formula "=B9*$B$10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

How many cells should be used to represent each constraint?

A spreadsheet developer enters the formula "=B9*B10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

Which of the following statements is TRUE about a good spreadsheet model?

A spreadsheet developer enters the formula "=$B$9*$B$10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

Which of the following are valid range names in Excel?

The Plan-Build-Test-Analyze process should always be followed step-by-step, from beginning to end: Plan then Build then Test then Analyze.

Once the data is entered into a spreadsheet model, it should never be moved.

In the example shown below, cell C7 uses absolute reference.

Colors and shading should be avoided on a spreadsheet because it distracts from the model.

A relative reference does not change when it is filled or copied into other cells.

Before staring work on a spreadsheet, Julie sketches a rough draft of how the finished spreadsheet might look. Julie is performing which step of the modeling process?

When building a model, it is often a good idea to start with a small-scale version of the problem.

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.

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

The data is the first thing that should be entered in a spreadsheet model.

Which of the following statements about a "good" spreadsheet model is FALSE?

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.

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. The modeler has named cell B2 "Hourly_Wage" to make the model more understandable. What formula should be entered into cell C5?

The first step in spreadsheet building is to enter the formulas into their proper cells.

Which of the following are valid range names in Excel?

A spreadsheet developer enters the formula "=B9*$B$10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

How many cells should be used to represent each constraint?

A spreadsheet developer enters the formula "=B9*B10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

Which of the following statements is TRUE about a good spreadsheet model?

A spreadsheet developer enters the formula "=$B$9*$B$10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

Which of the following are valid range names in Excel?

The Plan-Build-Test-Analyze process should always be followed step-by-step, from beginning to end: Plan then Build then Test then Analyze.

Once the data is entered into a spreadsheet model, it should never be moved.

In the example shown below, cell C7 uses absolute reference.

Colors and shading should be avoided on a spreadsheet because it distracts from the model.

A relative reference does not change when it is filled or copied into other cells.

Before staring work on a spreadsheet, Julie sketches a rough draft of how the finished spreadsheet might look. Julie is performing which step of the modeling process?

When building a model, it is often a good idea to start with a small-scale version of the problem.

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.

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