When You Change a Value on Which a Chart Is

question 11

Multiple Choice

When you change a value on which a chart is dependent, Excel ____.

• A)does not do anything until you save the change
• B)immediately redraws the chart based on the new value
• C)gives an error message
• D)prompts you to save the change

---

Definitions:

Constant Sales Mix

An assumption in cost-volume-profit analysis that the sales mix will remain unchanged as sales levels vary.

Assumption

A basic premise or belief that is accepted as true without proof as the basis for argument or inference.

Multiproduct Company

A business entity that manufactures or sells more than one type of product, often across different product lines or industries.

Sales Volumes

The total quantity of a product or service sold by a company during a specific period.