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

One mistake Excel users make in forming the DATA TABLE is:

Accepted Answer

A)  use too large data steps. 
B)  use incorrect addressing. 
C)  forget to leave the first cell blank in the data column. 
D)  forget to label the columns. 
E)  modify the default settings. 
A)  use too large data steps. 
B)  use incorrect addressing. 
C)  forget to leave the first cell blank in the data column. 
D)  forget to label the columns. 
E)  modify the default settings.

Question 3

Excel's COUNT function returns the ______ of cells containing numerical values.

Accepted Answer

The answer of Excel's COUNT function returns the ______ of...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

One reason for models is the need to make a decision.

Accepted Answer

A) True 
 B)False

Question 6

Models can also be described as:

Accepted Answer

A)  an abstraction of the real situation 
B)  an accurate representation of the real situation 
C)  the decision 
D)  absolute representation of reality 
E)  a general view of reality 
A)  an abstraction of the real situation 
B)  an accurate representation of the real situation 
C)  the decision 
D)  absolute representation of reality 
E)  a general view of reality

Question 7

More times than not, modelers tend to ignore making the model flexible because:

Accepted Answer

A)  they don't know how. 
B)  it takes too much time. 
C)  it provides little benefit. 
D)  they believe the model is a onetime use item. 
E)  they want to keep the model modification control to themselves. 
A)  they don't know how. 
B)  it takes too much time. 
C)  it provides little benefit. 
D)  they believe the model is a onetime use item. 
E)  they want to keep the model modification control to themselves.

Question 8

You can insert __________________ for a cell to add explanatory information about a calculation or assumption that does not have to be in the model itself.

Accepted Answer

A)  Cell Explanations 
B)  Cell Descriptions 
C)  Cell Comments 
D)  Cell Information 
E)  Cell Documentation 
A)  Cell Explanations 
B)  Cell Descriptions 
C)  Cell Comments 
D)  Cell Information 
E)  Cell Documentation

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

Data tables perform _____________ what-if ___________ quickly and easily.

Accepted Answer

repetitive

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

If you use the Excel Stacked column chart option, you must select the individual data sets and the sum of the data sets.

Accepted Answer

A) True 
 B)False

Question 13

What are the five guidelines for good spreadsheet documentation?

Accepted Answer

1. Include descriptive text labels for a

Question 14

In the Excel MATCH function, which argument defines the range of values for which you want to look for a match?

Accepted Answer

A)  Lookup_array 
B)  Range 
C)  Array 
D)  Lookup_value 
E)  Match_type 
A)  Lookup_array 
B)  Range 
C)  Array 
D)  Lookup_value 
E)  Match_type

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

In Excel, the command to print Cell Comments is selected under which menu/submenu?

Accepted Answer

A)  Print 
B)  Page Setup 
C)  Tools 
D)  View 
E)  Insert 
A)  Print 
B)  Page Setup 
C)  Tools 
D)  View 
E)  Insert

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

One mistake Excel users make in forming the DATA TABLE is:

Excel's COUNT function returns the ______ of cells containing numerical values.

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

One reason for models is the need to make a decision.

Models can also be described as:

More times than not, modelers tend to ignore making the model flexible because:

You can insert __________________ for a cell to add explanatory information about a calculation or assumption that does not have to be in the model itself.

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

Data tables perform ___ what-if _ quickly and easily.

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

If you use the Excel Stacked column chart option, you must select the individual data sets and the sum of the data sets.

What are the five guidelines for good spreadsheet documentation?

In the Excel MATCH function, which argument defines the range of values for which you want to look for a match?

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

In Excel, the command to print Cell Comments is selected under which menu/submenu?

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

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

One mistake Excel users make in forming the DATA TABLE is:

Excel's COUNT function returns the ______ of cells containing numerical values.

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

One reason for models is the need to make a decision.

Models can also be described as:

More times than not, modelers tend to ignore making the model flexible because:

You can insert __________________ for a cell to add explanatory information about a calculation or assumption that does not have to be in the model itself.

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

Data tables perform _____________ what-if ___________ quickly and easily.

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

If you use the Excel Stacked column chart option, you must select the individual data sets and the sum of the data sets.

What are the five guidelines for good spreadsheet documentation?

In the Excel MATCH function, which argument defines the range of values for which you want to look for a match?

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

In Excel, the command to print Cell Comments is selected under which menu/submenu?

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

Data tables perform ___ what-if _ quickly and easily.