Percent change formula is often used in Excel. For example, to calculate Monthly Change and Total Change.

**1a.** Select cell C3 and enter the formula shown below.

**1b.** Select cell C3 and apply a Percentage format.

We do not need to repeat Step 1a and Step 1b ten more times.

**1c.** Select cell C3, click the lower right corner of cell C3 and drag it towards cell C13.

**1d.** Check that everything is all right.

**2a.** Similarly, we can calculate the Total Value. This time we fix the reference to the B2 cell. Select cell D3 and enter the formula shown below.

**2b.** Select D3 cell and apply a Percentage format.

**2c.** Select the cell D3, click on the lower right corner of cell D3, and drag it towards cell D3.

**2d.** Check that everything is all right.

Explanations: the absolute reference ($B$2) remains the same when the formula is traversed downwards, with the mutual reference (B3) B4, B5, B6 and so on. It changes as. Perhaps this is a very advanced step for you. , But it shows you one of the many other powerful features Excel offers.