Question 1

Once you run Goal Seek in Excel, you cannot revert back to the original values.

Accepted Answer

A) True 
 B)False

Question 2

Controllable inputs are sometimes called parameters.

Accepted Answer

A) True 
 B)False

Question 3

What is a primary reason why recommended footers contain the date and time?

Accepted Answer

The answer of What is a primary reason why recommended...

Question 4

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

Question 5

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

Accepted Answer

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

Question 6

The benefits of including a particular factor in a model must be weighed against the decreased complexity of the model resulting from its inclusion.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

In Excel, which function returns the square root?

Accepted Answer

A)  ROOT(number) 
B)  SQR(number) 
C)  SQRT(number) 
D)  SQUAREROOT(number) 
E)  ROOT2(number)

Question 9

The principle, "Do not hard-code an input directly into a formula," is the main feature of spreadsheet ________________.

Accepted Answer

A)  correctness 
B)  documentation 
C)  aesthetics 
D)  flexibility 
E)  randomness

Question 10

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

Accepted Answer

A)  absolute 
B)  comparative 
C)  analogous 
D)  relative 
E)  correlative

Question 11

In Excel, when moving a formula to another cell, it is better to use Copy and Paste rather than Cut and Paste.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  to speed solution time and to determine intermediate values 
B)  to speed solution time and to avoid errors 
C)  so the formula can fit on the formula line and to speed solution time 
D)  to avoid errors and to determine intermediate values 
E)  so the formula can fit on the formula line and to avoid errors

Question 13

In a spreadsheet, it is better to write a smaller number of more complex formulas than to write a larger number of simple formulas.

Accepted Answer

A) True 
 B)False

Question 14

In the Excel MATCH function, which "Match_type" forces the MATCH function to look for an exact match of Lookup_value in Lookup_array?

Accepted Answer

A)  10 
B)  0 
C)  -1 
D)  1 
E)  E

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

What are the most common useful numerical formats?

Accepted Answer

A)  date, currency, and percentage 
B)  date, time, and custom 
C)  time, custom, and number 
D)  number, custom, and percentage 
E)  number, currency, and percentage

Question 17

In Excel, what is the shortcut to view formulas on the spreadsheet?

Accepted Answer

A)  Ctrl+' 
B)  Ctrl+` 
C)  Ctrl+F 
D)  Ctrl+^ 
E)  Ctrl+~

Question 18

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

Question 19

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

Question 20

In Excel, to center a label that continues across several cells, highlight the cells, go to Format/Cell/Alignment, and click on _____________________.

Accepted Answer

A)  Center 
B)  Center across selection 
C)  Justify 
D)  Fill 
E)  General

Exam 17: Spreadsheet Modeling: An Introduction

Once you run Goal Seek in Excel, you cannot revert back to the original values.

Controllable inputs are sometimes called parameters.

What is a primary reason why recommended footers contain the date and time?

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

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

The benefits of including a particular factor in a model must be weighed against the decreased complexity of the model resulting from its inclusion.

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

In Excel, which function returns the square root?

The principle, "Do not hard-code an input directly into a formula," is the main feature of spreadsheet ________________.

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

In Excel, when moving a formula to another cell, it is better to use Copy and Paste rather than Cut and Paste.

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

In a spreadsheet, it is better to write a smaller number of more complex formulas than to write a larger number of simple formulas.

In the Excel MATCH function, which "Match_type" forces the MATCH function to look for an exact match of Lookup_value in Lookup_array?

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

What are the most common useful numerical formats?

In Excel, what is the shortcut to view formulas on the spreadsheet?

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?

In Excel, to center a label that continues across several cells, highlight the cells, go to Format/Cell/Alignment, and click on _____________________.