EXCEL REMEDIATION PRACTICAL EXAM (Quarter 3 Week 4)

 Using Function Formula and Excel Operations do the following tasks:

1. Get the total gross amount of Bingbing Marcosleta for the month of January, February, and March 
2. Get the total basic salary, P.E.R.A. for the month of January, February, and March
3. Get the daily salary of BinBing Marcosleta through his monthly Basic Salary NOTE: Consider that every month is consists of 30 days to get the daily salary of Marcosleta
4. To get the total leave without pay for the month of January, February and March used the Table 1 as a reference
5. Get  the Total deductions for the month of January, February, and March
6. Get the Net Pay for the month of January, February, and March by subtracting the Gross amount per month from the total deductions per month
Due : April 2, 2022 (1:00PM)

Excel Link: 

https://docs.google.com/spreadsheets/d/1Z71aWuSOrEEf72OzqUvFGnAhkU4_m0bt/edit usp=sharing&ouid=111131900651826017041&rtpof=true&sd=true

Preview: