This question also does not require the use of your assigned "AP_Detail.xls" file. Rather, this is a second essay question related to one of the LinkedIn Learning "Excel Boot Camp" videos. For this essay question, please specify (with maximum detail and in your own words) how you would insert "single-level" subtotals to alphabetically sum the AP_AMOUNT column at each change in VENDNAME. For help with responding to this question...refer to the LinkedIn Learning videos that we assigned in class (available on Canvas).

AutoSave OFF 3 FA21_AP_Detail Home Insert Draw Page Layout Formulas Data Review View Analytic Solver Data Mining ? Tell me Share Comments MS Sans Serif 10 AA D Wrap Text v General Insert v x Delete v Paste BIUV A Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format Filter Select Data J18 X V fx C K M N O P Q Column 1 Column Column 3 Column Column 5 Column 6 Column CN - Record VENDNO VENDNAME COMPANY INVNO INVDATE AP_AMOUNT 000181 RADIANT SYSTEMS 100 12/19/2010-00000000000000213307-INV 12/19/10 $ 1,635.37 $ (99,225.47 000216 ST. TIMOTHY LUTHERAN CHURCH 100 11/28/2010-00000000010811282010-BP 11/28/10 $ 38.94 000216 ST. TIMOTHY LUTHERAN CHURCH 100 1 1/28/2010-00000000010811282010-BPINS 11/28/10 $ (3.00 KEUKA FOOTWEAR, INC. 142 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/04/2010-00000000010812042010-BP 12/04/10 $ 74.71 A CO CO V OR UI A W N - 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/04/2010-00000000010812042010-BPINS 12/04/10 $ (5.75) No 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/06/2010-00000000010812062010-BP 12/06/10 $ 63.52 000216 ST. TIMOTHY LUTHERAN CHURCH 100 2/06/2010-00000000010812062010-BPINS 12/06/10 $ ( 4.89 ) 64 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/07/2010-00000000010812072010-BP 12/07/10 $ 73.23 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/07/2010-00000000010812072010-BPINS 12/07/10 $ (5.94) $ 41,749.31 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/17/2010-00000000010812172010-BP 12/17/10 $ 122.76 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/17/2010-00000000010812172010-BPINS 12/17/10 $ (9.44) 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/19/2010-00000000010812192010-BP 12/19/10 $ 52.98 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/19/2010-00000000010812192010-BPINS 12/19/10 $ (4.08 000216 ST. TIMOTHY LUTHERAN CHURCH 100 11/26/2010-00000000010811262010- 1 1/26/10 $ 86.00 000216 ST. TIMOTHY LUTHERAN CHURCH 100 1 1/26/2010-00000000010811262010-INS 1 1/26/10 $ 4.53 000216 ST. TIMOTHY LUTHERAN CHURCH 100 1 1/28/2010-00000000010811282010- 11/28/10 $ 140.00 000216 ST. TIMOTHY LUTHERAN CHURCH 100 1 1/28/2010-00000000010811282010-INS 11/28/10 $ (4.06) 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/04/2010-00000000010812042010 12/04/10 $ 105.74 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/04/2010-00000000010812042010-INS 12/04/10 $ (5.57) 000216 ST. TIMOTHY LUTHERAN CHURCH 100 2/06/2010-00000000010812062010- 12/06/10 $ 140.00 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/06/2010-00000000010812062010-INS 12/06/10 $ (3.94) 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/07/2010-00000000010812072010- 12/07/10 $ 140.00 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/07/2010-00000000010812072010-INS 12/07/10 $ (4.24) 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/17/2010-00000000010812172010- 12/17/10 $ 140.00 000216 ST. TIMOTHY LUTHERAN CHURCH 100 2/17/2010-00000000010812172010-INS 12/17/10 $ (5.50) 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/19/2010-00000000010812192010- 12/19/10 $ 140.00 000216 ST. TIMOTHY LUTHERAN CHURCH 100 12/19/2010-00000000010812192010-INS 12/19/10 $ (5.32) 000224 STREET & SMITH'S SPORTS GROUP 100 12/06/2010-00000000004500414044- 12/06/10 $ 8,898.15 000276 JACKSON LEWIS LLP 100 05/28/2010-00000000000005379457- 05/28/10 $ 267.60 000276 JACKSON LEWIS LLP 100 12/07/2010-00000000000005480553- 12/07/10 $ 3,025.40 000292 CITY OF PEORIA 100 06/05/2009-00000000000903052043-X 06/05/09 $ (1,009.96 000293 BELMONT CAPITAL, LLC. 100 12/28/2010-00000000000000042010-THQRTREIMB 2/28/10 $ 22,720.66 33 000321 SHERMAN & HOWARD LLC 100 12/17/2010-00000000000000511754- 12/17/10 $ 975.25 34 000490 FISHER & PHILLIPS LLP 100 12/08/2010-000 0000018004639567- 12/08/10 $ 1,923.01 35 000490 FISHER & PHILLIPS LLP 100 12/04/2009-00000000025682586998 12/04/09 $ 350.00 36 000490 FISHER & PHILLIPS LLP 100 04/13/2010-00000000025682605101- 04/13/10 $ 336.00 37 000490 FISHER & PHILLIPS LLP 100 06/14/2010-00000000025682613577- 06/14/10 $ 455.00 38 000490 FISHER & PHILLIPS LLP 100 09/08/2010-00000000025682624293-ADJ 09/08/10 $ 700.00 000510 DEPARTMENT OF WATER SUPPLY 100 12/13/2010-00000000033318011210- 12/13/10 $ 161.95 000510 DEPARTMENT OF WATER SUPPLY 100 12/13/2010-00000000359633371210- 2/13/10 $ 1 12.00 000528 MARSH USA INC 100 12/23/2010-00000000000000222269 12/23/10 $ 75,000.0 000528 MARSH USA INC. 100 12/23/2010-00000000000000222270- 12/23/10 $ 4,558.50 43 000667 KONA LOCKSMITH INC 100 12/15/2010-00000000000000082458- 12/15/10 $ 164.59 000670 HAWAIIAN TEL 329-3187 HWN 100 12/10/2010-00000000000045704465- 12/10/10 $ 225.10 000671 HAWAIIAN TELCOM 334-1570 100 12/10/2010-00000000000045689321 12/10/10 $ 43.77 46 000762 ADT SECURITY SERVICES 100 1 1/30/2010-00000000000035396074 1 1/30/10 $ 43.59 000762 ADT SECURITY SERVICES 100 1/30/2010-00000000000035396094- 1 1/30/10 $ 149.37 50 000793 1813DESIGNWORKS 100 12/20/2010-00000000000000000032-CTP 12/20/10 $ 5,856.00 non702 1812DECIGMWODKC 100 12/20/10 2 125 00 Start Here Open Invoices Ready 100%