SUBTOTAL 123 INDEX(E10:E27,MATCH("Archibald Andrews",B10:827)) 1 44. Answer the following multi-part question 1. Using the data in A9:F24, use the Subtotals Excel feature to find the sum of total expenses for each 2 day. 32. Use a cell reference only to return the total expenses for October 7, 2017. G H Type your responses below $ 2,555.00 Answer 43. Use a single Excel function to find out the total spent on Food just on September 29, 2017. 4. Use INDEX and MATCH to find out how much Archibald Andrews spent on Lodging. $ 174.00 Answer INDEX(E1027,MATCH "Archibald Andrews", 810:827)) INDEXarray, row.num, (column_num) INDEX(reference, row_num [column_num] [area_num] 7 8 9 Date Employee Food Airfare Lodging Total 10 9/26/2017 Archibald Andrews $ 27.00 $ 688.00 $ 176.00 $ 891.00 11 9/26/2017 Elizabeth Cooper $ 66.00 $ 522.00 $ 406.00 $ 994.00 12 9/26/2017 Veronica Lodge $ 60.00 $ 314.00 $ 409.00 $ 13 9/26/2017 Total $ 783.00 2,668.00 14 9/29/2017 Hermione Lodge S 21.00 $ 548.00 $ 351.00 $ 920.00 15 9/29/2017 Fred Andrews $ 80.00 $ 342.00 $ 401.00 $ 16 9/29/2017 Kevin Keller $ 41.00 $ 645.00 $ 259.00 $ 823.00 945.00 17 9/29/2017 Cheryl Blossom $ 32.00 $ 751.00 $ 145.00 $ 928.00 18 9/29/2017 Total $ 3,616.00 19 10/4/2017 Alice Cooper $ 79.00 $ 559.00 $ 201 10/4/2017 Josephine McCoy $ 22.00 $ 554.00 $ 490.00 $ 1,128.00 141.00 $ 717.00 21 10/4/2017 Jughead Jones $ 73.00 $ 336.00 $ 455.00 $ 864.00 22 10/4/2017 Hal Cooper $ 55.00 $ 353.00 $ 337.00 $ 23 10/4/2017 Hiram Lodge $ 37.00 $ 386.00 $ 232.00 $ 745.00 655.00 24 10/4/2017 Total $ 4,109.00 25 10/7/2017 Reggie Mantle $ 37.00 $ 601.00 $ 138.00 $ 26 10/7/2017 Valerie Brown $ 47.00 $ 520.00 $ 271.00 $ 776.00 838.00 27 10/7/2017 Penelope Blossom $ 66.00 $ 699.00 $ 176.00 $ 941.00 28 10/7/2017 Total $ 2,555.00 29 Grand Total $ 12,948.00 30 31