uses. Unless you need to edit, it's safer to stay in Protected View. PROJECT STEPS Lael Masterson works in the Student Activities Office at Valerian State College in Illinois. Lael has started compiling information on students who are interested in helping run student organizations at Valerian State, and she needs your help completing the workbook. 1. 2. 3. Switch to the Student Representatives worksheet. In cell E2, enter a formula using the HLOOKUP function as follows to determine a student's potential base hourly rate (which is based on the number of years of post-secondary education): Enable Editing a. Use a structured reference to look up the value in the Post-Secondary Years column. Retrieve the value in the 2nd row of the table in the range P13: U14, using an absolute reference. Because base hourly rate is tiered based on the number of years of education, find an approximate match. Fill the formula into the range E3:E31, if necessary. b. Student organizations sometimes require transportation for off-campus activities, and school policy requires students to be over 23 years old to serve as transport. Lael wants to determine how many of the active students will be eligible to transport other group members. In cell J2, enter a formula using the IF function and structured references as follows to determine if Kay Colbert can serve as authorized transport: a. The function should use a reference to the Age column to determine if the student's age is greater than 23, and should return the text Yes if true and No if false. b. Fill the formula into the range J3:331, if necessary. To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post-secondary education or have gone through the organization finance training. a. In cell K2 enter a formula using the IF and OR functions and structured references as follows to determine if Kay Colbert can join the leadership training program: The IF function should determine if the student's Post-Secondary Years is greater than or equal to 2 OR if the student's finance certified status is "Yes", returning
uses. Unless you need to edit, it's safer to stay in Protected View. PROJECT STEPS Lael Masterson works in the Student Activities Office at Valerian State College in Illinois. Lael has started compiling information on students who are interested in helping run student organizations at Valerian State, and she needs your help completing the workbook. 1. 2. 3. Switch to the Student Representatives worksheet. In cell E2, enter a formula using the HLOOKUP function as follows to determine a student's potential base hourly rate (which is based on the number of years of post-secondary education): Enable Editing a. Use a structured reference to look up the value in the Post-Secondary Years column. Retrieve the value in the 2nd row of the table in the range P13: U14, using an absolute reference. Because base hourly rate is tiered based on the number of years of education, find an approximate match. Fill the formula into the range E3:E31, if necessary. b. Student organizations sometimes require transportation for off-campus activities, and school policy requires students to be over 23 years old to serve as transport. Lael wants to determine how many of the active students will be eligible to transport other group members. In cell J2, enter a formula using the IF function and structured references as follows to determine if Kay Colbert can serve as authorized transport: a. The function should use a reference to the Age column to determine if the student's age is greater than 23, and should return the text Yes if true and No if false. b. Fill the formula into the range J3:331, if necessary. To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post-secondary education or have gone through the organization finance training. a. In cell K2 enter a formula using the IF and OR functions and structured references as follows to determine if Kay Colbert can join the leadership training program: The IF function should determine if the student's Post-Secondary Years is greater than or equal to 2 OR if the student's finance certified status is "Yes", returning
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
I need help to do those questions of Excel and provide the work as shown.
Transcribed Image Text:File
References Mailings Review View Help
Home Insert Draw Design Layout
PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
PROJECT STEPS
1.
2.
3.
Lael Masterson works in the Student Activities Office at Valerian State College in Illinois.
Lael has started compiling information on students who are interested in helping run
student organizations at Valerian State, and she needs your help completing the
workbook.
Switch to the Student Representatives worksheet. In cell E2, enter a formula using the
HLOOKUP function as follows to determine a student's potential base hourly rate (which
is based on the number of years of post-secondary education):
a.
b.
Enable Editing
a.
Student organizations sometimes require transportation for off-campus activities, and
school policy requires students to be over 23 years old to serve as transport.
Lael wants to determine how many of the active students will be eligible to transport
other group members. In cell J2, enter a formula using the IF function and structured
references as follows to determine if Kay Colbert can serve as authorized transport:
Use a structured reference to look up the value in the Post-Secondary Years
column. Retrieve the value in the 2nd row of the table in the range P13: U14,
using an absolute reference. Because base hourly rate is tiered based on the
number of years of education, find an approximate match.
Fill the formula into the range E3:E31, if necessary.
a.
The function should use a reference to the Age column to determine if the
student's age is greater than 23, and should return the text Yes if true and No if
false.
b.
Fill the formula into the range J3:031, if necessary.
To be eligible for the leadership training program offered by the office, a student must
have at least 2 years of post-secondary education or have gone through the organization
finance training.
In cell K2 enter a formula using the IF and OR functions and structured references as
follows to determine if Kay Colbert can join the leadership training program:
The IF function should determine if the student's Post-Secondary Years is greater
than or equal to 2 OR if the student's finance certified status is "Yes", returning
Transcribed Image Text:File
1
2
5.
e
2.
Q5
3
S
7
8
9
10
M
11
12
13
Undo
14
15
17
18
19
20
21
30
22 ne
23
24
25
XX
26 n
27
28 a
29
31
33
34
-Ag-Post-Secondary
Post-Secondary
35
36
37
38
39
40
41
C
42
43
44
45
46
47
48
49
Home Insert Draw Page Layout
X
LA -
24
25
21
22
19
24
20
18
24
21
23
18
Ready
19
21
26
22
22
20
Paste
21
19
24
18
25
24
18
23
19
29
19
25
▸
Clipboard
vix ✓ fx
D
E
F
G
Base R.- Clas- Finance Certif
Base R:
6
?
3
4
2
6
10
0
6
3
5
0
1
3
8
4
4
2
3
1
2
0
Calibri
5
6
0
5
1
9
1
7
BIU-
Documentation
Accessibility: Investigate
2024 No
2025 Yes
2022 Yes
Ver
2026 No
2025 Yes
2022 No
Font
2023 Yes
2024 No
0000
2026 Y
11
H
Cla Finance Certif Grad Qualified
2022 Yes
Yes
2023 Yes
2022 Yes
2023 Yes
2023 Yes
2023 Y
2025 Yo
2022 Yes
2022 Yes
2026 No
2022 Yes
2025 Y
2024 No
2023 Yes
2022 Yer
2025 No
2023 Y
2023 Yes
2023 Yes
2022 No
2023 Yes
Formulas Data Review View Help
A A
A
Y
Yes
No
No
No
Yes
Yes
No
Yes
No
No
No
No
No
You
No
No
No
No
Fy
No
No
Ne
Yes
Yes
No
No
No
Yas
No
Yes
No
Yes
Yes
No
You
No
No
Ne
Yes
No
No
No
No
No
No
No
Yes
No
No
Yos
Yas
No
wo
==
E 三三三五五
Yes
No
No
Yes
1₂
No
No
Yes
Alignment
Wrap Text
Merge & Center
N
Fete -- Leadership Trair Mento-Officer Qualif Col
Student Representatives Academic Groups Academic Pivot Table
v
M
Fy
General
$%908 498
Number
0
P
Student ID
Student Name
Elected Students
All Students
Ty
Postsecondary Years
Base Rate
All Groups All Groups Pivot
A
Lo
Conditional Format as Cell
Formatting Table Styles
Styles
G62918
Kay Colbert
Total Students Average Post-Secondary Yea
+
30
0
R
◄
S
15.25 15.75
m
Sodd LIX
Insert Delete Format
T
Cells
U
5
8
16.5 17.5
T
V
W
Σ Autosum
Σ
Fill -
Clear
X
Y
Y
28
Sort &
Filter
Editing
Z
AA
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 2 steps with 3 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman