When working with Scenario Manager, in order to preserve the original information, it's best to$.....$

Question $1$ options:

Create a base case scenario first to allow you to reset to the original values

Save the workbook so you can toss it away and restore the original values

Write down the original values somewhere so you can refer to them later

Set up a Goal Seek to find out the original values needed

Question $2(1$ point$)$

Suppose the formula $=$ D$7+$F$8/$G$8-$H$5+2$ is in cell D$10.$ Which is the best method to work out the value required in F$8$ to get a value of $850$ from the formula?

Question $2$ options:

Use the Scenario Manager to place $850$ in cell F$8$

Use Goal Seek to set D$10$ to $850$ by changing F$8$

Use Goal Seek to set F$8$ to $850$ by changing D$10$

Use the Scenario Manager to place $850$ in D$10$

Question $3(1$ point$)$

Saved

Maria needs to present to her supervisor a range of outputs $($outcomes$)$ that can be achieved if she varies the production line speed. Which function will you recommend to her?

Question $3$ options:

$2-$Variable Data Table

$1-$Variable Data Table

Solver

Goal Seek

Question $4(1$ point$)$

Saved

Maria needs to find out the best combination of machines to run given a set of constrains to maximize her product output over the weekend shifts. Which Excel function will you recommend to her?

Question $4$ options:

Solver

Scenario Manager

Goal Seek

$2$ Input Data Table

Question $5(1$ point$)$

Saved

Goal Seek and Solver perform similar functions. Which of the following statements is true AND describes the difference between Goal Seek and Solver.

Question $5$ options:

Only Goal Seek solves an equation by changing input values to get an set output.

Only Solver can solve for a specific output value where the input value is variable.

Only Goal Seek needs to be activated as a plug$-$in before it can be used.

Only Solver can optimize an equation to get a max or min value.

Question $6(1$ point$)$

You are modelling your production environment so that you can use solver to determine the maximum possible output for the next week. The speed that you decide to operate the main machine at would be a:

Question $6$ options:

Constraint

Objective Function

Decision Variable

Solving Method