Amelia wants to use a formula in Excel to estimate her sales for each month. She believes
Question:
Amelia wants to use a formula in Excel to estimate her sales for each month. She believes her sales for the next year will be about 7% higher than this year’s. She also has a big new ad campaign running late this year that she thinks will add another $5,000 to January sales. Which of the following is an appropriate Excel formula for Amelia’s January sales?
a. =(LastyearsalesA2*1.07)+5000
b. =(Lastyearsales+5000*1.07)
c. =LastyearsalesA2+5000*.07
d. =LastyearsalesA2*5000*1.07
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Question Posted: