Question

Task Instructions X Enter a formula in cell C5 that divides the value in cell B5 by the value in cell B15, using an absolute cell reference to cell B15.

Answer 1

This ones pretty simple! :)

To divide the value in cell B5 by the value in cell B15 using an absolute cell reference to cell B15, you can enter the following formula in cell C5

=B5/$B$15

The dollar signs around the reference to cell B15 make it an absolute reference. This means that the reference won't change if the formula is copied to other cells.