Complete the Simple 2019 column of the table: A) the simple population projection is based on the overall growth rate for the state. Multiply the 2018 for each county by one plus the state growth rate in cell d2. Use appropriate relative and absolute cell references as needed so that you can reuse the formula to complete the simple 2019 column.

A B D E F G H 1 2 State growth rate 1.5% 3 4 2017 County Growth Individual 2019 5 19681 2018 Simple 2019 19759 22610 6 22507 198453 7 201877 77036 8 76479 9 75712 474492 4023 76737 481857 10 11 4059 12 106900 42167 108987 42907 13 14 7590 7649 County Region Adams Count Southeast Asotin County Southeast Benton Count South Central Chelan Count North Central Clallam Count Peninsula Clark County Southwest Columbia Cou Southeast Cowlitz Count Southwest Douglas Coun North Central Ferry County Northeast Franklin Coun South Central Garfield Coun Southeast Grant County North Central Grays Harbor (Peninsula Island County North Puget Sound Jefferson Cou Peninsula King County North Puget Sound Kitsap County Peninsula Kittitas Count South Central Klickitat Coun South Central Lawic Count Count DucatCound 15 92117 16 2205 17 95821 18 72553 83285 94347 2247 97331 73901 84460 31729 2233163 269805 19 20 31191 21 2204229 22 266550 23 46157 21750 47364 22107 24 700 7CA