A Team of Coworkers from the Marketing Department Are Holding

question 83

Multiple Choice

A team of coworkers from the marketing department are holding a brainstorming session on ways to add more visual interest to a sales data workbook and, at the same time, improve user understanding of the data and calculations included in the workbook. They invite you to be part of the discussion.
-Liz says she wants to find a way to illustrate how changes in production costs affect sales prices.You suggest that she consider ____.

• A) inserting an embedded pie chart comparing production costs and sales prices
• B) using the Find and Replace commands to apply formatting to the sales prices being illustrated
• C) using a SmartArt graphic to illustrate the relationship between increases in production costs and product sales prices
• D) importing the production costs data from a text file into a new worksheet

---

Definitions:

Range

The difference between the highest and lowest values in a set of numbers.

Normal Model

A probability distribution that is symmetrical about its average, indicating that occurrences close to the mean are more common than those further away.

Central 68%

Central 68% is a statistical term that refers to the percentage of data within one standard deviation of the mean in a normal distribution, implying that about 68% of the data fall within this range.

Standard Deviation

A measure of the amount of variation or dispersion in a set of values, indicating how much the values differ from the mean.