Excel Chapter 6 End-of-Chapter Quiz – Flashcards

How do you know if Solver is already loaded on your computer?

a) The Solver command displays on the Add-Ins tab and in the Inactive Application Add-ins list in the Excel Options dialog box.
b) The Solver command displays on the Data tab and in the Active Application Add-ins list in the Excel Options dialog box.
c) The Solver command displays on the Data tab and in the Active Application Add-ins list in the Excel Options dialog box.
d) The solver command displays on the Data Tools tab and in the Scenario Manager dialog box.

A one-variable data table enables you to identify ___ variable(s) and ___ results(s).

a) one, unlimited
b) two, one
c) one, two
d) one, one

You want to display tip amounts using multiple combinations of customer totals and tip percentages. what what-if analysis should you use?

a) solver
b) goal seek
c) two-variable data table
d) one-variable data table

Which dialog box enables you to specify the result cells for a scenario summary report?

a) scenario values
b) scenario summary
c) add scenario
d) solver options

Which two tools have the ability to change actual values in the original dataset?

a) goal seek and scenario manager
b) goal seek and solver
c) solver and data tables
d) data tables and scenario manager

After you generate a Scenario Summary report, you should delete all of the following except:

a) the cell references column
b) row 1
c) column A
d) the changing cells section

In the Solver Parameters dialog box, the ____ cell must always contain a formula.

a) result
b) changing variable
c) objective
d) constraint

Which statement is not correct about a two-variable data table?

a) the top-left corner must contain the formula for the result
b) the data table can produce two types of results for the combination of two variables
c) you must specify the row input cell and the column input cell from the original dataset
d) to avoid showing a formula result that builds the table, you can apply a custom number format to the cell to make it appear as a label

When using the Goal Seek command, how many input variables can you change at a time?

a) 1
b) 3
c) all of them, if necessary
d) 2

Before creating a scenario with Scenario Manager, it is important to know which cells contain the variables you want changed and the:

a) formatting of the results
b) cells containing the formulas that generate the results
c) the final result
d) the scenario names

Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?

a) one-variable data table
b) goal seek
c) scenario manager
d) two-variable data table

Goal Seek works backwards to identify an exact value for a variable that achieves a specific goal.

a) true
b) false

A two-variable data table return ____ return(s) for each combination of two variables.

a) four
b) one
c) three
d) two

Which of the following is NOT required for Solver to generate a solution?

a) variables that change within the specified limitations
b) a formula that produces a value to optimized
c) precedent values
d) constraints

Once a constraint has been set in the Solver Parameters dialog box it cannot be changed.

a) true
b) false

Each scenario generated with Scenario Manager is stored under its own name.

a) true
b) false

What-if analysis tools provide definitive solutions to problems.

a) true
b) false

What is the main difference between Goal Seek and variable data tables?

a) goal seek manipulates multiple values to produce multiple results
b) goal seek produces a list of result values
c) goal seek uses the original worksheet data to change an input
d) goal seek shows results in a separate table

The value you want to achieve in Goal Seek needs to be entered in the _____ box in the Goal Seek dialog box.

a) to value
b) goal
c) set cell
d) by changing cell

Which of the following is NOT one of the major sections of a Solver report?

a) objective cell
b) constraints
c) original value
d) variables cells

Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?

a) Goal Seek
b) Solver
c) Data Table
d) Scenario Manager

Which of the following is NOT one of the three parameters in Solver?

a) changing variable cells
b) input value
c) constraints
d) objective cell

Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only $350 a month?

a) goal seek
b) scenario manager
c) data table
d) solver