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

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

Accepted Answer

A) True 
 B)False  True

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

Once the data is entered,it should never be moved

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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) 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 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 8

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

Accepted Answer

A) True 
 B)False

Question 9

The toggle feature in Excel switches back and forth between viewing formulas and viewing values in the output cells

Accepted Answer

A) True 
 B)False

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

If two managers are given the same business problem to analyze with a spreadsheet,their spreadsheet models will likely be almost identical

Accepted Answer

A) True 
 B)False

Question 14

The data is the first thing that should be entered in a 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

What are some ways to distinguish data cells,changing cells,output cells,and the objective cell on a spreadsheet?

Accepted Answer

A) Borders 
B) Shading 
C) Color 
D) All of the above 
E) a and c only 
A) Borders 
B) Shading 
C) Color 
D) All of the above 
E) a and c only

Question 17

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

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

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

Once the data is entered,it should never be moved

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

Which of the following best describes spaghetti code?

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

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

The toggle feature in Excel switches back and forth between viewing formulas and viewing values in the output cells

How many cells should be used to represent each constraint?

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

Which of the following are valid range names in Excel?

If two managers are given the same business problem to analyze with a spreadsheet,their spreadsheet models will likely be almost identical

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

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

What are some ways to distinguish data cells,changing cells,output cells,and the objective cell on a spreadsheet?

Each data value should be entered into how many cells?

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

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

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

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 withy es-Or-No decisions

Non linear programming

Decision Analysis

Forecasting

Queuing models

Computer simulation: Basic Concepts

Computer simulation with risks olver platform

Solution concepts for linear programming

Transportation and assignment problems

Pert CPM models for project management

Goal programming

Inventory management with known demand

Inventory management with uncertain demand

Computer simulation with crystal ball

Filters

Exam 4: Theart of modeling with spread sheets

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

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

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

Once the data is entered,it should never be moved

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

Which of the following best describes spaghetti code?

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

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

The toggle feature in Excel switches back and forth between viewing formulas and viewing values in the output cells

How many cells should be used to represent each constraint?

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

Which of the following are valid range names in Excel?

If two managers are given the same business problem to analyze with a spreadsheet,their spreadsheet models will likely be almost identical

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

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

What are some ways to distinguish data cells,changing cells,output cells,and the objective cell on a spreadsheet?

Each data value should be entered into how many cells?

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

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

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

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 withy es-Or-No decisions

Non linear programming

Decision Analysis

Forecasting

Queuing models

Computer simulation: Basic Concepts

Computer simulation with risks olver platform

Solution concepts for linear programming

Transportation and assignment problems

Pert CPM models for project management

Goal programming

Inventory management with known demand

Inventory management with uncertain demand

Computer simulation with crystal ball

Filters