Question 1

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

Accepted Answer

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

Question 2

__________ 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 3

__________ and ___________ cell referencing allows you to write one formula and then copy it.

Accepted Answer

The answer of __________ and ___________ cell referencing allows you...

Question 4

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 5

Define an output.

Accepted Answer

An output is a quant

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The benefits of including a particular factor in a model must be weighed against the decreased complexity of the model resulting from its inclusion.

Accepted Answer

A) True 
 B)False

Question 8

The Excel function that multiplies corresponding numbers in the two ranges and returns the sum of those products is the ________________ function.

Accepted Answer

The answer of The Excel function that multiplies corresponding numbers...

Question 9

The key to spreadsheet model flexibility is to keep all the ___________ of the model separate from the ______________ of the model.

Accepted Answer

A) inputs; formulas 
B) inputs; outputs 
C) outputs; formulas 
D) constraints; formulas 
E) parameters; decision variables 
A) inputs; formulas 
B) inputs; outputs 
C) outputs; formulas 
D) constraints; formulas 
E) parameters; decision variables

Question 10

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

Question 11

In Excel,how can one select cells in a range without using the mouse?

Accepted Answer

A) Ctrl+Arrow Keys 
B) Alt+Arrow Keys 
C) Tab+Arrow Keys 
D) F1+Arrow Keys 
E) Shift+Arrow Keys 
A) Ctrl+Arrow Keys 
B) Alt+Arrow Keys 
C) Tab+Arrow Keys 
D) F1+Arrow Keys 
E) Shift+Arrow Keys

Question 12

In Excel,the command to print row and column headings is checked 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

Question 13

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 14

Models transform inputs into ________________________

Accepted Answer

The answer of Models transform inputs into ________________________...

Question 15

Using Excel,what method other than the algebraic one can be used to find the breakeven quantity?

Accepted Answer

A) Goal Seek 
B) Find 
C) Search 
D) Break Even 
E) Steepest Ascent 
A) Goal Seek 
B) Find 
C) Search 
D) Break Even 
E) Steepest Ascent

Question 16

Define and describe a model.

Accepted Answer

A model is a purposeful representation o

Question 17

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 18

In Excel,what is the shortcut to view formulas on the spreadsheet?

Accepted Answer

A) Ctrl+' 
B) Ctrl+` 
C) Ctrl+F 
D) Ctrl+^ 
E) Ctrl+~ 
A) Ctrl+' 
B) Ctrl+` 
C) Ctrl+F 
D) Ctrl+^ 
E) Ctrl+~

Question 19

In Excel,relative 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

Question 20

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

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

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

and _ cell referencing allows you to write one formula and then copy it.

Uncontrollable inputs are also called _______________________.

Define an output.

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

The benefits of including a particular factor in a model must be weighed against the decreased complexity of the model resulting from its inclusion.

The Excel function that multiplies corresponding numbers in the two ranges and returns the sum of those products is the ________________ function.

The key to spreadsheet model flexibility is to keep all the _ of the model separate from the ____ of the model.

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

In Excel,how can one select cells in a range without using the mouse?

In Excel,the command to print row and column headings is checked under which menu/submenu?

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

Models transform inputs into ________________________

Using Excel,what method other than the algebraic one can be used to find the breakeven quantity?

Define and describe a model.

Models can also be described as:

In Excel,what is the shortcut to view formulas on the spreadsheet?

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

How many arguments does the MATCH function in Excel take?

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

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

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

__________ and ___________ cell referencing allows you to write one formula and then copy it.

Uncontrollable inputs are also called _______________________.

Define an output.

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

The benefits of including a particular factor in a model must be weighed against the decreased complexity of the model resulting from its inclusion.

The Excel function that multiplies corresponding numbers in the two ranges and returns the sum of those products is the ________________ function.

The key to spreadsheet model flexibility is to keep all the ___________ of the model separate from the ______________ of the model.

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

In Excel,how can one select cells in a range without using the mouse?

In Excel,the command to print row and column headings is checked under which menu/submenu?

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

Models transform inputs into ________________________

Using Excel,what method other than the algebraic one can be used to find the breakeven quantity?

Define and describe a model.

Models can also be described as:

In Excel,what is the shortcut to view formulas on the spreadsheet?

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

How many arguments does the MATCH function in Excel take?

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

and _ cell referencing allows you to write one formula and then copy it.

The key to spreadsheet model flexibility is to keep all the _ of the model separate from the ____ of the model.