Question 1

Break-even analysis is one special case of _________________ analysis.

Accepted Answer

A) scenario 
B) transformation 
C) sensitivity 
D) decision 
E) change 
A) scenario 
B) transformation 
C) sensitivity 
D) decision 
E) change

Question 2

How many arguments does the MATCH function in Excel take?

Accepted Answer

A) 1 
B) 2 
C) 3 
D) 4 
E) 5 
A) 1 
B) 2 
C) 3 
D) 4 
E) 5

Question 3

__________ is the model that contains the "default" or "given" values for the inputs

Accepted Answer

The answer of __________ is the model that contains the...

Question 4

In Excel, relative references do not change when you copy them.

Accepted Answer

A) True 
 B)False

Question 5

A(n)_______________ is a quantity or factor that depends on how the inputs are related to one another.

Accepted Answer

A) observation 
B) element 
C) equation 
D) integer constraint 
E) output 
A) observation 
B) element 
C) equation 
D) integer constraint 
E) output

Question 6

__________________ analysis deals with studying the changes to the output of the model as one or more of the inputs change.

Accepted Answer

A) Scenario 
B) Transformation 
C) Decision 
D) Sensitivity 
E) Change 
A) Scenario 
B) Transformation 
C) Decision 
D) Sensitivity 
E) Change

Question 7

Define and describe a model.

Accepted Answer

A model is a purposeful representation o

Question 8

In Excel, __________________ references change when you copy them.

Accepted Answer

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

Question 9

Which of the following models uses equations and relationships among quantities to represent situations?

Accepted Answer

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

Question 10

What are the most common useful numerical formats?

Accepted Answer

A) date, currency, and percentage 
B) date, time, and custom 
C) time, custom, and number 
D) number, custom, and percentage 
E) number, currency, and percentage 
A) date, currency, and percentage 
B) date, time, and custom 
C) time, custom, and number 
D) number, custom, and percentage 
E) number, currency, and percentage

Question 11

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

Accepted Answer

XY chart,

Question 12

When you change one or more model inputs, Excel automatically updates the associated Data Table.

Accepted Answer

A) True 
 B)False

Question 13

In Excel, what are the keystrokes for the "Copy" command?

Accepted Answer

A) Ctrl-C 
B) Ctrl-V 
C) Ctrl-X 
D) Ctrl-Z 
E) Ctrl-Q 
A) Ctrl-C 
B) Ctrl-V 
C) Ctrl-X 
D) Ctrl-Z 
E) Ctrl-Q

Question 14

Uncontrollable inputs are also called _______________________.

Accepted Answer

A) decision variables 
B) parameters 
C) unregulated inputs 
D) unregulated variables 
E) recessive variables 
A) decision variables 
B) parameters 
C) unregulated inputs 
D) unregulated variables 
E) recessive variables

Question 15

What are the most important three dimensions along which a spreadsheet model should be evaluated?

Accepted Answer

A) aesthetic, correct, and flexible 
B) aesthetic, documented, and flexible 
C) correct, documented, and flexible 
D) aesthetic, correct, and documented 
E) correct, documented, and random 
A) aesthetic, correct, and flexible 
B) aesthetic, documented, and flexible 
C) correct, documented, and flexible 
D) aesthetic, correct, and documented 
E) correct, documented, and random

Question 16

Describe how a Data Table functions in Excel.

Accepted Answer

The user provides a list of input values

Question 17

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

Question 18

The MATCH function returns the ________________ position in the array that matches the lookup value.

Accepted Answer

The answer of The MATCH function returns the ________________ position...

Question 19

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 20

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

Break-even analysis is one special case of _________________ analysis.

How many arguments does the MATCH function in Excel take?

__________ is the model that contains the "default" or "given" values for the inputs

In Excel, relative references do not change when you copy them.

A(n)_______________ is a quantity or factor that depends on how the inputs are related to one another.

__________________ analysis deals with studying the changes to the output of the model as one or more of the inputs change.

Define and describe a model.

In Excel, __________________ references change when you copy them.

Which of the following models uses equations and relationships among quantities to represent situations?

What are the most common useful numerical formats?

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

When you change one or more model inputs, Excel automatically updates the associated Data Table.

In Excel, what are the keystrokes for the "Copy" command?

Uncontrollable inputs are also called _______________________.

What are the most important three dimensions along which a spreadsheet model should be evaluated?

Describe how a Data Table functions in Excel.

Controllable inputs are also called _________________________.

The MATCH function returns the ________________ position in the array that matches the lookup value.

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

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

Introduction to Operations Management

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

Spreadsheet Modeling: an Introduction

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters

Exam 16: Spreadsheet Modeling: an Introduction

Break-even analysis is one special case of _________________ analysis.

How many arguments does the MATCH function in Excel take?

__________ is the model that contains the "default" or "given" values for the inputs

In Excel, relative references do not change when you copy them.

A(n)_______________ is a quantity or factor that depends on how the inputs are related to one another.

__________________ analysis deals with studying the changes to the output of the model as one or more of the inputs change.

Define and describe a model.

In Excel, __________________ references change when you copy them.

Which of the following models uses equations and relationships among quantities to represent situations?

What are the most common useful numerical formats?

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

When you change one or more model inputs, Excel automatically updates the associated Data Table.

In Excel, what are the keystrokes for the "Copy" command?

Uncontrollable inputs are also called _______________________.

What are the most important three dimensions along which a spreadsheet model should be evaluated?

Describe how a Data Table functions in Excel.

Controllable inputs are also called _________________________.

The MATCH function returns the ________________ position in the array that matches the lookup value.

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

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

Introduction to Operations Management

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

Spreadsheet Modeling: an Introduction

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters