Critical Thinking Questions Case 7-2 a Team of Coworkers from the Marketing

question 40

Multiple Choice

Critical Thinking Questions Case 7-2 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:

Ending Inventory

The total value of all the goods remaining unsold at the end of an accounting period.

Cost of Goods Sold

Costs directly connected with the manufacture of goods a company sells, including both materials and workforce expenses.

Beginning Inventory

The value of all the inventory held by a business at the start of an accounting period.

Net Sales

The amount of sales revenue left after deducting sales returns, allowances, and discounts.