You're helping SunView College better understand their student base, how many of their students qualify for different types of scholarships, etc. In order to assist with their business understanding efforts, you will create an Excel spreadsheet that considers the rules for different scholarships and answers a number of questions relevant to SunView College. The first task is to create a spreadsheet that assesses the qualifications of twelve students. For each one of these students you have access to the following information:

• How often the student practices sports (weekly)
• The student's overall grade (0-100%)
• Whether the student is currently considering the analytics major (Yes/No)

SunView College provided you with the following rules:

• Is he/she an 'A' student? (TRUE/FALSE): overall grade equals to or greater than 94%;
• Qualify for sports scholarship? (YES/NO): practice sports at least three times per week and overall grade is at least 88%;
• Qualify for Analytics scholarship? (YES/NO): The student is currently considering the Analytics major (first condition). In addition, he/she practices sports at least 4 times per week or is an 'A' student (second condition).

Based on these rules, and using the Excel template available here Download Excel template available here, you need to complete the following tasks:

TASK 1: Update the Excel template to identify the "A" students (TRUE/FALSE) in column E. To address this task, use cell references and a function to automate the process (i.e, you should not type "True" or "False" in the relevant cells);

TASK 2: Update the template to identify which students qualify for a sports scholarship (YES/NO) in column F. To complete this task, you should use an IF function;

TASK 3: Update the template to identify which students qualify for the Analytics scholarship (YES/NO) in column G. To complete this task, you should use an IF function;

TASK 4: Update the template to enter the students' letter grades in column H. To complete this task, you should use a LOOKUP function that uses the information available in cell range G25:H31;

TASK 5: Update the template by answering the questions in cells A24:A27. Your answers should be provided in cells B24:B27. To answer these questions you should use COUNTIF and SUMIF functions.