Question No. 05: [6 Marks) Use Microsoft Excel to design the following payment sheet and calculate the missing values using formulae. Hint: Gross amount Work hours' x Hourly rate Net payable amount Gross amount - Tax deduction. A1B2 ENTERPRIZES TEXTILE, FASHION & MERCHANDISINIG DEPARTMENT REMUNERATION SHEET FOR THE MONTH OF DECEMBER 2019 Sr. No Employee ID Employee Name WORK HOURS HOURLY GROSS TAX RATE AMOUNT DEDUCTION NET PAYABLE AMOUNT 1 123456 SALE Name and Location SAFA MALL (DHA KARACHI SAIMA MALL (GULSHAN KARACHI) 42 1,500 10% AHMED ABBAS AFIFA FATIMA 7 2 123789 31 900 ? 15% ? 3 789521 ANITA YOUNUS AREEBA CENTRE (PECHS KARACHI 25 1,400 ? 12% ? TOTAL: ? Rubrics (Scoring Guide) - Designing = 50% - Calculations (Formulae) = 50%