This question includes value-added by industry as a percentage of growth comparing to the previous quarter. Range
Question:
This question includes value-added by industry as a percentage of growth comparing to the previous quarter. Range B6:B26 demonstrates the growth percentages for the group of manufacturing goods in the first quarter of 2021, comparing to the fourth quarter of 2020.
Range C5:M5 includes estimated growth in value of manufacturing goods for each quarter through the fourth quarter of 2023, compared to the previous quarter.
Create one formula in cell C6 that calculates the overall percentage growth in value for durable goods relative to the last quarter of 2020. Since range C4:M4 includes just the estimate of growth, apply these percentages to all 21 groups. For example, the second quarter of 2021 is estimated to have 1.5% growth comparing to the first quarter. The formula in cell C6 increases the value of quarter 1 by 1.5%. Cell D6 increases the value of quarter 2 by 1.60% for quarter 3 and so on. Fill the range of C6:M26 with formulas to increase the values of each quarter relative to the previous quarter by numbers in row 5 of the same column.
You must type only ONE formula in cell C6. Use the fill handle to copy this formula and fill the entire range of C6:M26. What is the formula in cell C6?