The questions are: 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.

AutoSave 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