how do I do step 5

Clipboard Font Alignment Nurnber B16 X fe Female K Nim You aske 992 1420 Plea 1. In 2. Us 3. Us B D E G H 1 University of West Georgia Population Reports Year 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020 Total Average Increase Male 1322 1248 1147 1056 4 Freshmen Female 1101 1285 1299 1325 5 2439 Total 1st Year 2093 2607 2547 2472 2476 12195 6 7 Male 980 1004 1100 1041 961 8 Sophmore Female 1025 1158 1089 1058 998 9 2082.8 Total 2nd Year 2005 2162 2189 2099 1959 10414 10 11 Male 940 980 1014 1119 1050 12 Junior Female 1023 1098 1125 1180 1101 13 2126 Total 3rd Year 1963 2078 2139 2299 2151 10630 14 15 Male 901 975 998 975 923 16 Senior Female 980 995 1014 1041 1015 17 1963,4 Total 4th Year 1881 1970 2012 2016 1938 9817 18 19 Potential increase 0.075 20 in Students by 2025 35 Begin HERE Sheet1 Sheet2 Red 4. Me 5. Me ti 6. Bol Bo 7. For of 8. Add 9. The . K S T se L M N P R You are a student assistant for the admissions office. You have been asked to make this worksheet a little more easy to read and understand. Please complete the following: 1. In rows 5, 9, 13, and 17, total the number of students under each school year. Use a simple formula to determine each year. 2. Use a function in H5, H9, H13, and H17 determine the total number of students (M&F combined) for each of the five years. 3. Use a function under Column I, rows 5, 9, 13, and 17 to show the Average number of students for each group of students (M&F combined). 4. Merge and Center the title across the information. 5. Merge and Center the year classification (ex. Freshmen). You will just merge and center down the range of 3 rows instead of across the columns. 6. Bold the year classification (Freshmen, etc.) and other headings. Bold and italicize the cells that say Total 1st Year, Total 2nd Year, etc. 7. Format the cells so all information is visible. (You don't want part of a word or part of a group of years or numbers showing.) 8. Add a light fill color to each total row