Website Home Page |

Excel Assignments List

| Froyo Technologies Public Resources

| Month      | Sales A | Sales B | Sales C |

|------------|---------|---------|---------|

| April      | 1200    | 1100    | 900     |

| May        | 900     | 1000    | 800     |

| June       | 1300    | 950     | 1050    |

| July       | 1100    | 1200    | 850     |

| August     | 950     | 800     | 950     |

| September  | 1150    | 1050    | 1000    |

| October    | 1050    | 900     | 1100    |

| November   | 1000    | 1150    | 950     |

| December   | 1250    | 1000    | 1200    |

 
Task :

1. Calculate the total sales for each month using the SUM function.
2. Calculate the average sales across all three products for each month using the AVERAGE function.
3. Use COUNTIF function to count the number of months where Sales A exceeded 1000.
4. Use MAX function to find the highest sales value among all products for each month.
5. Create a line chart to visualize the trend of Sales A, Sales B, and Sales Cover the three months.

To perform the tasks outlined in Assignment  using Excel, follow these step-by-step instructions:

Steps to Perform:

1.      Calculate Total Sales for Each Month:

• Enter the sample data into Excel starting from cell A1.
• In cell E2 (next to "Sales C" column header), enter the formula =SUM(B2:D2) to calculate the total sales for January.
• Copy the formula across to calculate for February and March (E3 and E4).

2.      Calculate Average Sales Across All Products for Each Month:

• In cell F2 (next to "March" under "Month" column), enter the formula =AVERAGE(B2:D2) to calculate the average sales for January.
• Copy the formula across to calculate for February and March (F3 and F4).

3.      Count Months where Sales A Exceeded 1000:

• In a new cell (for example, G2), enter the formula =COUNTIF(B2:B4, ">1000").
• This counts the number of months where Sales A exceeded 1000.

4.      Find Highest Sales Value Among All Products for Each Month:

• In a new range (H2 to J2 for January, February, March respectively), enter the formula =MAX(B2:D2).
• This finds the highest sales value among all products for each month.

5.      Create a Line Chart to Visualize Sales Trend:

• Select the range of data including headers (A1).
• Go to Insert tab > Charts group > Choose Line Chart > Select a suitable style.