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!

File Home Insert Page Layout Formulas Data Review View Help Share Comments Gill Sans MT 11 A A Wrap Text Custom Insert 3X Delete Format 2 ( Paste BIU DA ES E Merge & Center $ % 820 Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity B9 X =SUM(B4:38) A B D E G H 1 J K L M N. I Front Range Action Sports Annual Net Sales 2 Quarter Quarter 2 Quarter 3 Quarter 4 Total Percent of Total Sales Trend $ 185,204,421 90,008,637 3 4 Colorado 5 New Mexico 6 Oregon 7 California 8 Washington 9 Total Sales 10 48,123,789 $ 25,783,516 35,658,498 58,123,789 42,143,258 209,832,850 $ 42,468,256 $ 21,985,365 34,689,526 64,468,256 46,598,456 210,209,859 $ 45,159,681 $ 19,987,269 37,986,369 65,159,681 44,874,332 213,167,332 $ 49,452,695 $ 22,252,487 39,456,899 68,452,695 50,546,222 230,160,998 $ 147,791,292 256,204,421 184,162,268 863,371,039 $ 12 13 14 15 16 17 Net Sales Seattle Inventory Denver Inventory Inventory Summary Annual Expenses Sales Reps (+ Average: 5345 348 416 Count: 5 Sum: 51 726 742 078 . 100%