Question 1

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 2

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 3

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 4

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 5

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

Question 6

An absolute reference does not change when it is filled or copied into other cells

Accepted Answer

A) True 
 B)False

Question 7

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 8

Data should be repeated within every output cell as needed

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is not a major step in the process of modeling with spreadsheets?

Accepted Answer

A) Plan 
B) Build 
C) Test 
D) Analyze 
E) All of the above are major steps 
A) Plan 
B) Build 
C) Test 
D) Analyze 
E) All of the above are major steps

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Which of the following is an appropriate first 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

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

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

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

An absolute reference does not change when it is filled or copied into other cells

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

Data should be repeated within every output cell as needed

Which of the following is not a major step in the process of modeling with spreadsheets?

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

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

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 is an appropriate first 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

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

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

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

An absolute reference does not change when it is filled or copied into other cells

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

Data should be repeated within every output cell as needed

Which of the following is not a major step in the process of modeling with spreadsheets?

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

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

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