Question 1

Describe five main types of models.

Accepted Answer

Mental models are "built" in our heads a

Question 2

Which of the following does not have a button for automatic insertion into the custom footer box?

Accepted Answer

A) file name 
B) worksheet name 
C) author name 
D) date 
E) time 
A) file name 
B) worksheet name 
C) author name 
D) date 
E) time

Question 3

A road atlas represents which type 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 4

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 5

In Excel, you should delete unused worksheets of a workbook.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

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 9

Which of the following is equivalent to "=SUMPRODUCT(A1:A4,B2:B5)"?

Accepted Answer

A) A1*A4 + B2*B5 
B) A1*B2 + A2*B3 + A3*B4 + A4*B5 
C) (A1+A4)*(B2+B5) 
D) (A1+A2+A3+A4)*(B2+B3+B4+B5) 
E) This is an invalid function. 
A) A1*A4 + B2*B5 
B) A1*B2 + A2*B3 + A3*B4 + A4*B5 
C) (A1+A4)*(B2+B5) 
D) (A1+A2+A3+A4)*(B2+B3+B4+B5) 
E) This is an invalid function.

Question 10

To edit formulas in Excel, you can either double-click on the cell or hit:

Accepted Answer

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

Question 11

Which Excel function takes as inputs two separate ranges, then multiplies each pair of numbers in the ranges, and then adds up all these individual products?

Accepted Answer

A) RANGE 
B) RANGEPRODUCT 
C) PRODUCTSUM 
D) SUMPRODUCT 
E) DOTPRODUCT 
A) RANGE 
B) RANGEPRODUCT 
C) PRODUCTSUM 
D) SUMPRODUCT 
E) DOTPRODUCT

Question 12

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 13

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 14

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 15

In Excel, part of a formula's references can be relative while another part can be absolute.

Accepted Answer

A) True 
 B)False

Question 16

Describe the difference between the MAX and MIN Excel functions.

Accepted Answer

The MAX function takes a range of values

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

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

Accepted Answer

A) True 
 B)False

Question 19

The MATCH function in Excel returns the value from the range in the position specified.

Accepted Answer

A) True 
 B)False

Question 20

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

Describe five main types of models.

Which of the following does not have a button for automatic insertion into the custom footer box?

A road atlas represents which type of model?

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

In Excel, you should delete unused worksheets of a workbook.

A model ____ inputs into .

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

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

Which of the following is equivalent to "=SUMPRODUCT(A1:A4,B2:B5)"?

To edit formulas in Excel, you can either double-click on the cell or hit:

Which Excel function takes as inputs two separate ranges, then multiplies each pair of numbers in the ranges, and then adds up all these individual products?

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

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

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

In Excel, part of a formula's references can be relative while another part can be absolute.

Describe the difference between the MAX and MIN Excel functions.

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

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

The MATCH function in Excel returns the value from the range in the position specified.

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

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

Describe five main types of models.

Which of the following does not have a button for automatic insertion into the custom footer box?

A road atlas represents which type of model?

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

In Excel, you should delete unused worksheets of a workbook.

A model __________ inputs into ______.

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

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

Which of the following is equivalent to "=SUMPRODUCT(A1:A4,B2:B5)"?

To edit formulas in Excel, you can either double-click on the cell or hit:

Which Excel function takes as inputs two separate ranges, then multiplies each pair of numbers in the ranges, and then adds up all these individual products?

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

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

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

In Excel, part of a formula's references can be relative while another part can be absolute.

Describe the difference between the MAX and MIN Excel functions.

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

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

The MATCH function in Excel returns the value from the range in the position specified.

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

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

A model ____ inputs into .