Is my math correct to find the solutions, and if so is my answers correct? Also, why is N/A popping up for one of my solutions in the top photo underneath "Population 2020" in question 1?

1.

Questions 1. Calculate each state's percentage population increase from 2010 to 2020 in Column D 2. Use conditional formatting to color code the median age of each state 3. Use VLOOKUP to find the the population of each state (2020) in column J State Population 2020 Population 2010 Population Change% State |Median ag * Population 202( Utah 3,271,616 2,763,885 84% =C7/B7 Alabama 39.5 #N/A I=VLOOKUP(H7,$H$60:$1$109,2, TRUE) Idaho 1,839, 106 1,567,582 85% =C8/B8 Alaska 35.3 29,145,505 35 =VLOOKUP(H8,$H$60:$1$109,2, TRUE) Texas 25, 145,561 86% =C9/B9 Arizona 38.5 35 =VLOOKUP(H9,$H$60:$1$109,2, TRUE) North Dakota 779,094 672,591 86% =C10/B10 Arkansas 38.6 35 =VLOOKUP(H10,$H$60:$1$109,2, TRUE) Nevada 3,104,614 2,700,551 87% =C11/B11 California 37.3 35 =VLOOKUP(H11,$H$60:$1$109,2, TRUE) Colorado 5,773,714 5,029, 196 87% =C12/B12 Colorado 37.3 35 =VLOOKUP(H12,$H$60:$1$109,2, TRUE) Washington ,705,281 6,724,540 87% =C13/B13 Connecticut 41.2 35 =VLOOKUP(H13,$H$60:$1$109,2, TRUE) Florida 21,538, 187 8,801,310 87% =C14/B14 Delaware 41.4 35 =VLOOKUP(H14,$H$60:$1$109,2, TRUE) Arizona .151,502 6,392,017 89% =C15/B15 Florida 42.7 35 =VLOOKUP(H15,$H$60:$1$109,2, TRUE) South Carolina ,118,425 4,625,364 90% =C16/B16 Georgia 37.3 35 =VLOOKUP(H16,$H$60:$1$109,2, TRUE) Oregon 4,237,256 3,831,074 90% =C17/B17 Hawaii 40 35 =VLOOKUP(H17,$H$60:$1$109,2, TRUE) Georgia 0,711,908 9,687,653 90% =C18/B18 Idaho 37.2 35 =VLOOKUP(H18,$H$60:$1$109,2, TRUE) Delaware 989,948 897,934 91% =C19/B19 Illinois 38.8 39 =VLOOKUP(H19,$H$60:$1$109,2, TRUE) Montana ,084,225 989,415 91% =C20/B20 Indiana 38 39 =VLOOKUP(H20,$H$60:$1$109,2, TRUE) North Carolina 0,439,388 ,535,483 91% =C21/B21 lowa 18.6 39 =VLOOKUP(H21,$H$60:$1$109,2, TRUE) South Dakota 886,667 814, 180 2% =C22/B22 Kansas 37.3 39 =VLOOKUP(H22,$H$60:$1$109,2, TRUE) Tennessee 5,910,840 6,346,105 92% =C23/B23 Kentucky 39.2 39 =VLOOKUP(H23,$H$60:$1$109,2, TRUE) Virginia ,631,393 8,001,024 93% =C24/B24 Louisiana 37.8 39 =VLOOKUP(H24,$H$60:$1$109,2, TRUE) Minnesota 5,706,494 5,303,925 93% =C25/B25 Maine 45 39 =VLOOKUP(H25,$H$60:$1$109,2, TRUE) Nebraska 1,961,504 1,826,341 93% =C26/B26 Maryland 39.2 39 =VLOOKUP(H26,$H$60:$1$109,2, TRUE) Massachusetts ,029,917 6,547,629 93% =C27/B27 Massachusetts 39.7 39 =VLOOKUP(H27,$H$60:$1$109,2, TRUE) Maryland 5,177,224 5,773,552 93% =C28/B28 Michigan 40.1 10 =VLOOKUP(H28,$H$60:$1$109,2, TRUE) Hawaii 1,455,271 1,360,301 93% =C29/B29 Minnesota 38.5 43 =VLOOKUP(H29,$H$60:$1$109,2, TRUE) California 9,538,223 37,253,956 94% =C30/B30 Mississippi 38.3 43 =VLOOKUP(H30,$H$60:$1$109,2, TRUE) New Jersey ,288,994 8,791,894 95% =C31/B31 Missouri 39.1 43 =VLOOKUP(H31,$H$60:$1$109,2, TRUE) Oklahoma ,959,353 3,751,351 95% =C32/B32 Montana 10.2 43 =VLOOKUP(H32,$H$60:$1$109,2, TRUE) Alabama 5,024,279 4,779,736 95% =C33/B33 Nebraska 36.9 43 =VLOOKUP(H33,$H$60:$1$109,2, TRUE) ow 3,190,369 3,046,355 95% =C34/B34 Nevada 38.5 43 =VLOOKUP(H34,$H$60:$1$109,2, TRUE) Indiana ,785,528 6,483,802 96% =C35/B35 New Hampshire 43.1 43 =VLOOKUP(H35,$H$60:$1$109,2, TRUE) New Hampshire 1,377,529 1,316,470 96% =C36/B36 New Jersey 10.2 43 =VLOOKUP(H36,$H$60:$1$109,2, TRUE) Rhode Island ,097,379 1,052,567 96% =C37/B37 New Mexico 38.6 43 =VLOOKUP(H37,$H$60:$1$109,2, TRUE) New York 20,201,249 19,378, 102 96% =C38/B38 New York 39.4 43 =VLOOKUP(H38,$H$60:$1$109,2, TRUE) Kentucky 4,505,836 4,339,367 96% =C39/B39 North Carolina 39.2 13 =VLOOKUP(H39,$H$60:$1$109,2, TRUE) Wisconsin 5,893,718 5,686,986 96% =C40/B40 North Dakota 35.4 43 =VLOOKUP(H40,$H$60:$1$109,2, TRUE) Arkansas 3,011,524 2,915,918 97% =C41/B41 Ohio 39.6 43 =VLOOKUP(H41,$H$60:$1$109,2, TRUE) Alaska 733,391 710,231 97% =C42/B42 Oklahoma 37.1 43 =VLOOKUP(H42,$H$60:$1$109,2, TRUE) Kansas 2,937,880 2,853,1 18 97% =C43/B43 Oregon 39.9 43 =VLOOKUP(H43,$H$60:$1$109,2, TRUE) New Mexico 2,117,522 2,059, 179 97% =C44/B44 Pennsylvani 10.9 43 =VLOOKUP(H44,$H$60:$1$109,2, TRUE) Missouri 6, 154,913 5,988,927 97% =C45/B45 Rhode Island 10.3 43 =VLOOKUP(H45, $H$60:$1$109,2, TRUE) Vermon 643,077 625,741 97% =C46/B46 South Carolina 10.1 43 =VLOOKUP(H46,$H$60:$1$109,2, TRUE) Louisiana ,657,757 ,533,372 97% =C47/B47 South Dakota 37.6 43 =VLOOKUP(H47,$H$60:$1$109,2, TRUE) Maine 1,362,359 ,328,361 98% =C48/B48 Tennessee 39.1 13 =VLOOKUP(H48,$H$60:$1$109,2, TRUE) Pennsylvania 3,002,700 2,702,379 98% =C49/B49 Texas 35.2 43 =VLOOKUP(H49,$H$60:$1$109,2, TRUE) Wyoming 576,851 563,626 98% =C50/B50 Utah 31.5 43 =VLOOKUP(H50, $H$60:$1$109,2, TRUE) Ohio 1,799,448 1,536,504 98% =C51/B51 Vermont 43 43 =VLOOKUP(H51,$H$60:$1$109,2, TRUE) Michigan 0,077,331 9,883,640 98% =C52/B52 Virginia 38.7 45 =VLOOKUP(H52, $H$60:$1$109,2, TRUE) Connecticut 3,605,944 3,574,097 99% =C53/B53 Washington $7.9 45 =VLOOKUP(H53,$H$60:$1$109,2, TRUE) Illinois 2,812,508 2,830,632 00% =C54/B54 West Virginia 43 45 =VLOOKUP(H54,$H$60:$1$109,2, TRUE) Mississippi 2,961,279 2,967,297 00% =C55/B55 Wisconsin 40 45 =VLOOKUP(H55, $H$60:$1$109,2, TRUE) West Virginia ,793,716 ,852,994 03% =C56/B56 Wyoming 38.7 15 =VLOOKUP(H56, $H$60:$1$109,2, TRUE)E27 @ fx (Use "Index" to refer to the row and column number in columns C and D) A B C D E F G H K L M N O 1 Question 2 The table on top records the performance of a salesperson in (thousand dollars) by year and month. 3 Use MATCH to find the year index for the "Year" in cell B20, and use INDEX to find the salesperson's performance during specified month in the highlighted box Month Year 2 3 4 5 6 7 8 9 10 11 12 2011 $ 106.9 $ 117.3 $ 101.7 $ 114.2 $ 144.5 $ 143.7 $ 117.7 $ 124.9 $ 125.0 $ 106.8 $ 133.6 $ 126.8 (0 00 2012 $ 116.9 $ 147.9 $ 123.0 $ 123.3 $ 101.2 $ 102.0 $ 106.6 $ 122.6 $ 113.7 $ 124.8 $ 111.4 $ 121.5 2013 $ 123.0 $ 111.7 $ 115.2 $ 123.9 $ 134.2 $ 126.4 $ 123.6 $ 102.5 |$ 128.5 $ $ 126.4 $ 128.6 $ 142.5 10 2014 $ 146.6 $ 146.5 $ 1 14.5 $ 106.8 $ 102.3 $ 140.9 $ 125.8 $ 109.9 $ 137.2 $ 105.4 $ 142.3 $ 102.3 2015 $ 123.2 $ 124.3 $ 127.5 $ 145.2 $ 108.3 $ 111.0 $ 144.4 $ 129.2 $ 137.2 $ 131.9 $ 105.7 $ 120.0 INE 2016 $ 108.1 $ 122.4 $ 147.2 $ 136.2 $ 124.5 $ 144.8 $ 131.3 $ 128.4 $ 103.7 $ 110.7 $ 101.5 $ 141.7 13 2017 $ 145.4 $ 125.7 $ 111.7 $ 143.8 $ 133.7 $ 148.6 $ 139.6 $ 146.2 $ 134.9 $ 113.8 $ 137.1 $ 110.9 14 2018 $ 118.7 $ 134.3 $ 128.3 $ 1 121.7 $ 143.5 $ 148.8 $ 105.5 $ 132.3 $ 111.0 $ 147.8 $ 123.9 $ 102.5 15 2019 $ 137.1 $ 123.3 $ 123.8 $ 137.8 $ 109.8 $ 100.3 $ 131.4 $ 120.5 $ 124.6 $ 112.3 $ 107.0 $ 139.8 16 2020 $ 101.9 $ 107.3 $ 109.6 $ 110.7 $ 114.4 $ 117.2 $ 122.1 $ 116.3 $ 109.1 $ 100.1 $ 107.4 $ 127.7 17 18 19 Year Year Index Month Sales 20 2012 2 2 147.9 =INDEX($C$7:$N$16,C20,C20) 21 2020 10 12 100. =INDEX($C$7:$N$16,C21,C21) 22 2016 6 7 144.8 =INDEX($C$7:$N$16,C22,C22) 23 2013 3 3 1 15.2 =INDEX($C$7:$N$16,C23,C23) 24 2020 10 12 100. =INDEX($C$7:$N$16,C24,C24) 25 2020 10 12 100.1 =INDEX($C$7:$N$16,C25,C25) 26 2012 2 147.9 =INDEX($C$7:$N$16,C26, C26) 27 Use "Match" for above) o refer to the row and column humber in columns C and D)\f