7. [1/3 Points] DETAILS PREVIOUS ANSWERS MY NOTES ASK YOUR TEACHER B D Year Calendar 1 Code Year baleag redhaw 2 101 2000 89 1361 3 102 93 1880 4 103 120 1770 5 104 123 1444 6 105 151 1579 2 7 12 112 480 1745 8 113 424 1521 9 405 114 1289 1280 10 116 569 1288 11 117 546 1162 12 118 628 1118 13 You have downloaded data from the Audubon Society from the Christmas Bird Count and have imported it into Excel. You must create a plot of year vs bird count for Bald Eagle (baleag) and Red Tailed Hawk (redhaw) for the state of New Jersey between the years of 2000 and 2017. First, convert the Audubon Collection Year Code to calendar year. Which equation will accurately calculate the year in the active cell? OB =B$2+1 = 2000+(A3-A2) O =B1+2000 0 = 2000+(A3-$A$2) x