80.2K

Verified Solution

Link Copied!

Investment A : s (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 7ock down" either the row, column, or both so no change occurs when you dreg 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 orowth rate in cell B13. First, calculate the value in Year 1 (D13) using the same technique in Part A. If vou try to drag D13 to the right to fill in the remaining vears, you will get some very strange numbers! That is because the growth rate cell 813 is changing as you drag. Hewever, vou need that cell to say fixed in place for all the formulas as vou drag to fill E13 through M13. The way to fix cell B13 in place is using an absolute cell reference. Instead of B13 in the formula change it to ses 13 and then drag to the right to fill Year 2 through Year 10, Enter those values below (to the nearest dollar). Do not use a dollar sign ( $ ), Just the value. Finally, we can select cell E2, grab the drap 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 dowitward. In the given spreadiheet, three investments are listed in rows 4.6. Coluens B contains the expected orowth rate for each imvestment as a Dercentage. Calculate the expected value of investment A in cell D4 by miltiplying its value in Year 0 by the quantitv ( 1+ Growth rate). Then drag cell D4 down to Do to get the other two investment values after one vear given dafferent growth rates and place those values below: A Microsoft Excel spreadsheet is laid out in a grid of columns and rows. The columns are labeled with letters: A, B, C, while rows are labeled with numbers: 1,2,3 and so on. A cell is where a column and row intersect. For example, where column B intersects with row 4 , the cell is labeled 84 . You can think of a cell as an address on a map. The data has been collected in the Microsott Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Relative Cell References One of the most powerful features in Excel is the ability to place a formula in one cell and then drao the contents of that cell down or across. to repeat that same formula on other values, for example, les's say you have this following simple layout in Excel: We can tell from this table that there are B 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 Uni Cost: 8 11.99. That can be done in cell 52 . Now you would like to track the value of all thee investments over the same-10-year peried in rows 22,23 , and 24.5 tart by creating a formula in D22 that is like the formula in D13. However, there is one change to make. Knowing that you will want to drag the entire 10 year span in row 22 down to rows 23 and 24 , the row reference in the (1 + growth rate) calculation must be able to change as you drao. That is done by remeving the dollar sign ($) in front of the row number in the orowth calculation, Make sure that h done in cell 022 , then drag acress to M22 to obtain the values for Investment A. ninally, select all cells from D22 to M22, and then drag down to fill the next two rows. Now you have the values for thvestment 0 and Investment C. Notice the format of the formulas in cels 0221+424. What is the value of each investmern in vear 10 ? Investment A:S (to the nearest dollar) Investment 6: (to the nearest dollar) Investment C;s (to the nearest dollar) Investment A : s (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 7ock down" either the row, column, or both so no change occurs when you dreg 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 orowth rate in cell B13. First, calculate the value in Year 1 (D13) using the same technique in Part A. If vou try to drag D13 to the right to fill in the remaining vears, you will get some very strange numbers! That is because the growth rate cell 813 is changing as you drag. Hewever, vou need that cell to say fixed in place for all the formulas as vou drag to fill E13 through M13. The way to fix cell B13 in place is using an absolute cell reference. Instead of B13 in the formula change it to ses 13 and then drag to the right to fill Year 2 through Year 10, Enter those values below (to the nearest dollar). Do not use a dollar sign ( $ ), Just the value. Finally, we can select cell E2, grab the drap 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 dowitward. In the given spreadiheet, three investments are listed in rows 4.6. Coluens B contains the expected orowth rate for each imvestment as a Dercentage. Calculate the expected value of investment A in cell D4 by miltiplying its value in Year 0 by the quantitv ( 1+ Growth rate). Then drag cell D4 down to Do to get the other two investment values after one vear given dafferent growth rates and place those values below: A Microsoft Excel spreadsheet is laid out in a grid of columns and rows. The columns are labeled with letters: A, B, C, while rows are labeled with numbers: 1,2,3 and so on. A cell is where a column and row intersect. For example, where column B intersects with row 4 , the cell is labeled 84 . You can think of a cell as an address on a map. The data has been collected in the Microsott Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Relative Cell References One of the most powerful features in Excel is the ability to place a formula in one cell and then drao the contents of that cell down or across. to repeat that same formula on other values, for example, les's say you have this following simple layout in Excel: We can tell from this table that there are B 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 Uni Cost: 8 11.99. That can be done in cell 52 . Now you would like to track the value of all thee investments over the same-10-year peried in rows 22,23 , and 24.5 tart by creating a formula in D22 that is like the formula in D13. However, there is one change to make. Knowing that you will want to drag the entire 10 year span in row 22 down to rows 23 and 24 , the row reference in the (1 + growth rate) calculation must be able to change as you drao. That is done by remeving the dollar sign ($) in front of the row number in the orowth calculation, Make sure that h done in cell 022 , then drag acress to M22 to obtain the values for Investment A. ninally, select all cells from D22 to M22, and then drag down to fill the next two rows. Now you have the values for thvestment 0 and Investment C. Notice the format of the formulas in cels 0221+424. What is the value of each investmern in vear 10 ? Investment A:S (to the nearest dollar) Investment 6: (to the nearest dollar) Investment C;s (to the nearest dollar)

Answer & Explanation Solved by verified expert

See Answer