I need help to do those questions which has been provided in Excel and please show how I can work on those. The image displays a spreadsheet from an educational context titled "Student Representatives." The spreadsheet contains several columns with the following headers:1. **Student ID**: Unique identifier for each student.2. **Name**: Name of the student.3. **Age**: Age of the student.4. **Post-Secondary Years**: Number of years the student has spent in post-secondary education.5. **Base Rate**: A numerical value associated with each student, possibly indicative of a rate or score.6. **Class**: Year or cohort the student is part of.7. **Finance Certified**: Indicates whether the student has a finance certification (Yes/No).8. **Grad Student**: Indicates if the student is a graduate student (Yes/No).9. **Elected**: Indicates if the student is elected as a representative (Yes/No).10. **Qualified Driver**: Indicates if the student is a qualified driver (Yes/No).11. **Leadership Training**: Indicates if the student has undergone leadership training (Yes/No).12. **Mentor**: Indicates if the student serves as a mentor (Yes/No).13. **Officer Qualified**: Indicates if the student is qualified for officer status (Yes/No).14. **Col**: Likely continuation of previous data or additional notes.On the right side, there is a summary table that includes:- **Student ID** and **Student Name** fields filled with "662918" and "Kay Colbirt."- **Elected Students Total**: A total of 30 students.- **Average Post-Secondary Years**: 0 post-secondary years but a base rate progression chart that states: - For 0 years: Base Rate = 15 - For 1 year: Base Rate = 15.75 - For 2 years: Base Rate = 15.75 - For 3 years: Base Rate = 16.5 - For 8 years: Base Rate = 17.5This structured information serves as a database for tracking representative students' qualifications and statuses across different metrics relevant to educational administration and student involvement. **Title: Using IF and AND Functions in Excel for Student Eligibility Criteria**---**4. Criteria for Student Mentors**Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. Follow these steps in Excel to determine eligibility:- **a.** Use the IF function to check if the student's age is greater than or equal to 21 **AND** their post-secondary years are greater than or equal to 3. Return "Yes" if both criteria are met, or "No" if one or none are met. - **b.** Apply the formula to the range L3:L31 as needed.---**5. Eligibility for Student Office**Lael evaluates students for potential interest in running for office in student groups. Here's how to determine eligibility:- **a.** In cell M2, use a nested IF function to check if the "Elected" column equals "Yes". The formula should then display "Elected". - **b.** Otherwise, determine if the "Finance Certified" column equals "Yes". Return "Yes" if true, and "No" if false.---**6. Employment with Student Organizations**Students with more than four years of post-secondary education can qualify for more complex Tier 2 jobs:- In cell N1, label the column "Tier".- In cell N2, use the IF function to check if post-secondary years are greater than or equal to 4. Return 2 if true, or 1 if false.---This guide provides a structured approach to using Excel functions for assessing student qualifications in various roles and opportunities.

The excel formulas are given below with explanation Also output screenshot is given taking the first 5 rows of the necessary columns as example=IF(AND(C2 >= 21,D2 >= 3),"Yes","No") Use this formula in cell L2 and drag up to L31 Explanation We are using AND to check 2 conditions, one for checking if C2 i.e. Age is at least 21 and for checking if D2 i.e. Post Secondary Years is at least 3 years. Then we are using IF to check if both the conditions are correct show Yes otherwise show No.=IF(I2="Yes","Elected",IF(G2="Yes","Yes","No")) Use this formula in cell M2 Explanation We are using the first IF condition to check if I2 i.e. Elected column values is "Yes". If it is Yes then we are showing Elected If it is No then we are using our second IF condition to check if G2 i.e. Finance Certified column is Yes. If it is Yes, we are showing Yes If it is No we are showing No=IF(D2 >= 4, 2, 1) Use this formulain cell N2 Explanation We are using IF to check if D2 i.e. Post Secondary Years is at least 4 years. If it is 4 years or more we are showing 2 otherwise we are showing 1