Question 1

Formulas are entered into Excel by first typing which key?

Accepted Answer

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

Question 2

Which of the following models uses equations and relationships among quantities to represent situations?

Accepted Answer

A)  physical model 
B)  mathematical model 
C)  mental model 
D)  spreadsheet model 
E)  visual model 
A)  physical model 
B)  mathematical model 
C)  mental model 
D)  spreadsheet model 
E)  visual model

Question 3

What are the most important three dimensions along which a spreadsheet model should be evaluated?

Accepted Answer

A)  aesthetic, correct, and flexible 
B)  aesthetic, documented, and flexible 
C)  correct, documented, and flexible 
D)  aesthetic, correct, and documented 
E)  correct, documented, and random 
A)  aesthetic, correct, and flexible 
B)  aesthetic, documented, and flexible 
C)  correct, documented, and flexible 
D)  aesthetic, correct, and documented 
E)  correct, documented, and random

Question 4

Research has shown that most spreadsheet developers believe their products:

Accepted Answer

A)  accurately reflect reality. 
B)  are error free. 
C)  are the best solution. 
D)  are eloquent solutions to the decision. 
E)  deserve more credit. 
A)  accurately reflect reality. 
B)  are error free. 
C)  are the best solution. 
D)  are eloquent solutions to the decision. 
E)  deserve more credit.

Question 5

Inputs are quantities or factors that affect the situation.

Accepted Answer

A) True 
 B)False

Question 6

One of the first things you must do in developing a model is:

Accepted Answer

A)  select the correct modeling software. 
B)  consult a transformation text book. 
C)  determine the formulas that are required. 
D)  define the logic necessary to transform the inputs into the outputs. 
E)  backwards calculate what inputs are required for the defined inputs. 
A)  select the correct modeling software. 
B)  consult a transformation text book. 
C)  determine the formulas that are required. 
D)  define the logic necessary to transform the inputs into the outputs. 
E)  backwards calculate what inputs are required for the defined inputs.

Question 7

Describe the difference between an XY graph and a Line graph.

Accepted Answer

For an XY graph, the X (horizo

Question 8

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 9

Describe the difference between the MAX and MIN Excel functions.

Accepted Answer

The MAX function takes a range of values

Question 10

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 11

Which of the following models involves objects that represent other objects?

Accepted Answer

A)  physical model 
B)  mathematical model 
C)  mental model 
D)  spreadsheet model 
E)  visual model 
A)  physical model 
B)  mathematical model 
C)  mental model 
D)  spreadsheet model 
E)  visual model

Question 12

The MATCH function in Excel returns the value from the range in the position specified.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

Define and describe a model.

Accepted Answer

A model is a purposeful representation o

Question 16

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 17

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

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 20

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

Accepted Answer

A) True 
 B)False

Formulas are entered into Excel by first typing which key?

Which of the following models uses equations and relationships among quantities to represent situations?

What are the most important three dimensions along which a spreadsheet model should be evaluated?

Research has shown that most spreadsheet developers believe their products:

Inputs are quantities or factors that affect the situation.

One of the first things you must do in developing a model is:

Describe the difference between an XY graph and a Line graph.

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

Describe the difference between the MAX and MIN Excel functions.

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

Which of the following models involves objects that represent other objects?

The MATCH function in Excel returns the value from the range in the position specified.

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

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

Define and describe a model.

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

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

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

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

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

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

Formulas are entered into Excel by first typing which key?

Which of the following models uses equations and relationships among quantities to represent situations?

What are the most important three dimensions along which a spreadsheet model should be evaluated?

Research has shown that most spreadsheet developers believe their products:

Inputs are quantities or factors that affect the situation.

One of the first things you must do in developing a model is:

Describe the difference between an XY graph and a Line graph.

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

Describe the difference between the MAX and MIN Excel functions.

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

Which of the following models involves objects that represent other objects?

The MATCH function in Excel returns the value from the range in the position specified.

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

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

Define and describe a model.

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

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

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

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

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

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