Question: 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

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%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I need help editing an excel file by entering the correct formulas. I have a hard time understanding the if functions and how to set them up. I am hoping after seeing the formulas entered it will...

I need help to the excel IMPLEMENTATION Use Table 10.1 and Figure 10.1 to help you understand the parameter values and to enter the employees' input data correctly. Make sure you format the numeric...

days days wat in colum n s D. E. F and G using Microsoforte che Excel Refer to Table 1. Write the Excel formula for cach cell marked with ? in columns B, C and D such that formula could be copied and...

Refer to Table 1. Write the Excel formula for each cell marked with ? in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using Microsoft Excel without...

2020 (1.5 marks) (1.5 marks) (2.5 marks) (2 marks) (1 mark) (3 marks) (3 marks) 31 2020 33 (1 mark) (1 mark) (2 marks) (1 mark) 34 35 2020 36 37 38 (1 mark) (1 mark) (2 marks) 40 2020 41 42 (1 mark)...

Refer to Table 1. Write the Excel formula for each cell marked with q in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using Microsoft Excel without...

Can I have the exacl formula as soon as possible?Thank you Refer to Table 1. Write the Excel formula for each cell marked with w?" in columns B. Cand D such that formula could be copied and pasted...

Refer to Table 1. Write the Excel formula for each cell marked with ? in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using Microsoft Excel without...

Section B (40 marks) 'Refer to Table 1. Write the Excel formula for each cell marked with ? in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using...

When the tension in a cord is 75 N, the wave speed is 140 m/s. What is the linear mass density of the cord?

Dr. Smith is a teacher in the education department who serves one student at a time throughout the day. He can serve an average of 8 students per hour and the students arrive at his office at a rate...

At the maturity date, a bonds carrying value equals itsSelect answer from the options belowface value.market price.premium.discount.

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Ethics. Teamwork. Form a team of three to five students. Each of you will listen to a television news show for one week or read the daily newspaper to identify situations reported in the news that...

How do these technology tools change communication use: Wi-fi, podcasts, and blogs? (Objective 1)

Describe two types of laws that affect agreements between two or more parties. (Objective 3)