Multiple Choice
Gabriel created the table above to help him organize financial information on the projected results of increased marketing campaigns for the swimsuit line. A change in marketing expense will change the number of units sold. Please refer to the table above when answering the questions below.
-Gabriel considers whether the average salary input item should be a changing cell. Although the average salary will change to $39,100 next year, it will not vary from that number for any of the five scenario options. Why would you recommend NOT making salary a changing cell?
A) because Gabriel would have to update each of the five scenarios if the value changes again, causing inefficiency
B) because the value is a "constant" across all five scenarios
C) both a and b
D) neither a nor b
Correct Answer:

Verified
Correct Answer:
Verified
Q46: To open the Data Table dialog box,
Q47: The Scenario Manager refers to output cells
Q48: All defined names have a(n) _, which
Q49: Data tables can be used to give
Q50: To set up a scenario, you create
Q52: You use the _ to define and
Q53: At its most basic level, what-now analysis
Q54: To create a two-variable data table, you
Q55: _ results are those that are based
Q56: Identify the letter of the choice that