"Start in column D, then move across, and multiply the preceding value by its growth rate in cell $B22 (which is 1 plus the percentage expected growth) to get the current value." "By changing the growth rate cell from $B$22, etc. to $B22, the row of the growth rate is allowed to change yet remain in column B while filling down to the other two Investments." example, where column B intersects with row 4 , the cell is labeled B4. You can think of a cell as an address on a map. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Relative Cell References following simple layout in Excel: We can tell from this table that there are 8 orders for the MP3 album and that value is in cell C2. Investment A:$ (to the nearest dollar) Investment B: \$ (to the nearest dollar) Investment C:$ (to the nearest dollar) Absolute Cell References By placing a dollar sign (\$) in front of the row and/or column of a cell you can "lock down" either the row, column, or both so no change occurs when you drag to fill other cells. 10. Enter those values below (to the nearest dollar). Do not use a dollar sign (\$), just the value. Fixed Column / Relative Row Cell References Investment A: $ (to the nearest dollar) Investment B: ? (to the nearest dollar) Investment C: ? (to the nearest dollar) Absolute Cell References By placing a dollar sign (\$) in front of the row and/or column of a cell you can "lock down" either the row, column, or both so no change occurs when you drag to fill other cells. 10. Enter those values below (to the nearest dollar). Do not use a dollar sign (\$), just the value. Fixed Column / Relative Row Cell References sign (\$) in front of the row number in the growth calculation. Make sure that is done in cell D22, then drag across to M22 to obtain the values for Investment A. each investment in year 10 ? Investment A: $ (to the nearest dollar) Investment B:q (to the nearest dollar) Investment C : (to the nearest dollar)