QUESTION 8

1. Ace Hardware Store collected data on the sales volume for five locations for the past four months. The data are input into an Excel spreadsheet where columns A through E represents the location names and column F represents the sales for each day for the past four months at that location. In order to construct a scatter diagram that displays the percent of total sales by location for each day for the past six months, the required steps in Excel will be to:
2. 1)Determine the total sales by location.
3. 2)Input the daily sales for each location
4. 3)Divide the daily sales for a particular location by the total sales for that location.
5. What would be the correct order of these steps?
6. 1. 2. 3.
7. 2. 1. 3.
8. 2. 3. 1.
9. 1. 3. 2.