Computer Operator Pracitcal Excel Question; How to calculate amount and create a pie chart of Items?

Question: Enter following data in Sheet 1 and perform as asked. (10)

S.N.	Name	Quantity (kg)	Rate	Amount	Discount (10%)	Net amount
1	Apple	20	150
2	Lemon	30	120
3	Grapes	50	230

a. Calculate Amount discount and net amount with suitable formula.

b. Create a pie chart of Rate

Solution:-

Write down the above data in the excel sheet and type the following formulas in the cells.

Formula:-

Amount (E2):-    =C2*D2

Ms excel picture view for creating Amount 

Discount Amount (E2):-   =E2*10%

Ms excel formula view for creating Discount Amount 

Net Amount (E2):-     =E2-F2

Ms excel formula view for Net Amount 

To insert Pie Chart:-

Step 1:- Select Column Name (B), Rate (D)

Step 2:- Go to Insert Tab.

Step 3:- Click Pie chart option under Charts group. That's all.

Ms excel Figure for Creating Pie Chart