Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

Goal Seek can be defined as:
A)a mathematical process that changes the value of several decision variables to find the best object function.
B)working backward from a desired result to compute an unknown value that produces the desired result.
C)the money a company receives during a given period.
D)the combination of variables used in performing a what-if analysis.
2

Protecting a worksheet means:
A)no cell in a worksheet can be changed.
B)saving the workbook in a hidden folder.
C)no additional changes can be made to a worksheet.
D)to lock cells in the worksheet so that a user cannot inadvertently change them.
3

In a Goal Seek problem, you need to specify all of the following except:
A)a set cell that contains a formula.
B)a value to be reached.
C)a scenario name.
D)a changing cell that contains an initial value.
4

In Excel, Goal Seek can be accomplished by any of the following automated processes except:
A)the Goal Seek command.
B)a two-variable data table.
C)Graphic Goal Seek.
D)Excel Solver.
5

The Excel Solver is a what-if analysis tool that:
A)is an add-in product that is not automatically installed into Excel.
B)depends on the use of scenarios.
C)was developed by Microsoft.
D)is generally used for simple analysis problems.
6

Constraints used in Excel:
A)should be defined for the upper limits of a resource but not the lower limit.
B)are the same as changing cells.
C)are generally unnecessary.
D)are defined limitations on resources and other factors that allow Solver to find a feasible solution.
7

An integer constraint:
A)allows fractional numbers in a target cell or a changing cell.
B)does not affect the solution.
C)prevents negative numbers.
D)provides an easy reference to a function.
8

In a Solver solution, slack is associated with:
A)non-binding cells.
B)binding cells.
C)target cells.
D)the objective function.
9

Multiple optimal solutions:
A)are the same as infeasible solutions.
B)can be easily detected.
C)are impossible when using Solver.
D)might occur if there are insufficient constraints in the problem definition.
10

Solver allows the user to do all of the following except:
A)create an Answers report when the solution is feasible.
B)save and reload the solution model.
C)create a Limits report when integer constraints are defined.
D)create a scenario showing the solution results.
11

Goal Seek is the process of finding the point where costs equal revenue.
A)True
B)False
12

A precedent value is the value on which a formula or result is directly or indirectly based.
A)True
B)False
13

Excel allows you to do Goal Seek through the use of a graph.
A)True
B)False
14

Goal Seek is the best method for doing a resource allocation problem.
A)True
B)False
15

When developing a Solver problem, you need to be concerned about the constraints you need.
A)True
B)False
16

The objective function is the variable that you are trying to maximize, to minimize, or to set equal to a particular value.
A)True
B)False
17

Solver problems are limited to a single changing cell.
A)True
B)False
18

Changing cells that contain slack are classified as binding.
A)True
B)False
19

A constraint is a limitation on the value that a cell can have.
A)True
B)False
20

The Goal Seek command works forward from a single-valued solution to produce a final, optimized result.
A)True
B)False





To learn more about the book this website supports, please visit its Information Center.
(c)2004 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


haagoffice2eOnline Learning Center

Home > Excel > Chapter 10 > Multiple Choice Quiz