22A Using absolute cell references as necessary, in cell C23, construct a formula to calculate the projected expenses for 2020 after the Forecasted increase in cell B21 is applied. Fill the formula through cell F23. 22B Display the Sales Reps sheet. By using Flash Fill and deleting columns as necessary, place the last names in column A and the first names in column B. Widen both columns to 100 pixels, and then merge and center the title Sales Reps across the two columns. Apply the Heading 1 cell style to the title. A B D F G Direct Expenses by Quarter Summary % of Tota 53% 18% 14% 1% 14% Quarter ! Quarter 2 Quarter 3 Quarter 4 Annual Total Sales Expense $ 4,458,578 $ 4,678,712 $ 4,887,953 $ 5,325,215 $ 19,350,458 Administrative Expense 1,311.774 1,587,963 1,689,563 1,856,878 6,446,178 Rent Expense 1.317,470 1,317,470 1,317,470 1,317,470 5,269,880 Interest Expense 129,713 138,963 115,786 128,963 513.425 - Advertising Expense 964,872 1.184,532 1,278,741 1,581,372 5,009,517 Totals by Quarter $ 8,182,407 $ 8,907,640 $ 9,289,513 $ 10,209,898 $ 36,589,458 1 2 3 Direct Expenses 4 $11,000,000 5 $10,000,000 6 59,000,000 7 $8,000,000 18 Quarter 1 Quarter 2 Quarter 3 Quarter 4 19 20 Expenses 5-Year Forecast 3.5% 2019 2020 2021 2022 2023 $ 36,589,458 21 Forecasted Increase 22 Year 33 Projected Expenses 24 25 26 27 28 29 30 Denver Inventory Inventory Summary Annual Expenses Sales Rep Ready