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:

1) Determine the total sales by location. 2) Input the daily sales for each location 3) Divide the daily sales for a particular location by the total sales for that location.

What would be the correct order of these steps?

		1. 2. 3.
		2. 1. 3.
		2. 3. 1.
		1. 3. 2.