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

Question

Quizplus · Accepted Answer

Using a SmartArt graphic is the best choice as it allows for a clear illustration of the relationship between production costs and sales prices, making it easier for the user to understand the impact of changes in production costs on product sales prices. A pie chart may not be the best option as it only compares two data points, while a SmartArt graphic allows for a more detailed illustration of the data. Using Find and Replace commands or importing data from a text file would not visually enhance the workbook in the desired way.

A Team of Coworkers from the Marketing Department Are Holding