Website Home Page |

Excel Assignments List

| Froyo Technologies Public Resources

| Item       | Cost   | Revenue | Profit |

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

| Product D  | 550    | 820     |        |

| Product E  | 630    | 950     |        |

| Product F  | 720    | 1050    |        |

| Product G  | 680    | 980     |        |

| Product H  | 590    | 870     |        |

| Product I  | 660    | 930     |        |

| Product J  | 710    | 1020    |        |

| Product K  | 590    | 880     |        |

| Product L  | 640    | 940     |        |

| Product M  | 600    | 910     |        |

 
Task :

1. Calculate the profit for each product using a formula (Revenue - Cost).
2. Calculate the total cost and total revenue using the SUM function.
3. Use IF function to categorize each product as "Profitable" if Profit > 0, otherwise "Not Profitable".
4. Create a pie chart to represent the percentage distribution of Profitable and Not Profitable products.
5. Format the financial statement with currency and percentage formats.

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

Steps to Perform:

1.      Calculate Profit for Each Product:

• Enter the sample data into Excel starting from cell A1.
• In cell D2 (next to "Profit" column header), enter the formula =C2-B2 to calculate the profit for Product A.
• Copy the formula down to calculate for Product B and Product C (D3 and D4).

2.      Calculate Total Cost and Total Revenue:

• In cell B5 (below "Cost"), enter the formula =SUM(B2:B4) to calculate the total cost.
• In cell C5 (below "Revenue"), enter the formula =SUM(C2:C4) to calculate the total revenue.

3.      Categorize Products as Profitable or Not Profitable:

• In cell E2 (next to "Profit" column), enter the formula =IF(D2>0, "Profitable", "Not Profitable").
• Copy the formula down to apply to Product B and Product C (E3 and E4).

4.      Create a Pie Chart for Profitable vs. Not Profitable Products:

• Select cells containing the counts of "Profitable" and "Not Profitable" (E2).
• Go to Insert tab > Charts group > Choose Pie Chart > Select a suitable style.

5.      Format Financial Statement:

• Select the range of numbers (B2).
• Go to Home tab > Number group > Apply Currency format to Cost, Revenue, and Profit columns.
• For percentages, you can format the Profit column as Percentage.