For growth i tried $($b$2+$c$2)*$$b$$14,$ b$2*$$b$$14,$ b$2/$c$2*$$b$$14,$b$2(1+$$b$$14)$ all is incorrect help on all three colum growth density and density growth plz Exercise

File Edit View Insert Format Data Tools Extensions Help

References everywhere!

In this chapter, you've explored the following concepts:

Relative references

Copying cells

Calculations with references

Absolute references

You'll put all of these concepts into practice to build a spreadsheet that highlights population metrics for each country for different growth rates. The cell references you'll use will ensure that the cell calculations will automatically update to any changes in the Growth Index $.$

Instructions

$100$XP

In D$2$:D$12,$ calculate the number of people the population will grow by $($the Growth$),$ assuming the growth index in B$14.$

In E$2$:E$12,$ calculate the population density in people per square kilometer.

In F$2$:F$12,$ calculate the Density Growth, which is the growth per square kilometer.

Change Growth Index to $2\mathrm{.}00\%,$ and watch as your spreadsheet automatically updates!

$(2)$

$($x$)$

Take Hint $(-30$ XP$)$

Incorrect

In cell D$2,$ did you use the absolute reference B$2?$

A$1,$AAx Country

$\backslash$table$[[,$A$,$B$,C,D,E,F,$G$,H,1,$J$],[1,$Country,Population,Land Area $($km$2),$Growth,Density $($km$2),$Density Growth,,,,$],[2,$China,$1,409,517,397,9,326,410,,,,,,,],[3,$India,$1,339,180,127,2,973,190,,,,,,,],[4,$United States,$324,459,463,9,147,593,,,,,,,],[5,$Indonesia,$263,991,379,1,811,569,,,,,,,],[6,$Brazil $.,209,288,278,8,460,415,,,,,,,],[7,$Pakistan,$197,015,955,881,912,,,,,,,],[8,$Nigeria,$190,886,311,910,768,,,,,,,],[9,$Bangladesh,$164,669,751,130,168,,,,,,,],[10,$Russia,$143,989,754,16,377,742,,,,,,,],[11,$Mexico,$129,163,276,1,943,945,,,,,,,],[12,$World,$7,550,262,101,148,940,000,,,,,,,],[13,,-,,,,,,,,],[14,$Growth Index,$1\mathrm{.}12\%,,,,$:$.,,,,],[15,$:$.,,,,,,,,,],[16,,5,,,,,,,,],[17,,,,,,,,,,],[18,,,,,,,,,,],[19,,,,,,,,,,],[20,,,,,+,,$a$,,,],[21,,,,,,,,,,],[22,,,,,,,,,,],[23,,,,,,,,,,],[24,,,,,,,,,,],[25,,,,,,,,,,],[26,,,,,,,,,,],[27,,,,,,,,,,],[28,,,,,,,,,,],[29,,,,,,,,,,],[30,,,,,,,,,,]]$

$+-=$ Sheet$1.$

$$