Exam 10: Data Tables, scenario Manager, and Solver

A two-variable data table returns ________ result(s)for each combination of two variables.

The scroll bar is a type of ________ tool because of the ability to calculate numerous outputs in other cells by referencing the target cell in formulas and functions.

The initial results of Goal Seek are automatically entered into a new worksheet.

A ________ analysis studies the relationship between fixed and variable costs,sales volume,and profits.

Goal seek is a form control that allows you to change a number in a target cell location in single-unit increments.

Changing a binding constraint also changes the optimal solution.

A ________ is a type of scenario tool that allows you to change a number in a target cell location in single-unit increments.

All of the following solving methods are available within the Solver Parameters dialog box EXCEPT ________.

The ________ is the default method that Excel's Solver uses.

What information is displayed in the first section of a Solver report?

________ makes the data easier to read and understand because it adds a visual or graphical element to the cells or values.

Which of the following is NOT one of the three cost types to consider when calculating the break-even point?

The three parameters available in Solver are objective cell,variable cell,and ________.

To view scenarios,click the ________ button in the Scenario Manager dialog box.

If you delete a scenario and change your mind,you can use the Undo button to undo your deletion.

When the golf course is open for business,they have to pay management salaries,insurance,depreciation of building and equipment,and so on,regardless of how many customers they have during the day.These are examples of variable costs.

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

Of the three What-If Analysis tools available on the Data tab,the ________ can compare more than two variables.

The Solver ________ Report displays various statistical characteristics about the given model,such as how many variables and rows it contains.