The Carter Department Store Has Data on the Sales Volume

question 43

Multiple Choice

The Carter Department Store has data on the sales volume by department for the past 200 days.The data are in an Excel spreadsheet where column A represents the department name and column B represents the sales for each day in that department.In order to construct a bar chart that illustrates the difference in total sales by department for the 200 days,a required step in Excel will be to:

• A)determine the total sales by department.
• B)use the frequency function to count the number of occurrences by department.
• C)group the data into 5 to 20 classes.
• D)determine the class widths.

---

Definitions:

Capital Spending

Expenditures by businesses to acquire or upgrade physical assets such as property, industrial buildings, or equipment to increase their capacity or efficiency.

Incorporating

The process of legally declaring a business as a corporation, providing it with specific legal rights and protections.

Limited Liability

A legal structure that limits the personal financial responsibility of shareholders, partners, or owners for company debts and obligations.

Common Stock

Equity ownership in a corporation, with voting rights and the potential to receive dividends.