Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Colorado Total is of Total Sales, and then apply Percent Style with zero decimals. Fill the formula down through the range G5:G8.
I need help writing the formula for this question. Where do I type everything? Step by step instructions would be helpful as to where to type and what to press/click. Ignore the selected cells in the screenshot, please. Thank you!