In an inventory spreadsheet, you copy a formula from cell B$2$ and paste it into cell D$9.$

What appears in cell D$10$ if the formula in B$2$ is $=$C$6+8?$

What if the formula is $=$$C$$6+8?$

What about $=$$C$6+8?$

And $=$C$$6+8?$

In Figure A$\mathrm{.}5,$ how would you calculate the percentages in cells C$6$ through C$9$ without referring to the total in cell B$10?$