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

Question

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

Quizplus · Accepted Answer

The average salary is a constant across all scenarios and does not need to be a changing cell since it remains the same for each scenario. Making it a changing cell would cause unnecessary inefficiency if the value needs to be updated again, as Gabriel would have to update each scenario individually.

Gabriel Created the Table Above to Help Him Organize Financial