Working with Advanced Functions The Applicants sheet provides data about a number of applicants who are applying for different graduate programs. Go to Applicants worksheet, in column G, add a title Decision. In the range G2:G16, use appropriate function(s) to show Accepted for all 1 applicants who have a GPA that is greater than or equal to 2.75 and an English Test Score that is greater than or equal to 6, show Rejected for the rest. In column H, add a title Discount. Using the lookup table Fees Discount, display 2 the Discount Amount for each applicant in the range H2:H16. In column J, add a title Additional Fees, In the range J2:J16 use appropriate function(s) to show the following: 3 Applicants graduated between 2010 and 2015 will pay Additional Fees = 500. Applicants graduated between 2016 and 2018 will pay Additional Fees = 250. Applicants graduated between 2019 and 2021 will pay Additional Fees = 150. 4 In the range M13:M15, use appropriate function(s) to count the number of applicants for each program. In the range N13:N15, use appropriate function(s) to calculate the average GPA of applicants for each program. 5 Name GPA Program Fees Discount 3.79 2.62 GPA 0.00 2.75 295 325 3750 Discount Amount 0% 20% 30% 40% 50% . Applicant ID 299087 2000878 2000870 2990880 2990881 2920882 2900883 2990884 2990885 2090880 2000087 2990888 2990880 2000000 2990891 English Test Score 6 55 6 6 6 6 75 7 65 65 5 5 6.5 6 6.5 A San Ahmed Mustafa Lala Hussain Sara Hamad Omar Abdul Waleed Turki Hanan Yousef Yahya Mohammed Hamza Sufian Samal Dana Khaled Huta Rami New Majd Ibrahim Ahmed Abdullah Al 3.75 Graduation Year 2019 2020 2018 2020 2019 2010 2016 2019 2020 2018 2010 2000 2010 2011 2020 70 388 289 2.44 2.51 201 3.55 2.12 2.44 2.67 265 3.11 201 2.78 MBA MCS MCS MBA MSE MSE MCS MBA MBA MCS MSE MSE MCS MCS MBA 4.00 100% Statistics Number of Applicants Average GPA Program MCS MSE Question paper Working with Advanced Functions The Applicants sheet provides data about a number of applicants who are applying for different graduate programs Go to Applicants worksheet, in column G, add a title Decision. In the range G2:G16, use appropriate function(s) to show Accepted for all 1 applicants who have a GPA that is greater than or equal to 2.75 and an English Test Score that is greater than or equal to 6, show Rejected for the rest. In column H, add a title Discount. Using the lookup table Fees Discount, display 2 the Discount Amount for each applicant in the range H2:H16. In column J, add a title Additional Fees, In the range J2:J16 use appropriate function(s) to show the following: 3 Applicants graduated between 2010 and 2015 will pay Additional Fees = 500. Applicants graduated between 2016 and 2018 will pay Additional Fees = 250. Applicants graduated between 2019 and 2021 will pay Additional Fees = 150. 4 In the range M13:M15, use appropriate function(s) to count the number of applicants for each program. In the range N13:N15, use appropriate function(s) to calculate the average GPA of applicants for each program. 5 Excell Name GPA Program Fees Discount Applicant ID 2990877 2990878 2990879 2900880 2990881 2990882 2900883 2990884 2990885 2990886 2990887 2990888 2990889 2990890 2990091 Al Sami Ahmed Mustafa Lala Hussain Sara Hamad Omar Abdulaziz Waleed Turki Hanan Yousef Yahya Mohammed Hamza Sufian Saw Tala Dana Khaled Huda Rami Nowa Majed Ibrahim Ahmed Abdullah Al 3.79 2.62 3.80 2.80 2.44 2.51 2.91 3.55 2.12 2.34 2.67 2.65 3.11 201 2.78 English Test Score 6 5.5 6 6 6 6 7.5 7 65 6.5 5 5 5.5 6 65 Graduation Year 2019 2020 2018 2020 2019 2010 2016 2019 2020 2018 2019 2020 2010 2011 2020 MBA MCS MCS MBA MSE MSE MCS MBA MRA GPA 0.00 2.75 2.95 325 3.50 3.75 4.00 Discount Amount 0% 20% 30% 40% 50% 70% 100% MCS Statistics Number of Applicants Average GPA MSE MSE MCS MCS MBA Program MBA MCS MSE