Question 1

Which of the following can be done using the auditing tools in Excel?

Accepted Answer

A) Trace the cells that make reference to a particular cell. 
B) Trace the cells that a particular cell refers to. 
C) Trace the history of values for a particular cell. 
D) Determine the valid entries in a particular cell. 
E) a and b only. 
A) Trace the cells that make reference to a particular cell. 
B) Trace the cells that a particular cell refers to. 
C) Trace the history of values for a particular cell. 
D) Determine the valid entries in a particular cell. 
E) a and b only. E

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

When a number is needed in an output cell,is should typically be entered there directly.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is not a part of the planning step when building a spreadsheet model?

Accepted Answer

A) Visualize where you want to finish. 
B) Do some calculations by hand. 
C) Sketch out a spreadsheet. 
D) Test the spreadsheet model. 
E) All of the above are part of the planning step. 
A) Visualize where you want to finish. 
B) Do some calculations by hand. 
C) Sketch out a spreadsheet. 
D) Test the spreadsheet model. 
E) All of the above are part of the planning step.

Question 7

It is better to use power 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 8

Which of the following are valid range names in Excel?

Accepted Answer

A) Total Profit 
B) TotalProfit 
C) Total_Profit 
D) All of the above. 
E) b and c only. 
A) Total Profit 
B) TotalProfit 
C) Total_Profit 
D) All of the above. 
E) b and c only.

Question 9

Which of the following is an appropriate first step when building a spreadsheet model?

Accepted Answer

A) Start with building a small scale model. 
B) Visualize where you want to finish. 
C) Test the model. 
D) Expand the model to full scale. 
E) Optimize the model. 
A) Start with building a small scale model. 
B) Visualize where you want to finish. 
C) Test the model. 
D) Expand the model to full scale. 
E) Optimize the model.

Question 10

Each data value should be entered into how many cells?

Accepted Answer

A) 0 
B) 1 
C) 2 
D) 3 
E) The value should be entered into any formula in which it is needed. 
A) 0 
B) 1 
C) 2 
D) 3 
E) The value should be entered into any formula in which it is needed.

Question 11

Whenever possible,the entire model should be displayed on the spreadsheet.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following best describes spaghetti code?

Accepted Answer

A) Code that is not logically organized and jumps all over the place. 
B) Code that is well documented. 
C) Code that has a clear beginning,middle,and end. 
D) All of the above. 
E) None of the above. 
A) Code that is not logically organized and jumps all over the place. 
B) Code that is well documented. 
C) Code that has a clear beginning,middle,and end. 
D) All of the above. 
E) None of the above.

Question 13

An advantage of the long-term loan for Everglade is that it has a lower interest rate than the short-term loan.
Multiple Choice Questions

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Numbers should be included directly in formulas rather than entered separately in data cells in order to keep the spreadsheet model concise.

Accepted Answer

A) True 
 B)False

Question 16

The auditing tools can be used to trace the cells that make reference to a particular cell.

Accepted Answer

A) True 
 B)False

Question 17

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 above. 
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 above.

Question 18

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 19

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 dialogue box entries easier to understand. 
C) They make the model easier to modify. 
D) b and c are not advantages of using range names. 
E) All of the above are advantages of using range names. 
A) They make formulas easier to interpret. 
B) They make the Solver dialogue box entries easier to understand. 
C) They make the model easier to modify. 
D) b and c are not advantages of using range names. 
E) All of the above are advantages of using range names.

Question 20

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) All of the above. 
E) b and c only. 
A) Zeroes. 
B) Values for which you know what the values of the output cells should be. 
C) Large numbers. 
D) All of the above. 
E) b and c only.

Exam 4: The Art of Modeling With Spreadsheets

Which of the following can be done using the auditing tools in Excel?

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

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

When a number is needed in an output cell,is should typically be entered there directly.

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

Which of the following is not a part of the planning step when building a spreadsheet model?

It is better to use power 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 are valid range names in Excel?

Which of the following is an appropriate first step when building a spreadsheet model?

Each data value should be entered into how many cells?

Whenever possible,the entire model should be displayed on the spreadsheet.

Which of the following best describes spaghetti code?

An advantage of the long-term loan for Everglade is that it has a lower interest rate than the short-term loan. Multiple Choice Questions

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

Numbers should be included directly in formulas rather than entered separately in data cells in order to keep the spreadsheet model concise.

The auditing tools can be used to trace the cells that make reference to a particular cell.

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

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

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

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

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

Cd Supplement - Decision Analysis

Forecasting

Queueing Models

CD Supplement - Additional Queueing Models

Computer Simulation: Basic Concepts

CD Supplement - the Inverse Transformation Method for Generating Random Observations

Computer Simulation With Crystal Ball

CD - Solution Concepts for Linear Programming

CD - Transportation and Assignment Problems

CD - Pertcpm Models for Project Management

CD - Goal Programming

CD - Inventory Management With Known Demand

CD - Inventory Management With Uncertain Demand

Filters