Question 1

In Excel, the command to print formulas is checked under which menu/submenu?

Accepted Answer

A) Print 
B) Page Setup 
C) Tools 
D) Edit 
E) Insert 
A) Print 
B) Page Setup 
C) Tools 
D) Edit 
E) Insert C

Question 2

In Excel, what are the three arguments that an INDEX 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 D

Question 3

In the custom footer box, which of the following is the command to insert the worksheet name?

Accepted Answer

A) &[worksheet] 
B) &[tab] 
C) &[work] 
D) &[sheet] 
E) &[page] 
A) &[worksheet] 
B) &[tab] 
C) &[work] 
D) &[sheet] 
E) &[page] B

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

In general, when using large dollar amounts, always use the cents, but small dollar amounts can be rounded off to whole numbers.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) SUP 
B) LARGE 
C) BIG 
D) HIGH 
E) MAX 
A) SUP 
B) LARGE 
C) BIG 
D) HIGH 
E) MAX

Question 7

What is the advantage of using a Stacked Column chart?

Accepted Answer

The contribution of

Question 8

For the Goal Seek feature in Excel, it doesn't matter whether you use absolute or relative references.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Models can also be described as:

Accepted Answer

A) an abstraction of the real situation 
B) an accurate representation of the real situation 
C) the decision 
D) absolute representation of reality 
E) a general view of reality 
A) an abstraction of the real situation 
B) an accurate representation of the real situation 
C) the decision 
D) absolute representation of reality 
E) a general view of reality

Question 11

In Excel, what does the formula "=MAX(B25:D25)" do?

Accepted Answer

A) It returns the largest value in either cell B25 or cell D25. 
B) It converts all values in the range between B25 and D25 to the highest value in that range. 
C) Whichever of B25 or D25 is lowest, it converts that value to the other one. 
D) It returns the largest value among cells B25, C25, and D25. 
E) It maximizes the formulas in each of the cells in the range between B25 and D25. 
A) It returns the largest value in either cell B25 or cell D25. 
B) It converts all values in the range between B25 and D25 to the highest value in that range. 
C) Whichever of B25 or D25 is lowest, it converts that value to the other one. 
D) It returns the largest value among cells B25, C25, and D25. 
E) It maximizes the formulas in each of the cells in the range between B25 and D25.

Question 12

Excel's COUNT function returns the ______ of cells containing numerical values.

Accepted Answer

The answer of Excel's COUNT function returns the ______ of...

Question 13

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 14

__________ and ___________ cell referencing allows you to write one formula and then copy it.

Accepted Answer

The answer of __________ and ___________ cell referencing allows you...

Question 15

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

Accepted Answer

For an XY graph, the X (horizo

Question 16

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 17

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

Question 18

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

Accepted Answer

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

Question 19

The key to spreadsheet model flexibility is to keep all the ___________ of the model separate from the ______________ of the model.

Accepted Answer

A) inputs; formulas 
B) inputs; outputs 
C) outputs; formulas 
D) constraints; formulas 
E) parameters; decision variables 
A) inputs; formulas 
B) inputs; outputs 
C) outputs; formulas 
D) constraints; formulas 
E) parameters; decision variables

Question 20

In Excel, absolute references do not change when you copy them.

Accepted Answer

A) True 
 B)False

In Excel, the command to print formulas is checked under which menu/submenu?

In Excel, what are the three arguments that an INDEX function takes?

In the custom footer box, which of the following is the command to insert the worksheet name?

Research has shown that most spreadsheet developers believe their products:

In general, when using large dollar amounts, always use the cents, but small dollar amounts can be rounded off to whole numbers.

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

What is the advantage of using a Stacked Column chart?

For the Goal Seek feature in Excel, it doesn't matter whether you use absolute or relative references.

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

Models can also be described as:

In Excel, what does the formula "=MAX(B25:D25)" do?

Excel's COUNT function returns the ______ of cells containing numerical values.

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

and _ cell referencing allows you to write one formula and then copy it.

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

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

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

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

The key to spreadsheet model flexibility is to keep all the _ of the model separate from the ____ of the model.

In Excel, absolute references do not change when you copy them.

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, the command to print formulas is checked under which menu/submenu?

In Excel, what are the three arguments that an INDEX function takes?

In the custom footer box, which of the following is the command to insert the worksheet name?

Research has shown that most spreadsheet developers believe their products:

In general, when using large dollar amounts, always use the cents, but small dollar amounts can be rounded off to whole numbers.

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

What is the advantage of using a Stacked Column chart?

For the Goal Seek feature in Excel, it doesn't matter whether you use absolute or relative references.

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

Models can also be described as:

In Excel, what does the formula "=MAX(B25:D25)" do?

Excel's COUNT function returns the ______ of cells containing numerical values.

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

__________ and ___________ cell referencing allows you to write one formula and then copy it.

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

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

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

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

The key to spreadsheet model flexibility is to keep all the ___________ of the model separate from the ______________ of the model.

In Excel, absolute references do not change when you copy them.

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

and _ cell referencing allows you to write one formula and then copy it.

The key to spreadsheet model flexibility is to keep all the _ of the model separate from the ____ of the model.