please help with the requirements asked above.

Q.3. Prepare a Payroll Sheet for Vanika Ltd. is prepared in MS-Excel as given in the following format. You are required to write the MS Excel formulas / Functions in Cells C2 to F6 (mentioned in question marks), given that: (i) DA is paid at 35% of Basic Pay. (ii) HRA is paid at 25% of Basic subject to maximum of Rs. 2000. (ii) TA is paid at Rs. 3200 if basic is less than Rs. 10000, otherwise it is Rs. 5000. (iv) Gross Salary of an employee is the total of Basic Pay, DA, HRA and TA. Assignment Also calculate the total amount of DA, HRA, TA and Gross Salary being paid to all four employees. D F B Basic Pay DA E TA 1 HRA 2 ? ? ? A Employee Name Amit Anjali Aarav Vanika Total Gross Salary ? ? ? ? ? 8000 16000 5500 12000 3 4 ? ? ? 5 ? ? ? ? ? 6