Last Name First Name UserID Test 1 Test 2 Test 3 Test 4 Average Grade Redfield...

Transcribed Image Text:

Last Name First Name UserID Test 1 Test 2 Test 3 Test 4 Average Grade Redfield Logan OGLD 94 89 91 90 94.73 A Goodwin Jon ONIN 97 90 87 93 94.68 A Verma Zaniyah 91 88 90 98 Ahmad Kalel 92 87 89 90 Jurecki Oaklee 83 85 97 80 Krueger Mohamed 85 79 94 82 Wood Tristian 88 96 79 79 McMillan Melvin 85 93 78 82 Waldrop Alma 85 86 100 70 Swaim Shruti 88 85 82 75 Shepherd Manuel 83 78 87 81 Taylor Gatlin 82 87 89 71 Wurz Alexandria 91 93 54 94 Baugh Winnie 80 90 65 91 Harry Melany 91 77 72 85 Jain Brandon 72 72 99 88 King Miles 92 90 74 68 Browne Emory 76 70 88 88 Govindappa Talon 86 79 68 88 Buquet Oscar 76 81 90 73 Corley Felix 73 84 91 72 Price Lian 81 78 83 77 Tao Paris 84 81 71 83 Robinson Lyric 81 83 81 73 Hensley Lauren 92 90 45 91 Cangelosi Yaretzi 90 73 63 90 Sturm Ariel 90 49 85 94 Bryant Hunter 92 88 46 90 Melton Atlas 85 83 80 66 Kimbrell Boston 93 90 79 54 Torres Serena 89 60 73 90 Morris Brandon 86 84 72 69 Schuhmacher Helena 89 78 72 71 Mathew Kinley 89 79 58 83 Aird Reign 88 80 53 85 User Ezra 93 93 74 47 Fernandez Rylie 71 75 84 73 Aziz John 78 64 86 74 1. Create UserID which consists of the 2nd and 3rd letter of the 1st name and the last 2 letters of the last name. 2. Find Average after a. adding 20% to the highest test score (but not going past 100) b. adding 10% to the lowest score 3. Assign grades Use Vlookup or IFS. 0 to <58: F; 58 to <69: D; 69 to < 77: C; 77 to < 86: B, Use proper Excel functions to be more efficient as on the test, You'll have very limited time to answer these questions. You'll not be able to sort or Filter or copy data to another Excel sheet. 86 or more: A Whitaker Ayleen 75 81 72 73 Canessa Edison 90 23 99 98 Shah Jaylin 83 60 78 78 Song Makenzie 87 82 84 46 Baer Leland 79 68 75 76 Naik Henrik 84 82 50 82 Jain Kamryn 89 73 48 86 Nwaekwe Dallas 94 89 44 72 Sandlin Angie 60 80 89 66 Garcia Addilyn 81 87 64 63 Singh Emory 87 79 56 73 Tsai Dilip 83 70 64 77 Chism Jakob 85 69 56 83 Mackey Creed 70 63 96 68 Rusek Justin 88 74 45 86 Mahapatra Cadence 74 74 71 73 Baqatyan Charli 96 82 40 78 Marchese Xander 84 81 45 81 Danalian Aditi 89 68 45 88 Zhu Estella 87 85 45 72 Vuga Bodie 96 95 67 35 White Zaiden 64 83 67 70 Yang Ayan 90 86 41 66 Robles Mustafa 79 92 40 72 Moran Maisie 95 73 51 66 Mandaogane Justice 89 80 49 62 Cole Harlem 60 64 88 67 Kaiser Sebastian 59 83 68 69 Michael Sasha 74 65 65 75 Alvarez Sekani 76 88 64 48 Fields Meadow 69 79 65 Mcbride Brecken 68 77 59 Bumber Phoenix 70 53 87 626 70 61 Darrow Maren 86 86 45 54 Yao Ahmed 72 84 42 70 Johnson Demetrius 64 69 62 73 Lloyd Graham 76 75 51 64 Braughton Daniela 76 86 46 56 Krider Estella 64 57 99 47 Jon-Ubabuco Casen 70 72 66 50 Chen Ryker 56 47 90 45 Okulate Ibrahim 26 87 56 69 Shurtleff Andrew 73 53 40 68 Antone Jayson 52 74 81 25 Lima Sahana 56 60 59 56 Xuan Lian 56 56 46 68 Hollister Cannon 53 48 85 36 Nolen Larry 59 45 46 61 Soppin Kaysen 56 53 42 54 Kaskas Pablo 47 27 98 34 Catral Rex 60 47 45 45 White Rajesh 54 29 74 32 Omana Clarissa 31 33 77 46 Koroma Clay 39 42 46 53 Glover Cassandra 46 30 98 0 Bradley Jesse 40 32 45 37 McCartt Brantley 25 29 59 27 QUESTION 2 For Set 1 data, what is the average score of RAIN? 5 points QUESTION 3 For Set 1 data, what is the average score of AREN? QUESTION 4 For Set 1 data, The grade of student with User ID ELEY is QUESTION 5 For Set 1 data, what is the average score of ELRY? Save Answer 5 points Save Answer 5 points Save Answer 5 points Save Answer QUESTION 6 For Set 1 data, What percentage got B or D? 5 points QUESTION 7 For Set 1 data, what is the class average? QUESTION 8 For Set 1 data,, what is the Average of the students whose UserID's do not start with letter L? Save Answer 5 points Save Answer 5 points Save Answer QUESTION 9 5 points Save Answer For Set 1 data, what is the Average of the students whose UserID's start with letter A? Last Name First Name UserID Test 1 Test 2 Test 3 Test 4 Average Grade Redfield Logan OGLD 94 89 91 90 94.73 A Goodwin Jon ONIN 97 90 87 93 94.68 A Verma Zaniyah 91 88 90 98 Ahmad Kalel 92 87 89 90 Jurecki Oaklee 83 85 97 80 Krueger Mohamed 85 79 94 82 Wood Tristian 88 96 79 79 McMillan Melvin 85 93 78 82 Waldrop Alma 85 86 100 70 Swaim Shruti 88 85 82 75 Shepherd Manuel 83 78 87 81 Taylor Gatlin 82 87 89 71 Wurz Alexandria 91 93 54 94 Baugh Winnie 80 90 65 91 Harry Melany 91 77 72 85 Jain Brandon 72 72 99 88 King Miles 92 90 74 68 Browne Emory 76 70 88 88 Govindappa Talon 86 79 68 88 Buquet Oscar 76 81 90 73 Corley Felix 73 84 91 72 Price Lian 81 78 83 77 Tao Paris 84 81 71 83 Robinson Lyric 81 83 81 73 Hensley Lauren 92 90 45 91 Cangelosi Yaretzi 90 73 63 90 Sturm Ariel 90 49 85 94 Bryant Hunter 92 88 46 90 Melton Atlas 85 83 80 66 Kimbrell Boston 93 90 79 54 Torres Serena 89 60 73 90 Morris Brandon 86 84 72 69 Schuhmacher Helena 89 78 72 71 Mathew Kinley 89 79 58 83 Aird Reign 88 80 53 85 User Ezra 93 93 74 47 Fernandez Rylie 71 75 84 73 Aziz John 78 64 86 74 1. Create UserID which consists of the 2nd and 3rd letter of the 1st name and the last 2 letters of the last name. 2. Find Average after a. adding 20% to the highest test score (but not going past 100) b. adding 10% to the lowest score 3. Assign grades Use Vlookup or IFS. 0 to <58: F; 58 to <69: D; 69 to < 77: C; 77 to < 86: B, Use proper Excel functions to be more efficient as on the test, You'll have very limited time to answer these questions. You'll not be able to sort or Filter or copy data to another Excel sheet. 86 or more: A Whitaker Ayleen 75 81 72 73 Canessa Edison 90 23 99 98 Shah Jaylin 83 60 78 78 Song Makenzie 87 82 84 46 Baer Leland 79 68 75 76 Naik Henrik 84 82 50 82 Jain Kamryn 89 73 48 86 Nwaekwe Dallas 94 89 44 72 Sandlin Angie 60 80 89 66 Garcia Addilyn 81 87 64 63 Singh Emory 87 79 56 73 Tsai Dilip 83 70 64 77 Chism Jakob 85 69 56 83 Mackey Creed 70 63 96 68 Rusek Justin 88 74 45 86 Mahapatra Cadence 74 74 71 73 Baqatyan Charli 96 82 40 78 Marchese Xander 84 81 45 81 Danalian Aditi 89 68 45 88 Zhu Estella 87 85 45 72 Vuga Bodie 96 95 67 35 White Zaiden 64 83 67 70 Yang Ayan 90 86 41 66 Robles Mustafa 79 92 40 72 Moran Maisie 95 73 51 66 Mandaogane Justice 89 80 49 62 Cole Harlem 60 64 88 67 Kaiser Sebastian 59 83 68 69 Michael Sasha 74 65 65 75 Alvarez Sekani 76 88 64 48 Fields Meadow 69 79 65 Mcbride Brecken 68 77 59 Bumber Phoenix 70 53 87 626 70 61 Darrow Maren 86 86 45 54 Yao Ahmed 72 84 42 70 Johnson Demetrius 64 69 62 73 Lloyd Graham 76 75 51 64 Braughton Daniela 76 86 46 56 Krider Estella 64 57 99 47 Jon-Ubabuco Casen 70 72 66 50 Chen Ryker 56 47 90 45 Okulate Ibrahim 26 87 56 69 Shurtleff Andrew 73 53 40 68 Antone Jayson 52 74 81 25 Lima Sahana 56 60 59 56 Xuan Lian 56 56 46 68 Hollister Cannon 53 48 85 36 Nolen Larry 59 45 46 61 Soppin Kaysen 56 53 42 54 Kaskas Pablo 47 27 98 34 Catral Rex 60 47 45 45 White Rajesh 54 29 74 32 Omana Clarissa 31 33 77 46 Koroma Clay 39 42 46 53 Glover Cassandra 46 30 98 0 Bradley Jesse 40 32 45 37 McCartt Brantley 25 29 59 27 QUESTION 2 For Set 1 data, what is the average score of RAIN? 5 points QUESTION 3 For Set 1 data, what is the average score of AREN? QUESTION 4 For Set 1 data, The grade of student with User ID ELEY is QUESTION 5 For Set 1 data, what is the average score of ELRY? Save Answer 5 points Save Answer 5 points Save Answer 5 points Save Answer QUESTION 6 For Set 1 data, What percentage got B or D? 5 points QUESTION 7 For Set 1 data, what is the class average? QUESTION 8 For Set 1 data,, what is the Average of the students whose UserID's do not start with letter L? Save Answer 5 points Save Answer 5 points Save Answer QUESTION 9 5 points Save Answer For Set 1 data, what is the Average of the students whose UserID's start with letter A?