Calculate salary increase scenarios
100%
The increase rates sit in C1, D1 and E1. Each employee has a current salary in column B, so every result is salary multiplied by one plus its scenario rate.
When you copy a formula down, the salary row must move but the rate cell must stay fixed. Dollar signs lock the rate address, so $C$1 still points to the 20% rate on every row.
In C2, apply the rise in B1 to each salary, and fill down to C6.
The grid for this exercise needs a free profile.
Everything above is yours to read either way. 19 exercises stay open with no profile at all.
Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz (MIT).