Question 1

In Excel, when moving a formula to another cell, it is better to use Copy and Paste rather than Cut and Paste.

Accepted Answer

A) True 
 B)False

Question 2

A model is correct if it produces the _______________ correct _________ for the outputs for the current values of the inputs

Accepted Answer

The answer of A model is correct if it produces...

Question 3

Excel's INDEX function requires the user to use all three arguments for a valid response.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

Suppose that the formula in cell C8 is "=H2+$P6". If cell C8 is copied to cell E10, the formula in cell E10 will be "=J4+$P8".

Accepted Answer

A) True 
 B)False

Question 6

In the custom footer box, the command to insert the worksheet name is "&[Tab]".

Accepted Answer

A) True 
 B)False

Question 7

The most common form of models are mathematical models.

Accepted Answer

A) True 
 B)False

Question 8

A scenario is a specific set of conditions that helps identify the inputs that cause the most change in the outputs.

Accepted Answer

A) True 
 B)False

Question 9

Ideally, a spreadsheet model should be ________________________

Accepted Answer

The answer of Ideally, a spreadsheet model should be ________________________...

Question 10

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 11

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 12

Research has shown that most spreadsheet model developers believe their products to be error-free, but this assessment is usually wrong.

Accepted Answer

A) True 
 B)False

Question 13

In Excel, what are the three arguments that a MATCH 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 14

Define an output.

Accepted Answer

An output is a quant

Question 15

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 16

What are the five guidelines for good spreadsheet documentation?

Accepted Answer

1. Include descriptive text labels for a

Question 17

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 18

Which of the following is not one of the standard items included in a footer?

Accepted Answer

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

Question 19

Formulas are entered into Excel by first typing which key?

Accepted Answer

A) ^ 
B) & 
C) # 
D) ! 
E) = 
A) ^ 
B) & 
C) # 
D) ! 
E) =

Question 20

Up to how many arguments can the INDEX 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

In Excel, when moving a formula to another cell, it is better to use Copy and Paste rather than Cut and Paste.

A model is correct if it produces the _______ correct _ for the outputs for the current values of the inputs

Excel's INDEX function requires the user to use all three arguments for a valid response.

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

Suppose that the formula in cell C8 is "=H2+$P6". If cell C8 is copied to cell E10, the formula in cell E10 will be "=J4+$P8".

In the custom footer box, the command to insert the worksheet name is "&[Tab]".

The most common form of models are mathematical models.

A scenario is a specific set of conditions that helps identify the inputs that cause the most change in the outputs.

Ideally, a spreadsheet model should be ________________________

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

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

Research has shown that most spreadsheet model developers believe their products to be error-free, but this assessment is usually wrong.

In Excel, what are the three arguments that a MATCH function takes?

Define an output.

In Excel, which function returns the square root?

What are the five guidelines for good spreadsheet documentation?

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

Which of the following is not one of the standard items included in a footer?

Formulas are entered into Excel by first typing which key?

Up to how many arguments can the INDEX function in Excel take?

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

In Excel, when moving a formula to another cell, it is better to use Copy and Paste rather than Cut and Paste.

A model is correct if it produces the _______________ correct _________ for the outputs for the current values of the inputs

Excel's INDEX function requires the user to use all three arguments for a valid response.

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

Suppose that the formula in cell C8 is "=H2+$P6". If cell C8 is copied to cell E10, the formula in cell E10 will be "=J4+$P8".

In the custom footer box, the command to insert the worksheet name is "&[Tab]".

The most common form of models are mathematical models.

A scenario is a specific set of conditions that helps identify the inputs that cause the most change in the outputs.

Ideally, a spreadsheet model should be ________________________

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

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

Research has shown that most spreadsheet model developers believe their products to be error-free, but this assessment is usually wrong.

In Excel, what are the three arguments that a MATCH function takes?

Define an output.

In Excel, which function returns the square root?

What are the five guidelines for good spreadsheet documentation?

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

Which of the following is not one of the standard items included in a footer?

Formulas are entered into Excel by first typing which key?

Up to how many arguments can the INDEX function in Excel take?

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 is correct if it produces the _______ correct _ for the outputs for the current values of the inputs