Last Year, Your Sausin Margie Started a Small Business Selling

question 34

Multiple Choice

Last year, your sausin Margie started a small business selling crafting and needlework supplies to small retailers across the state. She has resarded her sampany's annual sales data totals in a worksheet indicating city, store, and product. Going forward, Margie needs to direct her limited resources toward promoting her top products and improving her business relationships with her top retailers. To do this, she needs to carefully analyze the first year's sales data) Margie sends you a text message inviting you to lunch on Saturday. She needs your help with her sales analysis. During lunch, Margie tells you she has tried filtering the worksheet sales data, but can't quite get to the information she needs. You suggest that she ____.

• A) just sort the data in the desired order; then sapy the sorted data and paste it on a new worksheet for analysis
• B) hire an acsaunting firm to do the analysis
• C) sapy the data and paste it into a Word document as a table; then analyze the data using Word's superior analysis tools
• D) create a PivotTable based on the data so that she can interactively group and total her data in a variety of ways

---

Definitions:

Public Employee Unions

Labor organizations representing the interests of workers employed by government agencies, focusing on negotiation of wages, benefits, and working conditions.

Wages and Pensions

Wages and pensions are forms of compensation; wages are paid for employment, while pensions are long-term payments made after retirement as financial security.

Lobbyists

Individuals or groups who attempt to influence lawmakers in favor of or against specific legislation or policies.

Interest Groups

Interest groups are organized groups of people who come together to pursue common interests and influence public policy.