Question 1

What Excel feature works backwards to find the value of an input quantity that causes an output quantity to have a particular value?

Accepted Answer

A)  Goal Seek 
B)  Goal Snitch 
C)  FIRSTCOME 
D)  FIRSTSERVE 
E)  PARTVALUE$ 
A)  Goal Seek 
B)  Goal Snitch 
C)  FIRSTCOME 
D)  FIRSTSERVE 
E)  PARTVALUE$ A

Question 2

Models transform inputs into ________________________

Accepted Answer

outputs

Question 3

The most common form of models are mathematical models.

Accepted Answer

A) True 
 B)False  False

Question 4

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 5

If the model produces the numerically correct values, it is said to be:

Accepted Answer

A)  flexible 
B)  adjustable 
C)  a transformation 
D)  accurate 
E)  inaccurate 
A)  flexible 
B)  adjustable 
C)  a transformation 
D)  accurate 
E)  inaccurate

Question 6

Which of the following is a means of implementing mathematical models?

Accepted Answer

A)  physical model 
B)  spiritual model 
C)  mental model 
D)  spreadsheet model 
E)  visual model 
A)  physical model 
B)  spiritual model 
C)  mental model 
D)  spreadsheet model 
E)  visual model

Question 7

What are the three types of charts available in Excel to illustrate model results?

Accepted Answer

XY chart,

Question 8

The key to spreadsheet model flexibility is to keep all the ___________ of the model separate from the ______________ of the model.

Accepted Answer

A)  inputs; formulas 
B)  inputs; outputs 
C)  outputs; formulas 
D)  constraints; formulas 
E)  parameters; decision variables 
A)  inputs; formulas 
B)  inputs; outputs 
C)  outputs; formulas 
D)  constraints; formulas 
E)  parameters; decision variables

Question 9

In Excel, absolute references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

Accepted Answer

A) True 
 B)False

Question 10

One reason for intermediate spreadsheet calculations is management is often interested in more detail than the final results.

Accepted Answer

A) True 
 B)False

Question 11

In Excel, ___________________ references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

Accepted Answer

A)  absolute 
B)  comparative 
C)  analogous 
D)  relative 
E)  correlative 
A)  absolute 
B)  comparative 
C)  analogous 
D)  relative 
E)  correlative

Question 12

Using Excel, what method other than the algebraic one can be used to find the breakeven quantity?

Accepted Answer

A)  Goal Seek 
B)  Find 
C)  Search 
D)  Break Even 
E)  Steepest Ascent 
A)  Goal Seek 
B)  Find 
C)  Search 
D)  Break Even 
E)  Steepest Ascent

Question 13

In Excel, which function key toggles between relative and absolute cell referencing when editing a formula?

Accepted Answer

A)  F1 
B)  F2 
C)  F3 
D)  F4 
E)  F5 
A)  F1 
B)  F2 
C)  F3 
D)  F4 
E)  F5

Question 14

What is the advantage of using a Stacked Column chart?

Accepted Answer

The contribution of

Question 15

A model __________ inputs into ______.

Accepted Answer

A)  estimates, transformation 
B)  transformation, estimates 
C)  transforms, outputs 
D)  makes, parameters 
E)  modifies, decision variables 
A)  estimates, transformation 
B)  transformation, estimates 
C)  transforms, outputs 
D)  makes, parameters 
E)  modifies, decision variables

Question 16

Absolute references do _____________ change when you copy them.

Accepted Answer

The answer of Absolute references do _____________ change when you...

Question 17

In Excel, which function takes a range of values as its input and returns the smallest value from that range?

Accepted Answer

A)  INF 
B)  SMALL 
C)  LITTLE 
D)  MIN 
E)  LOW 
A)  INF 
B)  SMALL 
C)  LITTLE 
D)  MIN 
E)  LOW

Question 18

Excel's INDEX function requires the user to use all three arguments for a valid response.

Accepted Answer

A) True 
 B)False

Question 19

Describe five main types of models.

Accepted Answer

Mental models are "built" in our heads a

Question 20

Controllable inputs are also called _________________________.

Accepted Answer

A)  decision variables 
B)  parameters 
C)  regulated inputs 
D)  regulated variables 
E)  dominant variables 
A)  decision variables 
B)  parameters 
C)  regulated inputs 
D)  regulated variables 
E)  dominant variables

What Excel feature works backwards to find the value of an input quantity that causes an output quantity to have a particular value?

Models transform inputs into ________________________

The most common form of models are mathematical models.

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

If the model produces the numerically correct values, it is said to be:

Which of the following is a means of implementing mathematical models?

What are the three types of charts available in Excel to illustrate model results?

The key to spreadsheet model flexibility is to keep all the _ of the model separate from the ____ of the model.

In Excel, absolute references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

One reason for intermediate spreadsheet calculations is management is often interested in more detail than the final results.

In Excel, ___________________ references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

Using Excel, what method other than the algebraic one can be used to find the breakeven quantity?

In Excel, which function key toggles between relative and absolute cell referencing when editing a formula?

What is the advantage of using a Stacked Column chart?

A model ____ inputs into .

Absolute references do _____________ change when you copy them.

In Excel, which function takes a range of values as its input and returns the smallest value from that range?

Excel's INDEX function requires the user to use all three arguments for a valid response.

Describe five main types of models.

Controllable inputs are also called _________________________.

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

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

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 Excel feature works backwards to find the value of an input quantity that causes an output quantity to have a particular value?

Models transform inputs into ________________________

The most common form of models are mathematical models.

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

If the model produces the numerically correct values, it is said to be:

Which of the following is a means of implementing mathematical models?

What are the three types of charts available in Excel to illustrate model results?

The key to spreadsheet model flexibility is to keep all the ___________ of the model separate from the ______________ of the model.

In Excel, absolute references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

One reason for intermediate spreadsheet calculations is management is often interested in more detail than the final results.

In Excel, ___________________ references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

Using Excel, what method other than the algebraic one can be used to find the breakeven quantity?

In Excel, which function key toggles between relative and absolute cell referencing when editing a formula?

What is the advantage of using a Stacked Column chart?

A model __________ inputs into ______.

Absolute references do _____________ change when you copy them.

In Excel, which function takes a range of values as its input and returns the smallest value from that range?

Excel's INDEX function requires the user to use all three arguments for a valid response.

Describe five main types of models.

Controllable inputs are also called _________________________.

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

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

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

The key to spreadsheet model flexibility is to keep all the _ of the model separate from the ____ of the model.

A model ____ inputs into .