Chapter A1, Problem 3PE

A new graduate has taken a job with an annual salary of $\$60,000.$ She expects her salary to go up by $2.5\%$ each year for the first five years. Her starting salary is stored in cell $\text{A4}$ of an Excel worksheet, and the salary increase rate is stored in cell $\text{B4}$. Construct a table with years $1$ through $5$ in cells $\text{A6:A10}$ and her salary in cells $\text{B6:B 10}\text{.}$ Write the formula for her salary in year $\text{2 }\left(\text{in cell B7}\right)$ that can be copied and pasted correctly in cells $\text{B8}$ through $\text{B10}\text{.}$