Question 1

What are the five guidelines for good spreadsheet documentation?

Accepted Answer

1.Include descriptive text labels for al

Question 2

A model is correct if it produces the _______________ correct _________ for the outputs for the current values of the inputs

Accepted Answer

The answer of A model is correct if it produces...

Question 3

What are the two main reasons why one should break up larger calculations into smaller ones in spreadsheet modeling?

Accepted Answer

A) to speed solution time and to determine intermediate values 
B) to speed solution time and to avoid errors 
C) so the formula can fit on the formula line and to speed solution time 
D) to avoid errors and to determine intermediate values 
E) so the formula can fit on the formula line and to avoid errors 
A) to speed solution time and to determine intermediate values 
B) to speed solution time and to avoid errors 
C) so the formula can fit on the formula line and to speed solution time 
D) to avoid errors and to determine intermediate values 
E) so the formula can fit on the formula line and to avoid errors

Question 4

There are a number of different model types which do not share any commonalities.

Accepted Answer

A) True 
 B)False

Question 5

Research has shown that most spreadsheet model developers believe their products to be error-free,but this assessment is usually wrong.

Accepted Answer

A) True 
 B)False

Question 6

Describe and discuss the two different types of model inputs.

Accepted Answer

Inputs are quantities or factors that af

Question 7

Formulas are entered into Excel by first typing which key?

Accepted Answer

A) ^ 
B) & 
C) # 
D) ! 
E) = 
A) ^ 
B) & 
C) # 
D) ! 
E) =

Question 8

A common practice of scenario analysis is to examine the base case,best case,and worst case scenarios.

Accepted Answer

A) True 
 B)False

Question 9

___________________ perform repetitive what-if analysis quickly and easily in Excel.

Accepted Answer

A) What-If Tables 
B) Repetitive Tables 
C) Sensitivity Tables 
D) Scenario Tables 
E) Data Tables 
A) What-If Tables 
B) Repetitive Tables 
C) Sensitivity Tables 
D) Scenario Tables 
E) Data Tables

Question 10

Describe the difference between the MAX and MIN Excel functions.

Accepted Answer

The MAX function takes a range of values

Question 11

In the custom footer box,which of the following is the command to insert the worksheet name?

Accepted Answer

A) &[worksheet] 
B) &[tab] 
C) &[work] 
D) &[sheet] 
E) &[page] 
A) &[worksheet] 
B) &[tab] 
C) &[work] 
D) &[sheet] 
E) &[page]

Question 12

Which of the following is not one of the standard items included in a footer?

Accepted Answer

A) worksheet name 
B) author name 
C) solution time 
D) date 
E) time 
A) worksheet name 
B) author name 
C) solution time 
D) date 
E) time

Question 13

Research has shown that most spreadsheet developers believe their products:

Accepted Answer

A) accurately reflect reality. 
B) are error free. 
C) are the best solution. 
D) are eloquent solutions to the decision. 
E) deserve more credit. 
A) accurately reflect reality. 
B) are error free. 
C) are the best solution. 
D) are eloquent solutions to the decision. 
E) deserve more credit.

Question 14

Describe the "IF" function in Excel.

Accepted Answer

The three arguments are Lookup_value,Loo

Question 15

For the Goal Seek feature in Excel,it doesn't matter whether you use absolute or relative references.

Accepted Answer

A) True 
 B)False

Question 16

The principle,"Do not hard-code an input directly into a formula," is the main feature of spreadsheet ________________.

Accepted Answer

A) correctness 
B) documentation 
C) aesthetics 
D) flexibility 
E) randomness 
A) correctness 
B) documentation 
C) aesthetics 
D) flexibility 
E) randomness

Question 17

Inputs are quantities or factors that affect the situation.

Accepted Answer

A) True 
 B)False

Question 18

In a spreadsheet,it is better to write a smaller number of more complex formulas than to write a larger number of simple formulas.

Accepted Answer

