1. Open a new workbook and type the following to the corresponding cells: Location Tax Manila Makati Makati Caloocan Mandaluyong Makati Quezon City Quezon City Mandaluyong Manila Caloocan Caloocan Quezon City Quezon City Manila Invoice Invoice Invoice Remarks Submitted by the on Amount Vendor Record 010001 010001 18,086.00 000502 000502 28,000.00 000703 003703 16,216.00 004004 004004 2,000.00 008005 008005 8,216.00 006006 006006 8,764.00 003007 003007 8,764.00 007008 004008 8,764.00 001009 001009 8,764.00 008010 008010 8,790.00 004012 005011 45,000.00 002011 008017 30,000.00 008017 005311 5,000.00 005311 008017 15,000.00 001015 002011 25,000.00 Summary: Total Invoice Amount for Manila Total Invoice Amount for Quezon City and "Not Found" Total Number of "For Verification" 2. Using Match function, under Remarks column, put a remark FOUND" if invoice on record exists in invoice submitted by the vendor. "NOT FOUND" if otherwise. Write the function(s) on the topmost cell then drag down to the last row using the fill-handle. 3. If invoice is found, compute for the Tax using the table below using Vlookup. Tax is equal to the basictax across the range where basic pay falls, plus the percentage of invoice amount. Percentage is specified in excesspct. If not found, put a remark "For Verification" under Tax column. Write the function(s) on the topmost cell then drag down to the last row using the fill-handle. rangel 0 2083 2500 3333 5000 7917 12500 22917 range2 2082.99 2499.99 3332.99 4999.99 7916.99 12499.99 22916.99 9999999999 basictax 0 0 20.83 104.17 354.17 937.5 2083.3 5208.3 excessnct 0% 5% 10% 15% 20% 25% 30% 32% 4. 5. Accomplish the summary table applying appropriate functions. Save with filename Activity 7