Mangalore University 1 SEM BCA Ex 3 : ExcelPractical exercise for FIT Lab
Автор: Mani Dsouza
Загружено: 2022-11-20
Просмотров: 47991
Описание:
Create Employee worksheet having EmpNo, EmpName, DOJ, Department, Designation and Basic Pay of 8 employees. Calculate DA, HRA, Gross Pay, Profession Tax, Net Pay, Provident Fund as per the rule
• DA = 30% of basic pay
• HRA = 10% of basic pay if basic pay is less than 25000, 15% of basic pay otherwise.
• Gross =DA +HRA+ Basic pay
• Provident fund =12% of Basic pay or Rs.2000, whichever is less.
• Profession Tax= Rs.100 if Gross pay is less than 10000, Rs.200 otherwise.
• NetPay = Gross - (Professional tax + Provident Fund)
• Using Pivot table, display the number of employees in each department and represent it using Pie chart.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
