Question 1

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  False

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Describe the difference between an XY graph and a Line graph.

Accepted Answer

For an XY graph,the X (horizontal)axis contains a quantitative variable.In a Line graph,the horizontal axis serves as a category axis.

Question 4

Which of the following models is "built" in the user's head and represents the most common form of model?

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 5

In Excel,to center a label that continues across several cells,highlight the cells,go to Format/Cell/Alignment,and click on _____________________.

Accepted Answer

A) Center 
B) Center across selection 
C) Justify 
D) Fill 
E) General 
A) Center 
B) Center across selection 
C) Justify 
D) Fill 
E) General

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

To add Cell Comments for a cell in Excel,right-click and choose ____________________.

Accepted Answer

A) Insert Comment 
B) Format Cells… 
C) Hyperlink… 
D) Insert… 
E) Pick From List… 
A) Insert Comment 
B) Format Cells… 
C) Hyperlink… 
D) Insert… 
E) Pick From List…

Question 8

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 9

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 10

One of the first things you must do in developing a model is:

Accepted Answer

A) select the correct modeling software. 
B) consult a transformation text book. 
C) determine the formulas that are required. 
D) define the logic necessary to transform the inputs into the outputs. 
E) backwards calculate what inputs are required for the defined inputs. 
A) select the correct modeling software. 
B) consult a transformation text book. 
C) determine the formulas that are required. 
D) define the logic necessary to transform the inputs into the outputs. 
E) backwards calculate what inputs are required for the defined inputs.

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

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

Accepted Answer

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

Question 13

In Excel,what does the formula "=MAX(B25:D25)" do?

Accepted Answer

A) It returns the largest value in either cell B25 or cell D25. 
B) It converts all values in the range between B25 and D25 to the highest value in that range. 
C) Whichever of B25 or D25 is lowest,it converts that value to the other one. 
D) It returns the largest value among cells B25,C25,and D25. 
E) It maximizes the formulas in each of the cells in the range between B25 and D25. 
A) It returns the largest value in either cell B25 or cell D25. 
B) It converts all values in the range between B25 and D25 to the highest value in that range. 
C) Whichever of B25 or D25 is lowest,it converts that value to the other one. 
D) It returns the largest value among cells B25,C25,and D25. 
E) It maximizes the formulas in each of the cells in the range between B25 and D25.

Question 14

Once you run Goal Seek in Excel,you cannot revert back to the original values.

Accepted Answer

A) True 
 B)False

Question 15

Absolute references do _____________ change when you copy them.

Accepted Answer

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

Question 16

The sample standard deviation is found by using the Excel ___________ function.

Accepted Answer

The answer of The sample standard deviation is found by...

Question 17

In the Excel MATCH function,which "Match_type" forces the MATCH function to look for an exact match of Lookup_value in Lookup_array?

Accepted Answer

A) 10 
B) 0 
C) -1 
D) 1 
E) E 
A) 10 
B) 0 
C) -1 
D) 1 
E) E

Question 18

A _________________ is a picture or diagram identifying controllable and uncontrollable inputs and outputs.

Accepted Answer

The answer of A _________________ is a picture or diagram...

Question 19

What is a primary reason why recommended footers contain the date and time?

Accepted Answer

So the user will alw

Question 20

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

Accepted Answer

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

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

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

Describe the difference between an XY graph and a Line graph.

Which of the following models is "built" in the user's head and represents the most common form of model?

In Excel,to center a label that continues across several cells,highlight the cells,go to Format/Cell/Alignment,and click on _____________________.

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

To add Cell Comments for a cell in Excel,right-click and choose ____________________.

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

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.

One of the first things you must do in developing a model is:

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

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

In Excel,what does the formula "=MAX(B25:D25)" do?

Once you run Goal Seek in Excel,you cannot revert back to the original values.

Absolute references do _____________ change when you copy them.

The sample standard deviation is found by using the Excel ___________ function.

In the Excel MATCH function,which "Match_type" forces the MATCH function to look for an exact match of Lookup_value in Lookup_array?

A _________________ is a picture or diagram identifying controllable and uncontrollable inputs and outputs.

What is a primary reason why recommended footers contain the date and time?

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

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

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

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

Describe the difference between an XY graph and a Line graph.

Which of the following models is "built" in the user's head and represents the most common form of model?

In Excel,to center a label that continues across several cells,highlight the cells,go to Format/Cell/Alignment,and click on _____________________.

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

To add Cell Comments for a cell in Excel,right-click and choose ____________________.

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

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.

One of the first things you must do in developing a model is:

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

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

In Excel,what does the formula "=MAX(B25:D25)" do?

Once you run Goal Seek in Excel,you cannot revert back to the original values.

Absolute references do _____________ change when you copy them.

The sample standard deviation is found by using the Excel ___________ function.

In the Excel MATCH function,which "Match_type" forces the MATCH function to look for an exact match of Lookup_value in Lookup_array?

A _________________ is a picture or diagram identifying controllable and uncontrollable inputs and outputs.

What is a primary reason why recommended footers contain the date and time?

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

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