Question 1

Spreadsheet flexibility implies that the user should enter each input only once in the model.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

Accepted Answer

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

Question 4

When the "Formulas" box is checked under Tools/Options/View, what happens to the size of the columns?

Accepted Answer

A) The widths are cut in half. 
B) There's no change in the column size. 
C) The widths are doubled. 
D) Columns containing items are doubled in size and empty columns are cut in half. 
E) Their widths are automatically expanded to the size of the printed formulas. 
A) The widths are cut in half. 
B) There's no change in the column size. 
C) The widths are doubled. 
D) Columns containing items are doubled in size and empty columns are cut in half. 
E) Their widths are automatically expanded to the size of the printed formulas.

Question 5

Suppose that the formula in cell C8 is "=H2+$P6". If cell C8 is copied to cell E7, the formula in cell E7 will be "=J1+R5".

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

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 9

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 10

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 11

If a model produces numerically correct values for the outputs for any legitimate values of inputs, it is said to be

Accepted Answer

A) flexible 
B) adjustable 
C) a transformation 
D) accurate 
E) inaccurate 
A) flexible 
B) adjustable 
C) a transformation 
D) accurate 
E) inaccurate

Question 12

In Excel, ___________________ references are indicated by a dollar sign character preceding the column and the row reference.

Accepted Answer

A) absolute 
B) comparative 
C) analogous 
D) relative 
E) correlative 
A) absolute 
B) comparative 
C) analogous 
D) relative 
E) correlative

Question 13

Describe and discuss the two different types of model inputs.

Accepted Answer

Inputs are quantities or factors that af

Question 14

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 15

A model needs to do more than transform inputs to outputs; it must also:

Accepted Answer

A) modify the process 
B) adjust the controllable inputs 
C) have a purpose 
D) control the output 
E) be accurate 
A) modify the process 
B) adjust the controllable inputs 
C) have a purpose 
D) control the output 
E) be accurate

Question 16

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 17

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

Accepted Answer

A) INF 
B) SMALL 
C) LITTLE 
D) MIN 
E) LOW 
A) INF 
B) SMALL 
C) LITTLE 
D) MIN 
E) LOW

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Inputs are quantities or factors that affect the situation.

Accepted Answer

A) True 
 B)False

Question 20

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

Spreadsheet flexibility implies that the user should enter each input only once in the model.

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

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

When the "Formulas" box is checked under Tools/Options/View, what happens to the size of the columns?

Suppose that the formula in cell C8 is "=H2+$P6". If cell C8 is copied to cell E7, the formula in cell E7 will be "=J1+R5".

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

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

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

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

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

If a model produces numerically correct values for the outputs for any legitimate values of inputs, it is said to be

In Excel, ___________________ references are indicated by a dollar sign character preceding the column and the row reference.

Describe and discuss the two different types of model inputs.

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

A model needs to do more than transform inputs to outputs; it must also:

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

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

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

Inputs are quantities or factors that affect the situation.

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

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

Spreadsheet flexibility implies that the user should enter each input only once in the model.

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

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

When the "Formulas" box is checked under Tools/Options/View, what happens to the size of the columns?

Suppose that the formula in cell C8 is "=H2+$P6". If cell C8 is copied to cell E7, the formula in cell E7 will be "=J1+R5".

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

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

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

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

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

If a model produces numerically correct values for the outputs for any legitimate values of inputs, it is said to be

In Excel, ___________________ references are indicated by a dollar sign character preceding the column and the row reference.

Describe and discuss the two different types of model inputs.

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

A model needs to do more than transform inputs to outputs; it must also:

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

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

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

Inputs are quantities or factors that affect the situation.

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

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