Question: urgent and row intersect. Foc example, where column b intersects with row 4, the cell is labeled B4. You can think of a cell as



and row intersect. Foc 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 dota has been collected in the Nocrosoft Excel Ooline file below. Open the spreadsheet and perfocm the reovired analysis to answer the qutstions below. Open spreadsheet Relathe Cell References let's say you have this following simple isyout in Eucel: We can tell from this table that there are 8 arders for the Mp3 album and that value is in cell C2. you drag dswnward. those values below: Investiment A: : (to the nearest dollar) Investment 8 :(to the nearest doltar) thinestment C: (to the nearest doller) Absolute Cell References technique in Part A. then drag to the right to fill Year 2 theough Year 10. Enter those values below (to the nearest doltar). Do not ise a dollar sign (\$), just the value. Fuxed Column f metative how cell References is one change to make. What is the value of each investment in year 10 ? imestment A: 1 (to the nearest dollar) Ievestment B; 1 (Eo the nearest dollar) tinestment Cis (te the nearest folliar)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
