Question 1

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 2

Uncontrollable inputs are also called _______________________.

Accepted Answer

A)  decision variables 
B)  parameters 
C)  unregulated inputs 
D)  unregulated variables 
E)  recessive variables 
A)  decision variables 
B)  parameters 
C)  unregulated inputs 
D)  unregulated variables 
E)  recessive variables

Question 3

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

Question 4

Although there are a number of different model types, _________ exist among them.

Accepted Answer

The answer of Although there are a number of different...

Question 5

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 6

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

Question 7

In Excel, the only way to center a label that continues across multiple cells is to edit the cell and use the space key.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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]

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

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 13

Describe and discuss the two different types of model inputs.

Accepted Answer

Inputs are quantities or factors that af

Question 14

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 15

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 16

Ideally, a spreadsheet model should be ________________________

Accepted Answer

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

Question 17

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 18

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 19

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

Accepted Answer

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

Question 20

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.

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

Uncontrollable inputs are also called _______________________.

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

Although there are a number of different model types, _________ exist among them.

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

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

In Excel, the only way to center a label that continues across multiple cells is to edit the cell and use the space key.

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

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

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

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

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

Describe and discuss the two different types of model inputs.

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

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

Ideally, a spreadsheet model should be ________________________

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

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

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

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

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

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

Uncontrollable inputs are also called _______________________.

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

Although there are a number of different model types, _________ exist among them.

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

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

In Excel, the only way to center a label that continues across multiple cells is to edit the cell and use the space key.

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

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

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

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

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

Describe and discuss the two different types of model inputs.

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

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

Ideally, a spreadsheet model should be ________________________

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

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

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

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

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