QI. Prepare a Payroll Sheet (for 6 employees of a company named A, B, C, D, E and F) using necessary IF functions in MS Excel showing various components of City, Category, HRA, TA, HRA and CCA etc. from the following details: - Basic Salary: The Basic Salary of A is Rs. 6,000. The Basic Salary of B is double that of A. The Basic Salary of C is 45,000 The Basic Salary of Dis 35,000 The Basic Salary of E is ? 43,000 The Basic Salary of F is half of that ofc 11. 111 Dearess allowance is paid @ rate of 45% of Basic salary subject to a maximum of 9000 Transport allowance (TA) is 2500 and 3000 for category X and category Y employees. Categories X covers those employees having basic salary plus dearess allowance of 50,000 or more. Other employees are covered in Category Y. HRA is computed on the basis of following info: iv. BASIC Upto 10,000 10.001 to 25000 Above 25001 HRA 10% 1000 20% of basic salary above 10,000