The Carter Department Store Has Data on the Sales Volume

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 that 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.