Question 1

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 2

__________________ analysis deals with studying the changes to the output of the model as one or more of the inputs change.

Accepted Answer

A)  Scenario 
B)  Transformation 
C)  Decision 
D)  Sensitivity 
E)  Change 
A)  Scenario 
B)  Transformation 
C)  Decision 
D)  Sensitivity 
E)  Change

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

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 5

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

Question 6

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 7

Describe how a Data Table functions in Excel.

Accepted Answer

The user provides a list of input values

Question 8

A _________________ is a specific set of conditions that could occur in the real situation.

Accepted Answer

A)  parameter 
B)  scenario 
C)  sensitivity set 
D)  break-even set 
E)  circumstance 
A)  parameter 
B)  scenario 
C)  sensitivity set 
D)  break-even set 
E)  circumstance

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

In the custom footer box, there is a button to automatically insert the page number.

Accepted Answer

A) True 
 B)False

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

What are the two main reasons why one should break up larger calculations into smaller ones in spreadsheet modeling?

Accepted Answer

To determine interme

Question 13

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

A(n) _______________ is a quantity or factor that depends on how the inputs are related to one another.

Accepted Answer

A)  observation 
B)  element 
C)  equation 
D)  integer constraint 
E)  output 
A)  observation 
B)  element 
C)  equation 
D)  integer constraint 
E)  output

Question 15

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

Accepted Answer

A)  A1*A4 + B1*B4 
B)  A1*B1 + A2*B2 + A3*B3 + A4*B4 
C)  (A1+A4)*(B1+B4) 
D)  (A1+A2+A3+A4)*(B1+B2+B3+B4) 
E)  A1 + A4*B1 + B4 
A)  A1*A4 + B1*B4 
B)  A1*B1 + A2*B2 + A3*B3 + A4*B4 
C)  (A1+A4)*(B1+B4) 
D)  (A1+A2+A3+A4)*(B1+B2+B3+B4) 
E)  A1 + A4*B1 + B4

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 Excel, what combination of functions can produce the label for an item that equals a given number?

Accepted Answer

A)  MAX and INDEX 
B)  MAX and MIN 
C)  MATCH and INDEX 
D)  MATCH and MAX 
E)  ABS and MAX 
A)  MAX and INDEX 
B)  MAX and MIN 
C)  MATCH and INDEX 
D)  MATCH and MAX 
E)  ABS and MAX

Question 18

Sometimes the things you learn about the real situation during the modeling process are even more important than the numerical results of the model.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

There is no dollar s

Question 20

In the Excel MATCH function, which argument is the value that we want to test?

Accepted Answer

A)  Lookup_array 
B)  Array 
C)  Value 
D)  Match_type 
E)  Lookup_value 
A)  Lookup_array 
B)  Array 
C)  Value 
D)  Match_type 
E)  Lookup_value

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

__________________ analysis deals with studying the changes to the output of the model as one or more of the inputs change.

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

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

How many arguments does the MATCH function in Excel take?

In Excel, __________________ references change when you copy them.

Describe how a Data Table functions in Excel.

A _________________ is a specific set of conditions that could occur in the real situation.

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

In the custom footer box, there is a button to automatically insert the page number.

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

What are the two main reasons why one should break up larger calculations into smaller ones in spreadsheet modeling?

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

A(n) _______________ is a quantity or factor that depends on how the inputs are related to one another.

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

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

In Excel, what combination of functions can produce the label for an item that equals a given number?

Sometimes the things you learn about the real situation during the modeling process are even more important than the numerical results of the model.

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

In the Excel MATCH function, which argument is the value that we want to test?

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

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

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

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

__________________ analysis deals with studying the changes to the output of the model as one or more of the inputs change.

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

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

How many arguments does the MATCH function in Excel take?

In Excel, __________________ references change when you copy them.

Describe how a Data Table functions in Excel.

A _________________ is a specific set of conditions that could occur in the real situation.

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

In the custom footer box, there is a button to automatically insert the page number.

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

What are the two main reasons why one should break up larger calculations into smaller ones in spreadsheet modeling?

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

A(n) _______________ is a quantity or factor that depends on how the inputs are related to one another.

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

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

In Excel, what combination of functions can produce the label for an item that equals a given number?

Sometimes the things you learn about the real situation during the modeling process are even more important than the numerical results of the model.

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

In the Excel MATCH function, which argument is the value that we want to test?

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

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

Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Introduction to Optimization

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters