Ms excel Practical Question with solution; How to Calculate Commission, Earning and ax of Sales Amount.

Question:- Enter following data in speadsheet and perform as asked. (10) 

SN	EMP Code	Sale AMT	Commission	Earning	Tax	Net Earning
1	1001	5000
2	1002	3800
3	1003	4000

a. Enter above data in sheet 1. (2)

b. Calculate Commission as 7% of Sales AMT. (1)

c. Calculate Earning as sum of Sales AMT and Commission. (1)

d. Calculate Tax as 13% of Earning for all Sales AMT equal or more than 4000. (2)

e. Calculate Net Earning as the difference of Earning and Tax. (1)

f. Create a column chart showing Earning and Net Earning for each EMP Code. (3)

Solution:-

Write Down the following Formula in the required cells of excel sheet:-

Commission (D2):-    =C2*7% 

Earning (E2):-    =SUM(C2:D2) 

Tax (F2):-    =IF(C2>=4000, E2*13%, 0) 

Net Earning (G2):-     =E2-F2