Quiz 2 Flashcards

1
Q

By default, the cover add - in is active.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Goal seek is an excel add - in

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Scenario manager can be set to maximize the objective cell

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Solver can be set to maximize the objective cell

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Goal seek can be set to minimize the objective cell

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Scenario summary reports update when input cells are changed

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Solver constraints can be et to restrict values to integers

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Solver models can be saved and restored

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Deleted solver constraints can be restored

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Multiple objective cells can be used with Goal seek

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Multiple objective cells can be used with scenario manager

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Substitution values can be manually entered

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

False

20
Q

When using the scenario manager, scenarios can be edited

A

True

21
Q

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

A

not solver, not two variable table

22
Q

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

A

Scenario manager

23
Q

Which of the following tools is an add - in

A

solver

24
Q

25 out of 46

A

Not two variable data table

25
Q

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?

A

Variable

26
Q

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

A

Two - variable data table

27
Q

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

A

Not scenario manager

28
Q

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

A

stop value

29
Q

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

A

formula

30
Q

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

A

goal seek

31
Q

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

A

Solver

32
Q

33 out of 46

A

Not two variable data table, not goal seek

33
Q

34 out of 46

A

Not scenario manager, not goal seek

34
Q

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

A

scenario manager

35
Q

36 out of 46

A

not one variable data table, not solver

36
Q

37 out of 46

A

not goal seek, not scenario manager

37
Q

38 out of 46

A

not Scenario manager, not goal seek

38
Q

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

A

goal seek

39
Q

40 out of 46

A

Not two data variable data table, not solver

40
Q

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

A

Top left corner

41
Q

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?

A

goal seek

42
Q

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

A

Scenario manager

43
Q

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

A

Range

44
Q

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

A

objective cell

45
Q

46 out of 46

A

not one variable data table, not goal seek