On the year1 sheet in cell b8 enter a formula – On the Year1 sheet in cell B8, enter a formula to unlock a world of data manipulation and analysis….