QUESTION 3 Create the file Question3. 1. The (Sheet 1) should be named parts Part No. Part Name Unit Price Description 1245 Air Filter $8 75 1988 Ford Escort 1246 Clutch Disc $47.75 1996-00 Honda Civic 1247 Brake Disc $35.15 |1986-89 Honda Accord 1248 Brake Disc Front $55.15 1998-02 Mazda 626 1249 A/C Filter Drier $55.55 1998 Toyota Camry 1250 Clamp $1. 10 2001 Ford F-150 1251 |Air Cleaner Vacuum Motor $10.75 1988 Ford Escort 1252 Clutch Coil Connector $5.75 1988 Ford Escort 1253 Pilot Bearing $9.10 1996-00 Honda Civic 1254 A/C Clutch $140.25 1996 Cadillac de Ville 1255 Clutch Cover (Pressure Plate) $1,70 2002 Chevrolet Blazer 1256 Strut Assembly $ 10.55 2000 Lincoln Town Car 1257 Brake Pad Front $45,85 1998-02 Mazda 626 1258 Goodyear $65,00 2000 Ford Club Wagon 1259 A/C Filter Drier $70,95 1998 Toyota Camry 1260 | Wheel Lug Nut $1,15 | 2000 Chevrolet Monte Carlo 2. (Sheet 2) should be named services. Cost Service ID Description Service Service Pressure Plate Repair $55,25 Windshield Repair $12,95 3 Brakes repair $40,25 4| Ignition Voltage Regulation $135,55 5 Wheel Cylinder Replacement $16,00 6 | Motor inspection $150,00 3. (Sheet 3) should be named Address. Customer Postal Code Customer Name Address City Province Code Phone # 1001 Dryer Jack 21 N. Navesink River Rd. Montreal QC H7K-6M2 (514) 555-0202 1002 Hamlin Rose 7 Church St. Montreal QC H21-8M8 (514) 555-7982 1003 Brown Sara 1005 First Ave Toronto ON J5A-6A4 (416) 555-1234 1004 Thomas Grant 214 White Rd. Ottawa QC 171-0Z2 (613) 555-0893 1005 Trent Maria 525 E. Palm Dr. Montreal QC H5B-7 J6 (514) 555-3618 1006 Liston Frank 302 Ash St. Toronto ON J3C-3H5 (416) 555-3017 1007 Chaplin Lon 91 Monmouth Ave Ottawa QC 171-6R8 (613) 555-3993 . Use the Sheet 4 to FORMAT THE INVOICE 2. Apply the appropriate formats to the invoice. 3. Use the VLOOKUP function to obtain the required information in all the fields marked with a question mark (?) 4. When you enter the Customer code, Part No, quantity, and the service ID, the information must appear automatically in all the other fields marked with Question mark (?). 5 . Insert all the necessary calculations to complete the invoice. 6. Name the Sheet 4 as VLOOKUP.QUESTION 4 . Create the following report Accounts Receivable Aged Report Use the function Report August Date: 31, 2019 1.75% 2.00% greater greater than 30 than 60 SALES INVOICE OUTSTANDING OVERDUE but less but less INVOICE # . CUSTOMER NAME ZONE INVOICE DATE AMOUNT DAYS veso than 61 than 91 Mtl-12589 Gagson Peter Montreal 22-Aug-19 2,125.00 Mtl-12602 Gerring Mario Montreal 28-Jun-19 1,268.00 27-Jun-19 Mtl-12615 Guardo Clyde Montreal 999.00 Mtl-12628 Gullington Raymond Montreal 13-May-19 3,158.79 Mtl-12641 Hubert Carmen Montreal 28-Jul-19 2,587.66 West 10-Mar-19 Mtl-12654 Johnston Rena Island 3,111.10 Mtl-12667 Lapping David Montreal 6-Sep-19 1,043.89 South 9-Jul-19 Mtl-12680 Nader Paul Shore ,897.56 South Mtl-12693 Nadon Eric Shore 21-Aug-19 3,025.79 West Mtl-12706 Nault Marie Island 14-Jul-19 1,589.85 1. Insert the Report Date (using the corresponding function) 2. In the column Outstanding days, use the corresponding formula to calculate the number of days between the report's date and the invoice date. 3. In the column Overdue, based on the outstanding days, display the message "Yes" or "No" if the due days are more than 30 days. 4 . Insert an additional column for outstanding days greater than 90 days 2.25%. 5 . In the next columns insert an If statement. If the outstanding days are greater than 30 but less than 61, apply the 1.75 % interest on the Amount due, and add to the Amount due. If the outstanding days are greater than 60 but less than 91, apply the 2.00 % interest on the Amount due, and add to the Amount due. If the outstanding days are greater than 90, apply the 2.25% interest on the Amount due, and add to the Amount due. Accessibility: UnavailableUse the following data after entering all the formulas and calculations to test your work In the field Date, today's date should appear. The customer code, part No, quantity and the service ID is provided below. Invoice # 1587 Customer code 1007 Part No. Qty 1253 3 1260 260 1245 10 1256 15 1258 25 1251 3 1247 50 Services ID performed 6 3 4 Save as Question3+your first name on the folder created on the desktop W? Accessibility: UnavailableMotoMaster 1456 Sherbrooke Montreal, Quebec H2L- 5H3 DATE : Function current date SOLD TO: Customer Name: Customer code Customer address City Province ? Postal Code Item Number Quantity Item Name Unit Price Total ? Formula Formula ? Formula Formula Subtotal Formula Service ID Quantity Description Service Unit Price formula Subtotal GST QST Shipping & Handling Total Due