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. X Open spreadsheet Relative Cell References We can tell from this table that there are 8 orders for the MP3 album and that value is in cell C2. Next, we would like to calculate the Total Cost for all MP3 orders. To do that we would multiply the Order Quantity by the Unit Cost; 811.99. That can be done in cell E2. Finally, we can select cell E2, grab the drag handle, and then drag down to E4 to obtain the other two Total Cost values. This technique uses relative cell references, meaning the values can change as you drag downward. 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, In row 13, we would like to calculate the value of Investment A over a period of ten years assuming the constant growth rate in cell B13. First, calculate the value in Year 1 (D13) using the same technique in Part A. 10. Enter those values below (to the nearest dollar). Do not use a dollar sign (\$), just the value. 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. In row 13, we would like to calculate the value of Investment A over a period of ten years assuming the constant growth rate in cell B13. First, calculate the value in Year 1 (D13) using the same technique in Part A. 10. Enter those values below (to the nearest dollar). Do not use a dollar sign (\$), just the value. \begin{tabular}{cccccccccc} Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 & Year 8 & Year 9 & Year 10 \\ \hline$ & $ & $ & $ & $ & $ & $ & $ & $ & $ \end{tabular} Fixed Column / Relative Row Cell References Now you would like to track the value of all three investments over the same 10-year period in rows 22, 23, and 24. Start by creating a formula in D22 that is like the formula in D13. However, there is one change to make. Investment A:$ (to the nearest dollar) Investment B:$ (to the nearest dollar) Investment C: $ (to the nearest dollar) Check My Work Reset