Click on the datafile logo to reference the data DATA file (a) The Course Average is calculated by weighting the Midterm and Final Score 50% each. Use VLOOKUP with the table shown to generate the course Grade for each student in cells E14 through E24 Complete the table below. Last name Course Grade AR D A Amoako C Apland F Bachman F > > Corder A Desi Dransman D Ouffuor B Finkel A Foster (b) Use the COUNTIS function to determine the number of students receiving each letter grade Course Grade No. of Students screenrec B C 1 D F 0 . A1 X OM 455 G D OM55 Section Courserading Scaleon Course Average Lower Upper Course L Grade o 59 69 D 70 19 89 A Course Grade Last Name 14 Amoako 11 Apland Bachman Corder 20 Des 21 Dransman 22 Duller 23 Finkel 24 Foster 25 F George 21 Gerson 20 Guing Geoer 30 Guerre 30 Hager Midterm Score 00 92 78 40 00 87 87 58 79 90 89 74 68 81 50 93 38 02 70 31 00 74 B3 B3 54 70 41 53 36 38 62 75 Course Average 605 905 780 570 545 920 790 680 845 040 900 755 775 775 610 935 715 750 815 910 3 bard Final Score 55 B8 74 43 07 71 78 90 96 91 77 87 74 54 100 75 981 84 91 57 91 91 95 88 84 76 31 93 4 80 81 74 78 88 02 SO 89 94 75 34 7 70 93 35 Hughes 36 Hochson 27 Jackson 3 Kar 39 Kick 40 Kern 41 Kamer 42 La Martin McGough Mick 62 54 64 64 34 825 070 100 360 770 585 670 895 910 740 780 715 700 710 630 770 065 885 640 75.5 935 770 000 RS 10 301 HO 5 Wocier 51 Muro Owen 03 Raider Rodgers Funch Schneider Schwang 2 con Show 14S 15 Stern Tretman S7V Wette 6 Weyer Why 1 Wars 00 73 47 40 12 79 LO 12 12 50 175 785 00 000 595 10 15 01 B7 Click on the datafile logo to reference the data DATA file (a) The Course Average is calculated by weighting the Midterm and Final Score 50% each. Use VLOOKUP with the table shown to generate the course Grade for each student in cells E14 through E24 Complete the table below. Last name Course Grade AR D A Amoako C Apland F Bachman F > > Corder A Desi Dransman D Ouffuor B Finkel A Foster (b) Use the COUNTIS function to determine the number of students receiving each letter grade Course Grade No. of Students screenrec B C 1 D F 0 . A1 X OM 455 G D OM55 Section Courserading Scaleon Course Average Lower Upper Course L Grade o 59 69 D 70 19 89 A Course Grade Last Name 14 Amoako 11 Apland Bachman Corder 20 Des 21 Dransman 22 Duller 23 Finkel 24 Foster 25 F George 21 Gerson 20 Guing Geoer 30 Guerre 30 Hager Midterm Score 00 92 78 40 00 87 87 58 79 90 89 74 68 81 50 93 38 02 70 31 00 74 B3 B3 54 70 41 53 36 38 62 75 Course Average 605 905 780 570 545 920 790 680 845 040 900 755 775 775 610 935 715 750 815 910 3 bard Final Score 55 B8 74 43 07 71 78 90 96 91 77 87 74 54 100 75 981 84 91 57 91 91 95 88 84 76 31 93 4 80 81 74 78 88 02 SO 89 94 75 34 7 70 93 35 Hughes 36 Hochson 27 Jackson 3 Kar 39 Kick 40 Kern 41 Kamer 42 La Martin McGough Mick 62 54 64 64 34 825 070 100 360 770 585 670 895 910 740 780 715 700 710 630 770 065 885 640 75.5 935 770 000 RS 10 301 HO 5 Wocier 51 Muro Owen 03 Raider Rodgers Funch Schneider Schwang 2 con Show 14S 15 Stern Tretman S7V Wette 6 Weyer Why 1 Wars 00 73 47 40 12 79 LO 12 12 50 175 785 00 000 595 10 15 01 B7