Lael Masterson works in the Student Activities Office at Valerian State College in Illinois. Lael has...

Free

90.2K

Verified Solution

Question

Programming

Lael Masterson works in the Student Activities Office atValerian State College in Illinois. Lael has started compilinginformation on students who are interested in helping run studentorganizations at Valerian State, and she needs your help completingthe workbook.
Switch to the Student Representatives worksheet. In cellE2, enter a formula using the HLOOKUP function asfollows to determine a student's potential base hourly rate (whichis based on the number of years of post-secondary education):

  1. Use a structured reference to look up the value in thePost-Secondary Years column. Retrieve the value in the2nd row of the table in the rangeP13:U14, using an absolute reference. Because basehourly rate is tiered based on the number of years of education,find an approximate match.
  2. Fill the formula into the range E3:E31, if necessary.

Answer & Explanation Solved by verified expert
3.9 Ratings (555 Votes)

a.

Student ID Name Age Post-Secondary Years Base Rate Class Finance Certified Grad Student Elected Qualified Driver Leadership Training Mentor Officer Qualified Tier
G62918 Kay Colbert 24 6 #REF! 2022 Yes Yes No Yes Yes Yes Yes 2 Student ID G62918
P49234 Michael Crozier 25 7 #REF! 2023 Yes Yes Yes Yes Yes Yes Elected 2 Student Name Kay Colbert
W99035 Brandon Miles 21 3 #REF! 2022 Yes No Yes No Yes Yes Elected 1
V42056 Michael Alvarez 22 4 #REF! 2023 Yes No No No Yes Yes Yes 2
T59828 Ida Smith 19 2 #REF! 2024 No No Yes No Yes No Elected 1
F72412 Betty Garza 24 6 #REF! 2025 Yes Yes No Yes Yes Yes Yes 2 Total Students Average Post-Secondary Years
W20999 Leroy Pirkle 28 10 #REF! 2022 Yes Yes No Yes Yes Yes Yes 2 Elected Students 11 4
Q18870 Warren Stewart 18 0 #REF! 2026 No No No No No No No 1 All Students 30 3.8
W75774 Stacy Wiggins 24 6 #REF! 2025 Yes Yes Yes Yes Yes Yes Elected 2
N25220 Billy Herald 21 3 #REF! 2022 No No No No Yes Yes No 1
O94361 Margaret Cruz 23 5 #REF! 2023 Yes No No Yes Yes Yes Yes 2
G87578 Chester Keese 18 0 #REF! 2024 No No No No No No No 1 Postsecondary Years 0 1 2 5 8
B68170 Claudette Littell 19 1 #REF! 2026 Yes No No No Yes No Yes 1 Base Rate 15 15.25 15.75 16.5 17.5
M89375 Florence Miller 21 3 #REF! 2023 Yes No No No Yes Yes Yes 1
S63900 Kimberly Gerace 26 8 #REF! 2023 Yes Yes No Yes Yes Yes Yes 2
Y96036 Roman Goble 22 4 #REF! 2025 Yes No No No Yes Yes Yes 2
C82505 Jocelyn Allen 22 4 #REF! 2022 Yes No Yes No Yes Yes Elected 2
Y75358 Ron Morse 20 2 #REF! 2022 Yes No No No Yes No Yes 1
J60811 Roberta Ervin 21 3 #REF! 2026 No No No No Yes Yes No 1
Q56783 James Rusnak 19 1 #REF! 2022 Yes No Yes No Yes No Elected 1
Q75281 Suzanne Lawrence 24 2 #REF! 2025 Yes No Yes Yes Yes No Elected 1
V73596 Shannon Garner 18 0 #REF! 2024 No No No No No No No 1
L86947 Emory Little 25 5 #REF! 2023 Yes Yes Yes Yes Yes Yes Elected 2
W90960 Laura L i 24 6 #REF! 2022 Yes Yes Yes Yes Yes Yes Elected 2
P40886 Floretta Cauthen 18 0 #REF! 2025 No No No No No No No 1
U88627 Beverly Berry 23 5 #REF! 2023 Yes No No Yes Yes Yes Yes 2
Y88831 Stephanie Papa 19 1 #REF! 2023 Yes No Yes No Yes No Elected 1
P83373 Wallace Rivera 29 9 #REF! 2023 Yes Yes No Yes Yes Yes Yes 2
B53454 Larry Russell 19 1 #REF! 2022 No No No No No No No 1
A60088 Aaron Sifford 25 7 #REF! 2023 Yes Yes Yes Yes Yes Yes Elected 2

b.HLOOKUP([@post-secontary years]),$p$13:$u$14,2,TRUE)


Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students