Quiz 8

Question 1

Once a scenario is created the changing cells and comments cannot be edited.

Answer 1

False

Question 2

Contribution margins are used in _____.

Answer 2

break-even analysis

income projections

evaluating the profitability of sales

Question 3

A scenario describes different situations of _____ scenarios.

Answer 3

likely-case
best-case
worst-case

Question 4

A PivotTable is _____ allowing you to change the detailed view of the data.

Answer 4

interactive

Question 5

The output cells of the Scenario Manager are referred to as the _____ cells.

Answer 5

result

Question 6

Click the _____ button in the Scenario Manager to copy scenarios on one sheet to the active worksheet.

Answer 6

Merge

Question 7

The Scenario Manager refers to input cells as the _____ cells.

Answer 7

changing

Question 8

The input cells are the also referred to as the changing cells for creating scenarios.

Answer 8

True

Question 9

The SUMPRODUCT calculates the _____.

Answer 9

sum of a series of multiplication tasks

Question 10

_____ analysis is a type of what-if analysis that attempts to examine how sensitive the results are to changes in assumptions.

Answer 10

Sensitivity