Quiz 2

Question 1

By default, the cover add - in is active.

Answer 1

false

Question 2

Goal seek is an excel add - in

Answer 2

False

Question 3

Scenario manager can be set to maximize the objective cell

Answer 3

False

Question 4

Solver can be set to maximize the objective cell

Answer 4

True

Question 5

Goal seek can be set to minimize the objective cell

Answer 5

False

Question 6

Scenario summary reports update when input cells are changed

Answer 6

False

Question 7

Solver constraints can be et to restrict values to integers

Answer 7

True

Question 8

If not specified by the user, Solver optimization models can produce negative results

Answer 8

True

Question 9

Solver models can be saved and restored

Answer 9

True

Question 10

Deleted solver constraints can be restored

Answer 10

False

Question 11

Multiple objective cells can be used with Goal seek

Answer 11

False

Question 12

Multiple objective cells can be used with scenario manager

Answer 12

False

Question 13

A two variable data table allows two variables but only one result

Answer 13

True

Question 14

In order to complete a two variable table, a formula or reference to a formula must be entered in the top - left corner

Answer 14

True

Question 15

A substitution value replaces the original input value of variable in a data table

Answer 15

True

Question 16

Substitution values can be manually entered

Answer 16

True

Question 17

When creating one - variable data table, one or more formulas that relate to the variable must be used

Answer 17

True

Question 18

When creating a one - variable data table with substitution values in a vertical column, the formula reference must be on the row below and one column to the left of the first substitution value

Answer 18

False

Question 19

two reference formulas re required to complete a two - variable data table

Answer 19

False

Question 20

When using the scenario manager, scenarios can be edited

Answer 20

True

Question 21

which what if analysis tool is best suited to determine the exact interest rate required for 600 dollar car payment repaid over five years

Answer 21

not solver, not two variable table

Question 22

Which of the following tools has the ability to generate a report?

Answer 22

Scenario manager

Question 23

Which of the following tools is an add - in

Answer 23

solver

Question 24

25 out of 46

Answer 24

Not two variable data table

Question 25

When creating a one - variable data table that depicts the effects of different interest rates on a car payment, the interest rates is an example of which of the following?

Answer 25

Variable

Question 26

Which of the following tools is best suited for comparing the effects of two - variables on a formula

Answer 26

Two - variable data table

Question 27

Which of the following tools is best suited for comparing the effects of one set of substitution values on a formula

Answer 27

Not scenario manager

Question 28

When creating substitution values using the series dialog box, what is the last number used in the substitution values

Answer 28

stop value

Question 29

in order to complete a two - variable data table, which of the following must be included in the table

Answer 29

formula

Question 30

What is the best tool to determine the required downpayment to reach a 700 dollar car payment

Answer 30

goal seek

Question 31

Which what if analysis tool is best used for creating optimization models

Answer 31

Solver

Question 32

33 out of 46

Answer 32

Not two variable data table, not goal seek

Question 33

34 out of 46

Answer 33

Not scenario manager, not goal seek

Question 34

Which what if analysis tool is the best tool for evaluating various scenarios based on variables within a formula

Answer 34

scenario manager

Question 35

36 out of 46

Answer 35

not one variable data table, not solver

Question 36

37 out of 46

Answer 36

not goal seek, not scenario manager

Question 37

38 out of 46

Answer 37

not Scenario manager, not goal seek

Question 38

which what if analysis tool is best to determine the number of t - shirts to sell in order to earn 500 dollars with no constraints

Answer 38

goal seek

Question 39

40 out of 46

Answer 39

Not two data variable data table, not solver

Question 40

Where should the formula or formula reference be located in two - variable data table?

Answer 40

Top left corner

Question 41

if doug would like to determine how many hot dogs to sell at a profit margin of 10 dollars to raise 250 dollars without constraints which what if analysis tool should he use?

Answer 41

goal seek

Question 42

which what if analysis tool is best suited to calculate the impact of interest rate changes based on different economic climates

Answer 42

Scenario manager

Question 43

which of the following calculations on the target cell is not supported by solver

Answer 43

Range

Question 44

which of the following options is required to complete a solver model

Answer 44

objective cell

Question 45

46 out of 46

Answer 45

not one variable data table, not goal seek