6. Your lobster fishing business is straightforward, and you run your accounting in Excel. You maintain separate workbooks for each year, and each workbook has a spreadsheet for every month. The monthly spreadsheets are identical except for their names, which are January, February, etc. You have found that you need to sum your diesel fuel expenditures, which are always recorded in cell D18, for the months of August through December. What three-dimensional formula would give you that result? SUMNEW(D18, AUGUST:DECEMBER) SUM(8:12D18) SUM(March:July!"D18") SUM(AUGUST:DECEMBERID18) 7. You started off as a bartender, but you have advanced into the financial planning department of a chain of expensive restaurants, and now you are trying to identify spending patterns. Please download the file final.xlsx and refer to Worksheet A. Rounded to the nearest dollar, what was the 10th largest total transaction booked on this particular evening? 3802 4078 4581 5347 A B D E F 77 18 68 O 00 82 mm 52 75 15 39 38 62 71 24 60 42 74 63 93 94 51 $ 48 $ 48 $ 46 $ 44 $ 44 $ 43 $ 43 $ 42 $ 39 $ 38 $ 37 $ 37 $ 33 $ 30 $ 26 $ 26 $ 25 $ 21.65 $ 28.48 $ 31.35 $ 17.37 S 37.52 $ 17.24 $ 17.36 $ 32.32 $ 39.16 $ 32.21 $ 32.32 $ 29.68 $ 22.93 $ 32.47 $ 26.42 $ 37.43 $ 23.14 $ 26.29 $ 1,104.15 1,367.04 1,504.80 799.02 1,650.88 758.56 746.48 1,389.76 1,644.72 1,256.19 1,228.16 1,098.16 848.41 1,071.51 792.60 973.18 601.64 657.25 S 3 B C D E Nun 1 2 3 4 5 6 7 8 9 10 11 ou AWN 9 12 13 14 25 16 17 18 19 20 21 22 3 24 5 6 7 8 9 10 1 2 3 100 140 196 274.4 384.16 537.824 752.9536 1054.13504 1475.789056 2066.104678 2892.54655 4049.56517 5669.391238 7937.147733 11112.00683 15556.80956 21779.53338 30491.34673 42687.88542 59763.03959 83668.25543 117135.5576 163989.7806 229585.6929 321419.97 449987.9581 629983.1413 881976.3978 1234766.957 1728673.74 2420143.236 3388200.53 4743480.742 6640873.038 5