WRITTEN WORK # 15 Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Weekly Salary Bi- Monthly Salary Name Annual Semi- Salary Monthly weekly Marites P11,538 dut P20,000 Janice Lyn P5,000 Leo P40,000 Flor P96,000 Activity 2. Spread my Salary Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) F G INCOME DEDUCTIONS SSS PHILHEALTH PAGIBIG TAX Total Basic Monthly Salary Name Deductions 4% 1.50% 2% 12% 3 4 Magpayo, Lyn 5 Quiambao, Jhaz 6 Cruz, Russel 7 Garcia, Geth 8 Nicdao, Maine 9 Mendoza, Rhoda 0 Mallari, Tes 1 Santos, Paula 2 Urbano, Janeen P20,000.00 P25,000.00 P30,000.00 P40,000.00 P45,000.00 P50,000.00 P55,000.00 P60,000.00 P65,000.00
WRITTEN WORK # 15 Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Weekly Salary Bi- Monthly Salary Name Annual Semi- Salary Monthly weekly Marites P11,538 dut P20,000 Janice Lyn P5,000 Leo P40,000 Flor P96,000 Activity 2. Spread my Salary Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) F G INCOME DEDUCTIONS SSS PHILHEALTH PAGIBIG TAX Total Basic Monthly Salary Name Deductions 4% 1.50% 2% 12% 3 4 Magpayo, Lyn 5 Quiambao, Jhaz 6 Cruz, Russel 7 Garcia, Geth 8 Nicdao, Maine 9 Mendoza, Rhoda 0 Mallari, Tes 1 Santos, Paula 2 Urbano, Janeen P20,000.00 P25,000.00 P30,000.00 P40,000.00 P45,000.00 P50,000.00 P55,000.00 P60,000.00 P65,000.00
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.2: Representing Data
Problem 11PPS
Related questions
Question
100%
PLEASE HELP ME A.S.A.P. FOR AN UPVOTE AND POSITIVE RATINGS
![WRITTEN WORK # 15
u mco sp he
Activity 1. Spread my Salary
Direction: The data below shows the partial salary of employees. Complete the table
to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the
formula)
Weekly
Salary
Semi-
Bi-
Monthly
Salary
Name
Annual
Salary
Monthly
weekly
Marites
P11,538
P20,000
Janice
Lyn
P5,000
Leo
P40,000
shoil
Flor
P96,000
Activity 2. Spread my Salary
Direction: Using the spreadsheet, compute for the corresponding contributions of the
followingemployees. Compute also their total deduction. (Show the formula)
E
F
H.
A
INCOME
DEDUCTIONS
Name
Basic Monthly
SSS PHILHEALTH PAGIBIG
TAX
Total
Deductions
Salary
4%
1.50%
2%
12%
4 Magpayo, Lyn
5 Quiambao, Jhaz
6 Cruz, Russel
7 Garcia, Geth
8 Niedao, Maine
9 Mendoza, Rhoda
0 Mallari, Tes
1 Santos, Paula
2 Urbano, Janeen
P20,000.00
P25,000.00
P30,000.00
P40,000.00
P45,000.00
P50,000.00
P55,000.00
P60,000.00
P65,000.00
23](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F38bc9079-ae80-4de8-b4ec-19abb94ea09e%2F283619c3-989d-44a5-9391-2813b8094394%2F0p409dt_processed.jpeg&w=3840&q=75)
Transcribed Image Text:WRITTEN WORK # 15
u mco sp he
Activity 1. Spread my Salary
Direction: The data below shows the partial salary of employees. Complete the table
to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the
formula)
Weekly
Salary
Semi-
Bi-
Monthly
Salary
Name
Annual
Salary
Monthly
weekly
Marites
P11,538
P20,000
Janice
Lyn
P5,000
Leo
P40,000
shoil
Flor
P96,000
Activity 2. Spread my Salary
Direction: Using the spreadsheet, compute for the corresponding contributions of the
followingemployees. Compute also their total deduction. (Show the formula)
E
F
H.
A
INCOME
DEDUCTIONS
Name
Basic Monthly
SSS PHILHEALTH PAGIBIG
TAX
Total
Deductions
Salary
4%
1.50%
2%
12%
4 Magpayo, Lyn
5 Quiambao, Jhaz
6 Cruz, Russel
7 Garcia, Geth
8 Niedao, Maine
9 Mendoza, Rhoda
0 Mallari, Tes
1 Santos, Paula
2 Urbano, Janeen
P20,000.00
P25,000.00
P30,000.00
P40,000.00
P45,000.00
P50,000.00
P55,000.00
P60,000.00
P65,000.00
23
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
![College Algebra (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305652231/9781305652231_smallCoverImage.gif)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell