please help on 7 and 8 with steps please!!!
7. For the June billings, Ladonna wants to display subtotals for each region. Sort the June Billings data in ascending order by Region. Add subtotals to the Billed column at each change in the Region. Use the Sum function and display the summary below the data. Ladonna wants to display the subtotals directly to the right of the subtotal heading. Hide column E, which does not contain information Ladonna needs to display with the subtotals. File Home Insert Draw Page Layout Formulas Data Review ViewHelp Power PIVUL A DO D D Z Stocks Sort Outline Get Data Geography Filter Refresh All Data Tools e What If Forecast Analysis Sheet Forecast Get & Transform Data Queries & Connec... Data Types Sort & Filter 19 IGH Quinn June Billings Invoice Number Date 2201 6/3/2021 2202 6/5/2021 2203 6/5/2021 2204 6/5/2021 2205 6/5/2021 2206 6/6/2021 2207 6/7/2021 2208 6/7/2021 2209 6/10/2021 2210 6/12/2021 2211 6/13/2021 2212 6/13/2021 2213 6/13/2021 2214 6/15/2021 2215 6/16/2021 2216 6/16/2021 2217 6/16/2021 2218 6/17/2021 2219 6/17/2021 22206 /18/2021 2221 6/18/2021 2222 6/19/2021 2223 6/19/2021 2224 6/20/2021 Links June Sales Region NE NE SE NE NW SW SW SE NE SE NE SE SE SE SW Specialty Specialty Specialty Superstore Discount Convenience Supermarket Supermarket Superstore Specialty Discount Supermarket Supermarket Specialty Supermarket Specialty Supermarket Supermarket Department Convenience Supermarket Convenience Superstore Department Billed $5,946 $4,337 $1,257 $3,730 $6,814 $5,142 $5,743 $5,140 $4,785 $5,731 $1,768 $5,025 $4,914 $3,186 $3,500 $1,875 $3,821 $3,611 $4,485 $2,020 $4,556 $3,991 $3,170 $3,897 Paid $2,817 54,205 $1,200 $2,700 $4,300 54,500 $3,300 $5,140 $4,000 $3,650 $1,500 $4,000 $3,400 $3,186 $3,200 $1,500 $2,900 $3,611 $4,000 $1,500 $4,100 $3,000 $2,170 $3,600 Balance $3,129 $132 $57 $1,030 $2,514 $642 $2,443 $0 $785 $2,081 $268 $1,025 $1,514 $0 $300 $375 $921 SE SE $0 SE NW SW SE SW NE NW July Sales $485 $520 $456 $991 $1,000 $297 100% hili investigate TI 36] Refresh Stocks Geography Data Tools What-If Analysis Alle Transform Data Queries & Connec... Fore Sort & Filter Data Types C D E F G H Quinn June Billings Region NW NE SW SW NE NW NW SW NE SE imtinos Invoice Number Date 2224 6/20/2021 22256 /20/2021 6/20/2021 2227 6/20/2021 2228 6/20/2021 2229 6/25/2021 2230 6/25/2021 2231 6/26/2021 2232 6/26/2021 2233 6/26/2021 2301 6/26/2021 2302 6/26/2021 2303 6/26/2021 2304 6/26/2021 2305 6/26/2021 2306 6/26/2021 2307 6/26/2021 2308 6/26/2021 2309 6/26/2021 2323 6/26/2021 2311 6/26/2021 23126 /27/2021 2313 6/27/2021 2314 6/28/2021 Links June Sales Accessibility: Investigate Store Type Department Discount Department Convenience Supermarket Superstore Discount Discount Department Supermarket Specialty Specialty Specialty Specialty Specialty Supermarket Convenience Convenience Superstore Convenience Specialty Supermarket Discount Specialty Superstore Billed $3,897 $2,914 $4,775 $2,984 $1,750 $5,946 $5.946 ! $4,337 $1,257 $3,730 $6,814 $5,142 $5,743 $2,942 $3,186 $3,500 $4,875 $3,821 $3,611 $4,485 $2,020 $1,556 $1,991 $3,170 $3,275 Paid $3,600 $2,650 $3,100 $2,984 $1,750 52.0 $3,000 $4,000 $1,257 $2,700 $4,500 $4,500 $3,000 $2,942 $3,186 $3,000 $4,500 $2,800 $3,611 $3,700 $1,500 $1,000 $1,000 $3,170 $2,825 Balance $297 $264 $1,675 $0 50 $2,946 $337 $0 $1,030 $2,314 $642 $2,743 $0 $0 $500 $375 $1,021 $0 NE SE SW SW SW NE SW SE SE NW SE NE July Sales $785 $520 $556 $991 SO $450
