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…

ernet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. 4. Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. In cell L2, enter a formula using the IF and AND functions and structured references as follows to determine if Kay Colbert is eligible to serve as a mentor: 6. The IF function should determine if the student's age is greater than or equal to 21 AND the student's post-secondary years are greater than or equal to 3, and should return the text Yes if a student meets both of those criteria or the text No if a student meets none or only one of those criteria. b. Fill the formula into the range L3:L31, if necessary. 5. Lael is always on the lookout for students who might be interested in running for office in student groups. 7. a. In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future: a. b. Otherwise, the formula should determine if the value in the Finance Certified column is equal to the text "Yes" and return the text Yes if true And No if false. Students who work with student organizations are also considered for employment at the Student Activities Office. Students with more than 4 years of post-secondary education are qualified for more complex Tier 2 jobs. In cell N1, enter the text Tier as the column heading. If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text. In cell N2, enter a formula using the IF function and structured references as follows to determine which work tier Kay Colbert is qualified for: a. The IF function should determine if the student's Post-Secondary Years is greater than or equal to 4, and return the value 2 if true or the value 1 if false.

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE