Question 1

Data tables perform _____________ what-if ___________ quickly and easily.

Accepted Answer

The answer of Data tables perform _____________ what-if ___________ quickly...

Question 2

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 3

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 4

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

Question 5

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 6

In Excel,___________________ references are indicated by the lack of a dollar sign character preceding either the column or 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 7

Ideally,a spreadsheet model should be ________________________

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Question 11

Many seemingly complex spreadsheet models really comprise only a handful of truly distinct formulas.

Accepted Answer

A) True 
 B)False

Question 12

What are the most common useful numerical formats?

Accepted Answer

A) date,currency,and percentage 
B) date,time,and custom 
C) time,custom,and number 
D) number,custom,and percentage 
E) number,currency,and percentage 
A) date,currency,and percentage 
B) date,time,and custom 
C) time,custom,and number 
D) number,custom,and percentage 
E) number,currency,and percentage

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

What does it mean when the formula result of the MATCH function in Excel equals 2?

Accepted Answer

A) Two items matched the Lookup_value. 
B) The item labeled "2" matched the Lookup_value. 
C) The Lookup_value was found in the second position of the Lookup_array. 
D) An error occurred. 
E) The closest item to the Lookup_value was within two units of that value. 
A) Two items matched the Lookup_value. 
B) The item labeled "2" matched the Lookup_value. 
C) The Lookup_value was found in the second position of the Lookup_array. 
D) An error occurred. 
E) The closest item to the Lookup_value was within two units of that value.

Question 16

In Excel,you can copy text labels by using the:

Accepted Answer

A) @ 
B) & 
C) + 
D) = 
E) - 
A) @ 
B) & 
C) + 
D) = 
E) -

Question 17

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

Data tables perform ___ what-if _ quickly and easily.

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

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

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

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

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

Ideally,a spreadsheet model should be ________________________

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

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

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

Many seemingly complex spreadsheet models really comprise only a handful of truly distinct formulas.

What are the most common useful numerical formats?

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

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

What does it mean when the formula result of the MATCH function in Excel equals 2?

In Excel,you can copy text labels by using the:

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

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

Data tables perform _____________ what-if ___________ quickly and easily.

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

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

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

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

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

Ideally,a spreadsheet model should be ________________________

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

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

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

Many seemingly complex spreadsheet models really comprise only a handful of truly distinct formulas.

What are the most common useful numerical formats?

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

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

What does it mean when the formula result of the MATCH function in Excel equals 2?

In Excel,you can copy text labels by using the:

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

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

Data tables perform ___ what-if _ quickly and easily.