Question: a . In cell C 7 , create a formula without using a function that multiplies the sales projection for the first year ( cell
a In cell create a formula without using a function that multiplies the sales projection for the first year cell C by the first growth rate cell C and adds the sales projection for the first year cell C to the result to determine the first estimate for
b Use an absolute reference to row in the reference to cell C
c Copy the formula from cell to the range : and then copy the formulas from the range : to the range : to complete the table of projections.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
