1. Identify the sales data for each month from January to May.
2. For each month, calculate the total sales achieved by summing the "Sales Achieved" column.
3. For each month, calculate the average sales achieved by dividing the total sales by the number of entries.
4. For each month, determine the highest and lowest sales achieved values.
5. Compile the results for each month into a summary table.
January:
- Total Sales: 500000 + 100000 + 200000 + 440989 + 365100 + 210989 + 100000 + 50000 + 320000 + 143200 + 602300 = 3,032,578
- Average Sales: 3,032,578 / 11 = 275,689
- Highest Sales: 602,300 (Avijit)
- Lowest Sales: 50,000 (Sachin)
February:
- Total Sales: 105000 + 305000 + 250000 + 540989 + 475100 + 110900 + 305000 + 500000 + 421000 + 343200 + 505500 = 3,856,689
- Average Sales: 3,856,689 / 11 = 350,608
- Highest Sales: 540,989 (Parul)
- Lowest Sales: 105,000 (Sheena)
March:
- Total Sales: 400000 + 100000 + 324500 + 421000 + 367810 + 568900 + 100000 + 67890 + 219000 + 259000 + 549800 = 3,058,010
- Average Sales: 3,058,010 / 11 = 278,001
- Highest Sales: 568,900 (Aniket)
- Lowest Sales: 67,890 (Sachin)
April:
- Total Sales: 100000 + 200000 + 345679 + 437890 + 234567 + 109879 + 500000 + 320000 + 560000 + 219000 + 560000 = 3,147,006
- Average Sales: 3,147,006 / 11 = 286,091
- Highest Sales: 560,000 (Megha and Avijit)
- Lowest Sales: 100,000 (Sheena)
May:
- Total Sales: 320000 + 432190 + 456789 + 503943 + 357739 + 609739 + 327890 + 43257 + 627890 + 135200 + 327680 = 4,193,458
- Average Sales: 4,193,458 / 11 = 381,223
- Highest Sales: 627,890 (Megha)
- Lowest Sales: 43,257 (Sachin)
Summary Table:
| Month | Total Sales | Average Sales | Highest Sales | Lowest Sales |
|-------|-------------|---------------|---------------|--------------|
| Jan | 3,032,578 | 275,689 | 602,300 | 50,000 |
| Feb | 3,856,689 | 350,608 | 540,989 | 105,000 |
| Mar | 3,058,010 | 278,001 | 568,900 | 67,890 |
| Apr | 3,147,006 | 286,091 | 560,000 | 100,000 |
| May | 4,193,458 | 381,223 | 627,890 | 43,257 |
Parent Tip: Review the logic above to help your child master the concept of merging worksheet in excel.