PLEASE ANSWER THEM ALL CORRECTLY FOR AN UPVOTE AND POSITIVE RATINGS.
Extracted text: Activity 1. Pay Sheet Direction: Indicate the needed formula in solving for the specified cell by completing the statements below. Write your answers on your answer sheet. A B 14 EY EL PI COMPANY 02/14/2020 15 16 17 Name: Bianca U. Guevarra 18 Employee Number : 014344 19 Employment Status: Regular 20 21 GSIS Personal Share 22 PHILHEALTH 23 PAGIBIG Fund 24 BIR Withholding Tax 25 Total Deduction: 26 NET PAY: Pay Slip Month of February 2020 Basic Salary: P50,000.00 P1,500.00 Allowance: Gross Compensation: 1. DEDUCTIONS 9% 2. 1.50% 3. P100.00 to m P5,329.16 4. 5. 1. In F19, press_ then enter to solve for the gross compensation. 2. In press =E21*F17 or =E21*.09, then enter to solve for GSIS share 3. In F23, press_ 4. Press. 5. For net pay, press. to solve for. _to compute for the total deduction. Lon cell in cell
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here