Please help me grasp this concept.

%3CLINGO-SUB%20id%3D%22lingo-sub-2082478%22%20slang%3D%22en-US%22%3EPlease%20help%20me%20grasp%20this%20concept.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2082478%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20a%20college%20student%20and%20I%20am%20trying%20to%20find%20out%20what%20is%20the%20proper%20answer%20for%20this%20question.%20I%20am%20not%20understanding%20the%20concept%20of%20formulas%20or%20how%20to%20use%20the%20proper%20formula...%20I%20just%20want%20to%20know%20where%20I%20could%20be%20directed%20that%20might%20help%20me%20understand%20this%20concept.%3C%2FP%3E%3CP%3E%3CSPAN%3E%22A%20new%20graduate%20has%20taken%20a%20job%20with%20an%20annual%20salary%20of%3C%2FSPAN%3E%3CSPAN%20class%3D%22wbr%22%3E%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22nowrap%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%2460%2C000.%3C%2FSPAN%3E%3CSPAN%3E%20She%20expects%20her%20salary%20to%20go%20up%20by%3C%2FSPAN%3E%3CSPAN%20class%3D%22wbr%22%3E%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22nowrap%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E2.5%25%3C%2FSPAN%3E%3CSPAN%3E%20each%20year%20for%20the%20first%20five%20years.%20Her%20starting%20salary%20is%20stored%20in%20cell%20A4%20of%20an%20Excel%3C%2FSPAN%3E%3CSPAN%20class%3D%22wbr%22%3E%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22nowrap%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eworksheet%2C%3C%2FSPAN%3E%3CSPAN%3E%20and%20the%20salary%20increase%20rate%20is%20stored%20in%20cell%20B4.%20Construct%20a%20table%20with%20years%201%20through%205%20in%20cells%3C%2FSPAN%3E%3CSPAN%20class%3D%22wbr%22%3E%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22nowrap%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EA6%3AA10%3C%2FSPAN%3E%3CSPAN%3E%20and%20her%20salary%20in%20cells%3C%2FSPAN%3E%3CSPAN%20class%3D%22wbr%22%3E%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22nowrap%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EB6%3AB10.%3C%2FSPAN%3E%3CSPAN%3E%20Write%20the%20formula%20for%20her%20salary%20in%20year%202%3C%2FSPAN%3E%3CSPAN%20class%3D%22wbr%22%3E%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22nowrap%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E(in%3C%2FSPAN%3E%3CSPAN%3E%20cell%3C%2FSPAN%3E%3CSPAN%20class%3D%22wbr%22%3E%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22nowrap%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EB7)%3C%2FSPAN%3E%3CSPAN%3E%20that%20can%20be%20copied%20and%20pasted%20correctly%20in%20cells%20B8%20through%20B10.%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Eis%20the%20question%20listed%2C%20can%20anyone%20give%20me%20advice%20on%20the%20answer%3F%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2082478%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2083103%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20help%20me%20grasp%20this%20concept.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2083103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F937592%22%20target%3D%22_blank%22%3E%40Nljones2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20one%20year%2C%20the%20salary%20is%20A4%20*%20(100%25%2BB4)%3C%2FP%3E%0A%3CP%3EAfter%20two%20years%2C%20it%20is%20A4%20*%20(100%25%2BB4)%20*%20(100%25%2BB4)%2C%20or%20A4%20*%20(100%25%2BB4)%5E2%3C%2FP%3E%0A%3CP%3EEtc.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%20that%20give%20you%20something%20to%20start%20with%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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??

1 Reply

@Nljones2 

 

After one year, the salary is A4 * (100%+B4)

After two years, it is A4 * (100%+B4) * (100%+B4), or A4 * (100%+B4)^2

Etc.

 

Does that give you something to start with?