Percentages and references

You can use cell references in any of the types of calculations that you saw in Chapter 1, including percentage calculations.

Using cell references means that you don't have to manually look up and enter values into each formula; you can instead use a cell reference to perform one calculation, then copy the reference to populate the remaining cells.

You're also not limited to using a single reference in a formula, you can perform calculations with multiple references as well, which you'll explore in this exercise.