The comparative income statements of Johnny Walker Company follow. Calculate trend percents for all components of the income statements using 2023 as the base year. Each formula must include the ROUND function, rounding all percents to 2 decimal places. (XXXXX\%) he comparative balance sheets of Johnny Walker Company follow. Express the balance sheets in common-size percents. Each formula must include the ROUND function, rounding all percents to 2 decimal places (XXX.XX\%). Using absolute addresses Once a formula is created, you will often want to copy the formula to other columns and rows. It's important to understand that excel always uses "retative addresses" unless you indicate otherwise by creating an "absolute address". For example, if you are calculating the cost of purchasing 2 boxes of cereal at a cost of $3.95 per box, the formula in cell B28 is =B26B27. Although we read cell B28 as "Multiply 2 boxes by $3.95 ", Excel is actually calculating the value in cell 828 as "Multiply the value in the cell in the same column (column B) 2 rows above (row 26 ) by the value in the cell in the same column 1 row above (row 27 ). This works just fine to calculate the cost of 2 boxes, but if we copy the formula in cell B28 to C28, Excei will assume relative references. The formula in cell C28 will become C26C27. Since Cell C27 is blank, the formula will return a value of $0 (which is an excellent deal for 6 boxes of cereal, but it isnt accuratel) Adding a $ sign before the column or row reference tocks the formula to a specific location. If we modify the formula in cell 828 to =826$8$27 before we copy the formula, Excel will not change the row or the column of the second variable. When the formula is copied to columns C through E, the formulas become: CellC28=C2658527CellD28=02658527Cell928=526$8527 Sometimes, you will want the column to stay fixed, but allow the row to remain relative when it's copied. If so, add a dollar sign before the column, but not the row (i.e.5B27) If you want the row to stay fixed, but allow the column to remain relative when it's copled, add a dollar sign before the row, but not the column (i.e. B $27 ). Tapping the F4 button while entering the formula (or in the formula bar) togeles among the 3 absolute options (Absolute Column and Absolute Row $3528, Absolute Column and Relative Row S828, Relative Column and Absolute Row BS28)