Question

3. Create an Excel worksheet to calculate the salary of the employees of "TITO Software
Company and save it under the name 'Payroll.xlsx':
SALARY SHEET 2019-20
E_CODE
E NAME
DESIGNATION BASIC HRA ALLOW GROSS
PF
IT
NET
PAY
B001
Mr Surya Prakash
Manager
19500
2463
5700
5400
B002
MsAlka Singh
Asst. Manager
9000
4500
3200
1200
2200
B003
Mr. David
8500
5100
1850
Group Leader
Soft. Eng.
B004
Ms. Chauhan
8500
5100
1000
1625
B005
MrSuman
Soft. Eng.
7500
4500
1000
1600
B006
MrAlok Gupta
Soft. Eng.
75001 4500
800
1600
a) Calculate the values using formulas for the empty fields in the above given that:
GROSS = BASIC + HRA+ ALLOWANCE (PF is 10% of BASIC) and NET PAY =
GROSS-PF - IT
b) Add a row above the first row and merge the cells in that row. Fill that row with a
colour of your choice and label it as TITO Software Company.
c) Format the excel sheet to make it look presentable.
d) Take the printout of the Excel worksheet and file it in your report file.

guys pls answer this question​

Answer 1

Answer:

Take the printout of the excel worksheet and file it in your report file