7. Copy the Invoices worksheet, and then rename the copied worksheet as Overdue Accounts. In the Overdue Accounts worksheet, do the following: a. Filter the records so only invoices whose balance is past due are displayed. These are all records with an amount in 130 days (column I), 3160 days (column J), 6190 days (column K), or Over 90 days (column L). b. Sort the filtered data by invoice date (oldest first). c. Include a Total row in this table, and display sums for columns I through L. d. Hide columns D, E, F, G, and H. e. Remove the filter buttons and gridlines from the table. (Hint: Use options on View tab and the Table Tools Design tab.)

LKE Recevables -Excel Insert Page Layout Formulas Deta Revieww Views Help Desgnell me whet you want to do 6056-Accents Copy Merge & Certe, $. %, Condition altor bletas Nen Blu. -2. Comma [o] Insert Delete Fon Accent6 CurrencY Format Painter Clipboard - Styles 115 1 Current Date /1/2017 Invoice Days Past Number - Invoice DateCompany sales RepCommissioAmounDueCurrent1-30 day31-60 da 6190 days ovr so da 102735/28/2017 Consortium for Ocean Leadership nson 123.54 $2,142.40 $155.40 $1,414.80 HN/A144.00 HN/A164.40 #N/A $4,819.40 #N/A |$ 452.0 A $ 1,174.00 #N/A $3,868.60 5 1,194.00 69/2017 MRSI Group, Inc $ 155.40 10283 10321 10323 10329 10358 10370 6/12/2017 Natural Environment Research Co 5/5/2017 Alpharma, Inc 5/8/2017 Cardio Tech International Inc. 144 164.4 6/27/2017 Image Acoustics, Inc. Dynamics Inc. Lesure Boehmer Johnson Boehmer RI 6/2/2017 Ocean 5/5/2017 Materials Sciences Corporation 0 $452.00 1174 1001 61/2017. M. A.Dynamite Group, Inc. 2/7/2017 Marine BloConversion, LLC #N/A #N/A | $ 802.00! 5/10/2017 New Medical Center 6/16/2017 Advanced Scientific Concepts, Inc 5/17/2017 American Heart Association Boehmer- 10410 10413 10413 52 5 2,123.20 #N/A |$1,814.30 $2,210.80 HN/A 713.30 A $1,328.00 $ 182.40 N A704.00 5/8/2017 Lyme Disease Assoc of N 6/6/2017 Pro Change Behavior Systems $ 713.30 10471 6/11/2017American Psychology Foundation 0476 6/17/2017 CSCS Corp. 10483 5/26/2017 Global Environment& Technoloay Foundation Lesure 10500 5/10/2017 Perry Institute for Marine Science 10502 5/11/2017 Save the Lions 10527 10539 6/16/2017 Emiteclh 105676/15/2017 Northeast Fisheries Science Center 10571 618/2017 5AECT 105776/26/2017 Altuna International Research Co. Riley -r-HN/A 0 182.40 36 704 Boehmer N/A550.80 A #N/A #N/A #N/A 816.30 $1,670.00 $355.50 $3,109.00 5 647.75 | $569.00 28.00 6/5/2017 Cape Cod National Seashore NPS 355.50 0 647.75 0 S 569.00 27 #N/A 5/20/2017 BoBell Flavors, Inc Johnson 28 LKE Recevables -Excel Insert Page Layout Formulas Deta Revieww Views Help Desgnell me whet you want to do 6056-Accents Copy Merge & Certe, $. %, Condition altor bletas Nen Blu. -2. Comma [o] Insert Delete Fon Accent6 CurrencY Format Painter Clipboard - Styles 115 1 Current Date /1/2017 Invoice Days Past Number - Invoice DateCompany sales RepCommissioAmounDueCurrent1-30 day31-60 da 6190 days ovr so da 102735/28/2017 Consortium for Ocean Leadership nson 123.54 $2,142.40 $155.40 $1,414.80 HN/A144.00 HN/A164.40 #N/A $4,819.40 #N/A |$ 452.0 A $ 1,174.00 #N/A $3,868.60 5 1,194.00 69/2017 MRSI Group, Inc $ 155.40 10283 10321 10323 10329 10358 10370 6/12/2017 Natural Environment Research Co 5/5/2017 Alpharma, Inc 5/8/2017 Cardio Tech International Inc. 144 164.4 6/27/2017 Image Acoustics, Inc. Dynamics Inc. Lesure Boehmer Johnson Boehmer RI 6/2/2017 Ocean 5/5/2017 Materials Sciences Corporation 0 $452.00 1174 1001 61/2017. M. A.Dynamite Group, Inc. 2/7/2017 Marine BloConversion, LLC #N/A #N/A | $ 802.00! 5/10/2017 New Medical Center 6/16/2017 Advanced Scientific Concepts, Inc 5/17/2017 American Heart Association Boehmer- 10410 10413 10413 52 5 2,123.20 #N/A |$1,814.30 $2,210.80 HN/A 713.30 A $1,328.00 $ 182.40 N A704.00 5/8/2017 Lyme Disease Assoc of N 6/6/2017 Pro Change Behavior Systems $ 713.30 10471 6/11/2017American Psychology Foundation 0476 6/17/2017 CSCS Corp. 10483 5/26/2017 Global Environment& Technoloay Foundation Lesure 10500 5/10/2017 Perry Institute for Marine Science 10502 5/11/2017 Save the Lions 10527 10539 6/16/2017 Emiteclh 105676/15/2017 Northeast Fisheries Science Center 10571 618/2017 5AECT 105776/26/2017 Altuna International Research Co. Riley -r-HN/A 0 182.40 36 704 Boehmer N/A550.80 A #N/A #N/A #N/A 816.30 $1,670.00 $355.50 $3,109.00 5 647.75 | $569.00 28.00 6/5/2017 Cape Cod National Seashore NPS 355.50 0 647.75 0 S 569.00 27 #N/A 5/20/2017 BoBell Flavors, Inc Johnson 28