Question 1

If the model produces the numerically correct values,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 2

In Excel,which function returns the number of cells containing numerical values?

Accepted Answer

A) CELLS(range) 
B) NUMBER(range) 
C) VALUES(range) 
D) COUNT(range) 
E) NUMBERS(range) 
A) CELLS(range) 
B) NUMBER(range) 
C) VALUES(range) 
D) COUNT(range) 
E) NUMBERS(range)

Question 3

In the custom footer box in Excel,what symbol precedes the set of brackets containing the commands "[File]," "[Tab]," "[Date]," or "[Time]?"

Accepted Answer

A) * 
B) % 
C) # 
D) @ 
E) & 
A) * 
B) % 
C) # 
D) @ 
E) &

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

In Excel,which function key toggles between relative and absolute cell referencing when editing a formula?

Accepted Answer

A) F1 
B) F2 
C) F3 
D) F4 
E) F5 
A) F1 
B) F2 
C) F3 
D) F4 
E) F5

Question 7

What is the advantage of using a Stacked Column chart?

Accepted Answer

The contribution of

Question 8

In Excel,what are the keystrokes for the "Copy" 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 9

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

One reason for intermediate spreadsheet calculations is management is often interested in more detail than the final results.

Accepted Answer

A) True 
 B)False

Question 12

Which Excel function takes as inputs two separate ranges,then multiplies each pair of numbers in the ranges,and then adds up all these individual products?

Accepted Answer

A) RANGE 
B) RANGEPRODUCT 
C) PRODUCTSUM 
D) SUMPRODUCT 
E) DOTPRODUCT 
A) RANGE 
B) RANGEPRODUCT 
C) PRODUCTSUM 
D) SUMPRODUCT 
E) DOTPRODUCT

Question 13

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 14

__________________ 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 15

In Excel,you should delete unused worksheets of a workbook.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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 18

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

Accepted Answer

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

Question 19

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 20

The most common form of models are mathematical models.

Accepted Answer

A) True 
 B)False

If the model produces the numerically correct values,it is said to be:

In Excel,which function returns the number of cells containing numerical values?

In the custom footer box in Excel,what symbol precedes the set of brackets containing the commands "[File]," "[Tab]," "[Date]," or "[Time]?"

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

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

In Excel,which function key toggles between relative and absolute cell referencing when editing a formula?

What is the advantage of using a Stacked Column chart?

In Excel,what are the keystrokes for the "Copy" 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".

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

One reason for intermediate spreadsheet calculations is management is often interested in more detail than the final results.

Which Excel function takes as inputs two separate ranges,then multiplies each pair of numbers in the ranges,and then adds up all these individual products?

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

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

In Excel,you should delete unused worksheets of a workbook.

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".

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

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

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

The most common form of models are mathematical models.

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

If the model produces the numerically correct values,it is said to be:

In Excel,which function returns the number of cells containing numerical values?

In the custom footer box in Excel,what symbol precedes the set of brackets containing the commands "[File]," "[Tab]," "[Date]," or "[Time]?"

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

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

In Excel,which function key toggles between relative and absolute cell referencing when editing a formula?

What is the advantage of using a Stacked Column chart?

In Excel,what are the keystrokes for the "Copy" 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".

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

One reason for intermediate spreadsheet calculations is management is often interested in more detail than the final results.

Which Excel function takes as inputs two separate ranges,then multiplies each pair of numbers in the ranges,and then adds up all these individual products?

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

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

In Excel,you should delete unused worksheets of a workbook.

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".

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

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

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

The most common form of models are mathematical models.

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