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.
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.
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 2.11CP
Related questions
Question
100%
I need help to do those questions which has been provided in Excel and please show how I can work on those.
Transcribed Image Text:File Home Insert Draw
3
X
16-
e
Undo
L2
V42066
ST50828
1 Student ID Name
2 G62918
2 P49234
499035
7 72412
S W20999
90218800
70W75774
125220
V
094361
13 G87578
74 864170
15 M89375
15 56900
12 196086
18 (2505
79 V75358
20 IMI811
21 056783
27 009281
20 V73506
24 186917
25 W90960
26 P4
27 627
20 Y88831
29 PAR474
30853454
01 AGORE
32
33
31
125
36
30
39
41
42
Ready
Paste
▸
Clipboard
B
Kay Colbert
Michael Crozier
Brandon Miles
Michael Alvarez
Ida Smith
Betty Carza
Leroy Pirkle
Warren Stewart
Stacy Wiggins
Dilly Herald
only her and
Margaret Cruz
Chester Kees
ly
Gable
Roman Goble
Jocelyn Allen
Ree Morse
Claudette Littell
Florence Viller
Kimberly Gerace
Roberta Frin
James Rusnak
Suzanne Lawrence
ShannorGamer
Emory Linle
Laura U
Anir
Calibri
-Age
Florens Cauthen
Bewirly Perry
Stephanie Papa
Wallace Rivers
Larry Russell
Aaron Sifford
fx
C
BIU.
24
17
25
21
22
19
34
28
18
24
21
12
23
18
19
E
Post-Secondary Years Base Rate
21
20
31
21
22
20
21
19
7
24
18
25
34
18
23
19
20
19
25
Page Layout Formulas
A A
A
Documentation
Accessibility: Investigate
11
Font
D
6
7
3
4
2
F
h
10
0
G
3
1
0
1
3
a
4
4
2
3
1
2
0
S
6
D
5
1
9
Y
1
7
16.50
16.50
15.75
15.75
15.5
16.50
17 50
15.00
16.50
15.75
16 50
15.00
15.25
15.73
17.50
15.75
15.75
15,75
15.75
V
Data
F
Class Finance Certified
2022 Yes
2023 Yes
2022 Yes
15.25
16.50
===
2023 Yes
2024 No
2025 Yes
2022 Yes
2025 No
2025 Yes
2022 No
2023 Yes
3024 No
2026 Yes
2023 Yes
2018 Yer
2025 Yes
2035 Yes
2022 Yes
2022 Yes
2026 No
1012 Ye
2022 Yes
15.75
20125 Yes
15.00
2024 No
16.91 2023 Yes
16.50
2003 Yes
15.000
2025 No
2025 Yes
Review View Help
16.30
15.25 2023 Yes
17.50
21123 Yes
2022 No
2021 Yes
三五
H
Grad Student
Yes
Yes
No
No
No
Se
Alignment
Yes
Yes
No
Yes
No
No
No
No
No
Yes
No
No
No
No
No
No
No
Yes
Yes
No
No
No
Yes
No
Yes
Student Representatives Academic Groups
Wrap Text
Merge & Center
Table Design
T
No
No
No
Yes
No
No
No
No
No
No
No
Yes
No
No
Yes
Yes
No
Yes
Yes
No
No
Yes
No
No
Yes
Flected Qualified Driver
No
Yes
Yes
Yess
Yes
No
Yes
No
No
No
Yes
Yes
No
Yes
Na
No
No
No
No
No
Yes
No
No
No
Me
No
No
Yes
No
Yes
Yes
No
No
No
Va
Yes
V
No
Yes
F
General
$-%
Yes
Yes
Yes
Yes
No
Yes
Yes
No
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
NO
Yes
Yes
No
Yes
Yes
Yes
No
Yes
% 9
Academic PivotTable All Groups
Number
M
N
Leadership Training Mentor Officer Qualified Colu-
538 98
AB
112
-0
Conditional Format as Cell
Formatting Table Styles
Styles
All Groups Pivot1...
(+ ¡
M
◄
Ja
0
C
HX
HT
H+
Insert Delete Format
P
Student ID
Student Name
Elected Students
All Students
Postsecondary Years
Base Rate
Cells
Q
G62918
Kay Colbert
30
D
Σ Autosium
Fill
Clear
15
R
V
Total Students Average Post-Secondary Years
28
Sort & Find &
Filter Select
Editing
1
15.25
S
2
15.75
T
5
16.5
di
Analyze
Data
Analysis
U
8
17.5
Transcribed Image Text:File
Home
View Help
Insert Draw Design Layout References Mailings Review
PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
4.
5.
6.
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:
7.
a.
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.
Lael is always on the lookout for students who might be interested in running for office
in student groups.
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.
Enable Editing
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.
a.
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:
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L