Question 1

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 2

If a model produces numerically correct values for the outputs for any legitimate values of inputs,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 3

When the "Formulas" box is checked under Tools/Options/View,what happens to the size of the columns?

Accepted Answer

A) The widths are cut in half. 
B) There's no change in the column size. 
C) The widths are doubled. 
D) Columns containing items are doubled in size and empty columns are cut in half. 
E) Their widths are automatically expanded to the size of the printed formulas. 
A) The widths are cut in half. 
B) There's no change in the column size. 
C) The widths are doubled. 
D) Columns containing items are doubled in size and empty columns are cut in half. 
E) Their widths are automatically expanded to the size of the printed formulas.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

In Excel,absolute 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 6

You can edit Excel formulas by either double-click the cell,or _________________

Accepted Answer

The answer of You can edit Excel formulas by either...

Question 7

Controllable inputs are sometimes called parameters.

Accepted Answer

A) True 
 B)False

Question 8

Describe how a Data Table functions in Excel.

Accepted Answer

The user provides a list of input values

Question 9

A road atlas represents which type of model?

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 10

Which of the following does not have a button for automatic insertion into the custom footer box?

Accepted Answer

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

Question 11

One mistake Excel users make in forming the DATA TABLE is:

Accepted Answer

A) use too large data steps. 
B) use incorrect addressing. 
C) forget to leave the first cell blank in the data column. 
D) forget to label the columns. 
E) modify the default settings. 
A) use too large data steps. 
B) use incorrect addressing. 
C) forget to leave the first cell blank in the data column. 
D) forget to label the columns. 
E) modify the default settings.

Question 12

In Excel,Goal Seek is found under which menu option?

Accepted Answer

A) Insert 
B) Edit 
C) File 
D) Tools 
E) Data 
A) Insert 
B) Edit 
C) File 
D) Tools 
E) Data

Question 13

More times than not,modelers tend to ignore making the model flexible because:

Accepted Answer

A) they don't know how. 
B) it takes too much time. 
C) it provides little benefit. 
D) they believe the model is a onetime use item. 
E) they want to keep the model modification control to themselves. 
A) they don't know how. 
B) it takes too much time. 
C) it provides little benefit. 
D) they believe the model is a onetime use item. 
E) they want to keep the model modification control to themselves.

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

In Excel,which function takes a range of values as its input and returns the smallest value from that range?

Accepted Answer

A) INF 
B) SMALL 
C) LITTLE 
D) MIN 
E) LOW 
A) INF 
B) SMALL 
C) LITTLE 
D) MIN 
E) LOW

Question 16

The MATCH function returns the ________________ position in the array that matches the lookup value.

Accepted Answer

The answer of The MATCH function returns the ________________ position...

Question 17

In Excel,___________________ references are indicated by a dollar sign character preceding the column and 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 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

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

If a model produces numerically correct values for the outputs for any legitimate values of inputs,it is said to be

When the "Formulas" box is checked under Tools/Options/View,what happens to the size of the columns?

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

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

You can edit Excel formulas by either double-click the cell,or _________________

Controllable inputs are sometimes called parameters.

Describe how a Data Table functions in Excel.

A road atlas represents which type of model?

Which of the following does not have a button for automatic insertion into the custom footer box?

One mistake Excel users make in forming the DATA TABLE is:

In Excel,Goal Seek is found under which menu option?

More times than not,modelers tend to ignore making the model flexible because:

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

In Excel,which function takes a range of values as its input and returns the smallest value from that range?

The MATCH function returns the ________________ position in the array that matches the lookup value.

In Excel,___________________ references are indicated by a dollar sign character preceding the column and the row reference.

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

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

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

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

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

If a model produces numerically correct values for the outputs for any legitimate values of inputs,it is said to be

When the "Formulas" box is checked under Tools/Options/View,what happens to the size of the columns?

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

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

You can edit Excel formulas by either double-click the cell,or _________________

Controllable inputs are sometimes called parameters.

Describe how a Data Table functions in Excel.

A road atlas represents which type of model?

Which of the following does not have a button for automatic insertion into the custom footer box?

One mistake Excel users make in forming the DATA TABLE is:

In Excel,Goal Seek is found under which menu option?

More times than not,modelers tend to ignore making the model flexible because:

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

In Excel,which function takes a range of values as its input and returns the smallest value from that range?

The MATCH function returns the ________________ position in the array that matches the lookup value.

In Excel,___________________ references are indicated by a dollar sign character preceding the column and the row reference.

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

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

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

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