I am a college student and I am trying to find out what is the proper answer for this question. I am not understanding the concept of formulas or how to use the proper formula... I just want to know where I could be directed that might help me understand this concept.
"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 A4 of an Excel worksheet, and the salary increase rate is stored in cell B4. Construct a table with years 1 through 5 in cells A6:A10 and her salary in cells B6:B10. Write the formula for her salary in year 2 (in cell B7) that can be copied and pasted correctly in cells B8 through B10."
is the question listed, can anyone give me advice on the answer??
