Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am stuck on this part and can't find a video, please help Luke now wants to determine how many members of his staff will

I am stuck on this part and can't find a video, please help

Luke now wants to determine how many members of his staff will be eligible to be subject leaders.In cell J2, enter a formula using the IF function and a structured reference to determine if Alison Simoneau can be a subject leader.

a. The IF function should first determine if the staff member is a college graduate. Use a structured reference to the College Graduate column.

B. The function should return the text Yes if the staff members college graduate status is equal to Yes.

C. The function should return the text No if the staff member is not a college graduate.

THE BELOW IS A VISUAL ON WHERE I AM STUCK

image text in transcribed

Jr 2 AutoSum Logical - Lookup & Referencer a Detine Name A Recently used - A Text - O Math & Trig - E Use in Formula Insert Name unction Financial - O Date & Time" - More Functions Manager Create from Selection Function Library Defined Names XV fi =IF([College Graduate),"Yes", "No") O Trace Precedents A Show Formulas Trace Dependents Error Checking - Watch Calculation D K Remove Arrows & Evaluate Formula Window Options Formula Auditing Calculation Subject Leader Supervisor - Online Tuto Superviso Yes A 65 C D E F G Employee Name Service Years Pay Rate HR Training Years since College Academic ID Time YearHR Training Graduate Technology Training 2012 Alison Simoneau Yes $ - 2015 No 2007 Bert Tuma No $. 2017 Yes Yes 2027 Brooke Abalos Yes $ - 2016 No Yes 2024 Danilo Thedford No 16 $ - 2016 Yes 2009 Donna Dressler Yes 4 2017 Yes 2017 Elizabeth Pries Yes O 2017 No No 2010 Gary Zellers No $ - 2016 Yes No 2005 Glenn Delatorre Yes S. 2016 No No 2001 Jenette Forst No $. 2016 No No 2018 Karen Coyle No 2016 No Yes 2002 Ken Keith Yes $. 2016 Yes 2015 Kecio Mcleod 2016 Yes Yes 6 $ - #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! es" "No" Yes Yes Yes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance Services An Applied Approach

Authors: Iris Stuart

1st edition

73404004, 978-0073404004

More Books

Students also viewed these Accounting questions

Question

15.7 Explain the six steps in the termination interview

Answered: 1 week ago

Question

15.1 Define employee relations and employee engagement.

Answered: 1 week ago