Question

Project the sales for quarters 2, 3, and 4 for the second projection (range F9:I9) based on a growth trend using 1.02 as the step value.

a. F91.02, G91.02, H91.02, I91.02
b. F9+1.02, G9+1.02, H9+1.02, I9+1.02
c. F9/1.02, G9/1.02, H9/1.02, I9/1.02
d. F9-1.02, G9-1.02, H9-1.02, I9-1.02

Answer 1

To project the sales for quarters 2, 3, and 4 based on a growth trend using 1.02 as the step value, multiply each value in the range F9:I9 by 1.02.

Step-by-step explanation:

The correct answer is option a. F91.02, G91.02, H91.02, I91.02.

To project the sales for quarters 2, 3, and 4 based on a growth trend using 1.02 as the step value, we simply multiply each value in the range F9:I9 by 1.02. This is because a growth trend entails increasing the value by a certain percentage each time. By multiplying the values in the range F9:I9 by 1.02, we project the sales for the next three quarters based on a 2% growth rate.