Question 1

(TCO 6) Which of the following tools has the ability to generate a report?

• Solver

• Goal Seek

• Scenario manager

• Two-variable data table

Question 2

(TCO 6) Which of the following tools has the ability to manipulate constraints?

• Goal Seek

• Solver

• Scenario Manager

• One-variable Data Table

Question 3

(TCO 6) Which of the following tools is best suited for comparing the effects of two variables on a formula?

• Solver

• Goal Seek

• Two-variable data table

• One-variable data table

Question 4

(TCO 6) A series of _____ indicates that the width of a column is too narrow to display the complete number.

• asterisks (*)

• pound signs (#)

• carets (^)

• ampersands (&)

Question 5

(TCO 6) Which of the following tools is best suited for comparing the effects of one set of substitution values on a formula?

• Goal Seek

• Solver

• Scenario Manager

• One-variable data table

Question 6

(TCO 6) ) In the Goal Seek dialog box, the cell reference of the desired value is entered in the _____ box.

• to value

• by changing cell

• set cell

• column input cell

Question 7

(TCO 6) Where is Scenario Manager located in Excel?

• Formula tab

• Backstage

• Data tab

• View tab

Question 8

(TCO 6) When using Solver, the _____ cell contains the formula used to optimize the results.

• objective

• pivotal

• changing

• optimizing

Question 9

(TCO 6) Which is the best tool for determining the optimal blend of products to produce in order to maximize profit?

• Goal Seek

• Scenario Manager

• Solver

• Two-variable data table

Question 10

(TCO 6) _____ are restrictions or limitations imposed on Solver as it determines the optimum value.

• Bounds

• Constraints

• Restraints

• Controls

Question 11

(TCO 6) This analysis tool has the ability to handle multiple adjustable cells while minimizing, maximizing, or meeting goals.

• Goal Seek

• Scenario Manager

• Solver

• Two-variable data table

Question 12

(TCO 6) Which What-If Analysis tool is best to determine the optimal amount of shoes to produce in order to maximize profit and use 100% of materials?

• Goal Seek

• Solver

• Scenario Manager

• Two-variable data table

Question 13

(TCO 6) Comments can be added to Scenarios in which tab or dialog box?

• Goal Seek dialog box

• Home tab

• View tab

• Scenario Manager dialog box

Question 14

(TCO 6) Where should the formula or formula reference be located in a two-variable date table?

• Lower right corner

• Upper right corner

• Top left corner

• Lower left corner

Question 15

(TCO 6) Which of the following calculations on the target cell is not supported by Solver?

• Maximize

• Range

• Minimize

• Exact value