Please, i need help to solve it. How can i solve them.

Replicate the following spreadsheet GDP per capita & Fertility rate, total (births per woman) in United States GDP per capita & Fertility rate, total [births per woman) in United States wtry Name Here Sect Oy United States 20 2000 2001 2002 2003 2004 2005 GDP per capita 546,726.97 $44,728.60 $45,087,37 545,980:51 547,287.59 $48,499.81 Fertilitate total the perman 2.06 2.03 2.02 2.05 2.05 2.05 . Rules: Cell C4 must be a data validated field (list). Each country must appear only once in the list. The table in the range B8:D14 must be linked to the data validated field C4. That is when the country selected changes, the table should update. The numbers for GDP Per Capita should be retrieved from the worksheet "WDI" by using the function Sumifs. The numbers for Fertility Rate should be retrieved from the worksheet "WDI2" by using the Match and Offset() functions. The title in cell B2 must combine the text in C8, D8 and C4. It should reference these cells The graph should be a dual axis chart that displays GDP per capita as columns and the Fertility Rate as a line. Axis and Labels must match the screenshot The title of the graph should link to cell C4. When the C4 cell is selected a message box should appear to the right with your name (bold) and the message "Please Select a Country Changing the country in cell C4, should update the graph . B D E F G H 2005 1.807 A Country Australia Bolivia 3 Chile 5 China 6 Colombia 7 Denmark 8 Germany 9 Italy 10 Lithuania 11 Serbia 12 United States 13 14 2000 1.756 4.051 2.055 1.596 2.572 1.77 1.38 1.26 1.39 1.48 2.056 2001 1.739 3.969 2.009 1.597 2.516 1.74 1.35 1.25 1.29 1.58 2.0305 2002 1.756 3.885 1.972 1.6 2.458 1.72 1.34 1.27 1.23 1.57 2.0205 2003 1.748 3.798 1.943 1.604 2.395 1.76 1.34 1.29 1.26 2004 1.768 3.71 1.923 1.608 2.33 1.78 1.36 1.34 1.27 1.57 2.0515 3.621 1.909 1.612 2.263 1.8 1.34 1.34 1.29 1.45 2.057 1.59 2.0475 D E F B 1 Year CountryName GDP per capita (constant 2010 US$) 2 2000 United States 44726.9654 3 2001 Serbia 3581.974228 4 2003 Germany 38073.76067 5 2003 Colombia 5026.242155 6 2004 China 2467.132843 7 2005 Australia 48813.88776 8 2004 Bolivia 1657.505128 9 2001 Australia 44585.19852 10 2002 Bolivia 1606.904677 11 2000 Chile 9419.98295 12 2004 Lithuania 9614.082553 13 2002 Serbia 3840.397102 14 2003 Italy 36942.93938 15 2000 Italy 36329.24894 16 2002 Colombia 4908.730123 17 2000 Denmark 55850.63077 2925061022