I do not understand how to do steps 7 & 9.

4 1 7 6 = | Instructions_NP_EX19_EOM5-1 (2) - WordPad X File Home View Cut Verdana Copy - 10 " A A" 1 3 . 15. Find Paste BI U abc X X' A . 2. B3 30 Picture Paint Date and Insert Gac Replace drawing time object Select all Clipboard Font Paragraph Insert Editing 1 . . . I . 2 . 3 . . I . . .7 . Lonnie prefers that accountants and others contact Lewellen through the link in cell H8 rather than one that connects to his email address. In cell C21, remove the hyperlink, leaving the unlinked text "Lonnie Holtzman" in the cell. Lonnie wants to combine the profit and loss data for 2022 from each of the three Lewellen offices. In cell E6, enter a formula using the SUM function, 3- D references, and grouped worksheets that totals the values from cell C6 in the Charlotte: Milwaukee worksheets. Copy the formula from cell E6 to cell E7, the range E9:E11, the range E13:E15, and the range E17:E19. In the range E17:E19, copy the formula and number formatting only. Go to the Charlotte worksheet. Lonnie needs to calculate the percent of sales for each expense item. Assign the defined name Revenue to cell C6. . In cell D7, enter a formula without using a function that divides the Cost of sales value in cell C7 by the revenue amount, using the defined name Revenue for the Charlotte worksheet. Copy the formula from cell D7 to the range D9:D11, the range D13:D15, and the range D17:D19. In the range D17:D19, copy the formula and number formatting only. Lonnie wants to apply consistent formatting to the worksheets he collected from the three Lewellen offices. Group the Charlotte, Denver, and Milwaukee worksheets, and then apply the Heading 1 cell style to cell B2 to use the same formatting as in the Dashboard worksheet. Ungroup the worksheets, and then verify that the formatting is applied to all three worksheets. . Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. 100% + Type here to search O A- 12:41 AM 6/20/2020AutoSave O Off) NP_EX19_EOM5-1_IsaiahWard_2 (3) - Saved . Search Isaiah Ward IW X File Home Insert Page Layout Formulas Data Review View Help Share Comments fx Q e Define Name By Trace Precedents fx Show Formulas - GO Calculate Now Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name G Use in Formula * "Trace Dependents Error Checking Watch Calculation Calculate Sheet Function Used v Time Reference * Trig Functions Manager Ed Create from Selection Fx Remove Arrows Evaluate Formula Window Options Function Library Defined Names Formula Auditing Calculation E6 X V A B C D E F G H J K L M N O P A w Group Stated in 000s Category Total 2021 Total Budget Total 2022 % Change from Budget Revenue $579,075 $ 583,888 100.0% Links Cost of sales 162,890 165,135 -100.0% Lewellen website Payroll Contact Lewellen 9 Salaries 143,000 143,500 100.0% Category list 10 Benefits 69,780 72,526 -100.0% Profit and loss statement 2021 11 Taxes 38,025 38,635 -100.0% 12 Operating Expenses 13 Sales and marketing 50,046 50,250 100.0% 14 General and administrative 64,128 65,655 -100.0% 15 Other operating 41,754 41,750 -100.0% 16 Summary 17 Gross profit 416,185 418,753 100.0% 18 Total expenses 406,733 412,316 -100.0% 19 Net profit $ 9,452 $ 6,437 -100.0% 20 21 Prepared by Lonnie Holtsman Documentation Dashboard Charlotte Denver Milwaukee Categories (+ + 100% Type here to search O A X 12:42 AM 6/20/2020