| Excel Assignment # 1 | ||||||
| Below is a table of data that you will use. You need to enter this data into EXCEL. | ||||||
| All cells in yellow must be filled in with values or formulas. | ||||||
submit this via e-mail |
||||||
| Sales by Person | ||||||
| Jan | Feb | March | Total Sales | Average Sales | ||
| John | $ 4,500.00 | $3,400.00 | $2,900.00 | |||
| Fred | $ 3,400.00 | $4,600.00 | $4,000.00 | $ 4,000.00 | ||
| Sue | $ 2,900.00 | $5,600.00 | $4,900.00 | |||
| Bob | $ 4,500.00 | $6,000.00 | $5,200.00 | |||
| Total | $15,300.00 | |||||