A) True 
 B)False

Question 19

In general,when using large dollar amounts,always use the cents,but small dollar amounts can be rounded off to whole numbers.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is not one of the standard items included in a footer?

Accepted Answer

A) file name 
B) author name 
C) user name 
D) date 
E) time 
A) file name 
B) author name 
C) user name 
D) date 
E) time

What are the five guidelines for good spreadsheet documentation?

A model is correct if it produces the _______ correct _ for the outputs for the current values of the inputs

What are the two main reasons why one should break up larger calculations into smaller ones in spreadsheet modeling?

There are a number of different model types which do not share any commonalities.

Research has shown that most spreadsheet model developers believe their products to be error-free,but this assessment is usually wrong.

Describe and discuss the two different types of model inputs.

Formulas are entered into Excel by first typing which key?

A common practice of scenario analysis is to examine the base case,best case,and worst case scenarios.

___________________ perform repetitive what-if analysis quickly and easily in Excel.

Describe the difference between the MAX and MIN Excel functions.

In the custom footer box,which of the following is the command to insert the worksheet name?

Which of the following is not one of the standard items included in a footer?

Research has shown that most spreadsheet developers believe their products:

Describe the "IF" function in Excel.

For the Goal Seek feature in Excel,it doesn't matter whether you use absolute or relative references.

The principle,"Do not hard-code an input directly into a formula," is the main feature of spreadsheet ________________.

Inputs are quantities or factors that affect the situation.

In a spreadsheet,it is better to write a smaller number of more complex formulas than to write a larger number of simple formulas.

In general,when using large dollar amounts,always use the cents,but small dollar amounts can be rounded off to whole numbers.

Which of the following is not one of the standard items included in a footer?

Introduction to Operations

Operations Strategy and Competitiveness

Product Design and Process Selection

E-Commerce and Supply Chain Management

Total Quality Management

Statistical Quality Control

Just-In-Time and Lean Systems

Forecasting

Capacity Planning and Facility Location

Facility Layout

Work System Design

Independent Demand Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Introduction to Optimization

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters

Exam 17: Spreadsheet Modeling: an Introduction

What are the five guidelines for good spreadsheet documentation?

A model is correct if it produces the _______________ correct _________ for the outputs for the current values of the inputs

What are the two main reasons why one should break up larger calculations into smaller ones in spreadsheet modeling?

There are a number of different model types which do not share any commonalities.

Research has shown that most spreadsheet model developers believe their products to be error-free,but this assessment is usually wrong.

Describe and discuss the two different types of model inputs.

Formulas are entered into Excel by first typing which key?

A common practice of scenario analysis is to examine the base case,best case,and worst case scenarios.

___________________ perform repetitive what-if analysis quickly and easily in Excel.

Describe the difference between the MAX and MIN Excel functions.

In the custom footer box,which of the following is the command to insert the worksheet name?

Which of the following is not one of the standard items included in a footer?

Research has shown that most spreadsheet developers believe their products:

Describe the "IF" function in Excel.

For the Goal Seek feature in Excel,it doesn't matter whether you use absolute or relative references.

The principle,"Do not hard-code an input directly into a formula," is the main feature of spreadsheet ________________.

Inputs are quantities or factors that affect the situation.

In a spreadsheet,it is better to write a smaller number of more complex formulas than to write a larger number of simple formulas.

In general,when using large dollar amounts,always use the cents,but small dollar amounts can be rounded off to whole numbers.

Which of the following is not one of the standard items included in a footer?

Introduction to Operations

Operations Strategy and Competitiveness

Product Design and Process Selection

E-Commerce and Supply Chain Management

Total Quality Management

Statistical Quality Control

Just-In-Time and Lean Systems

Forecasting

Capacity Planning and Facility Location

Facility Layout

Work System Design

Independent Demand Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Introduction to Optimization

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters

A model is correct if it produces the _______ correct _ for the outputs for the current values of the inputs