Question 1

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

Accepted Answer

XY chart,c

Question 2

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

Accepted Answer

A) SUP 
B) LARGE 
C) BIG 
D) HIGH 
E) MAX 
A) SUP 
B) LARGE 
C) BIG 
D) HIGH 
E) MAX

Question 3

In Excel,___________________ references do not 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 4

What are the six steps to developing an effective spreadsheet model?

Accepted Answer

1.Draw a picture to better understand th

Question 5

The Excel function that returns the z-value of the standard normal distribution corresponding to a cumulative probability of p is _______

Accepted Answer

The answer of The Excel function that returns the z-value...

Question 6

Describe five main types of models.

Accepted Answer

Mental models are "built" in our heads a

Question 7

In Excel,what are the three arguments that an INDEX function takes?

Accepted Answer

A) Lookup_value,Match_type,and Lookup_array 
B) Lookup_value,Match_type,and Array 
C) Lookup_value,Column_num,and Lookup_array 
D) Array,Row_num,and Column_num 
E) Lookup_array,Row_num,and Column_num 
A) Lookup_value,Match_type,and Lookup_array 
B) Lookup_value,Match_type,and Array 
C) Lookup_value,Column_num,and Lookup_array 
D) Array,Row_num,and Column_num 
E) Lookup_array,Row_num,and Column_num

Question 8

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$

Question 9

In Excel,which function returns the square root?

Accepted Answer

A) ROOT(number) 
B) SQR(number) 
C) SQRT(number) 
D) SQUAREROOT(number) 
E) ROOT2(number) 
A) ROOT(number) 
B) SQR(number) 
C) SQRT(number) 
D) SQUAREROOT(number) 
E) ROOT2(number)

Question 10

How do you know that you have a relative reference in Excel?

Accepted Answer

There is no dollar s

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

In Excel,the only way to center a label that continues across multiple cells is to edit the cell and use the space key.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

In Excel,the command to print formulas is checked under which menu/submenu?

Accepted Answer

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

Question 17

For the Data Table feature in Excel,it does matter whether you use absolute or relative references.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following models involves objects that represent other objects?

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 19

Although there are a number of different model types,_________ exist among them.

Accepted Answer

The answer of Although there are a number of different...

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 are the three types of charts available in Excel to illustrate model results?

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

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

What are the six steps to developing an effective spreadsheet model?

The Excel function that returns the z-value of the standard normal distribution corresponding to a cumulative probability of p is _______

Describe five main types of models.

In Excel,what are the three arguments that an INDEX function takes?

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

In Excel,which function returns the square root?

How do you know that you have a relative reference in Excel?

A model ____ inputs into .

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

In Excel,the only way to center a label that continues across multiple cells is to edit the cell and use the space key.

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

In Excel,__________________ references change when you copy them.

In Excel,the command to print formulas is checked under which menu/submenu?

For the Data Table feature in Excel,it does matter whether you use absolute or relative references.

Which of the following models involves objects that represent other objects?

Although there are a number of different model types,_________ exist among them.

Controllable inputs are also called _________________________.

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 three types of charts available in Excel to illustrate model results?

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

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

What are the six steps to developing an effective spreadsheet model?

The Excel function that returns the z-value of the standard normal distribution corresponding to a cumulative probability of p is _______

Describe five main types of models.

In Excel,what are the three arguments that an INDEX function takes?

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

In Excel,which function returns the square root?

How do you know that you have a relative reference in Excel?

A model __________ inputs into ______.

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

In Excel,the only way to center a label that continues across multiple cells is to edit the cell and use the space key.

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

In Excel,__________________ references change when you copy them.

In Excel,the command to print formulas is checked under which menu/submenu?

For the Data Table feature in Excel,it does matter whether you use absolute or relative references.

Which of the following models involves objects that represent other objects?

Although there are a number of different model types,_________ exist among them.

Controllable inputs are also called _________________________.

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 ____ inputs into .