Question

11. In cell N2, enter a formula using the IF function and a structured reference to determine if Alison Simoneau is eligible for tuition remission.

a. The IF function should first determine if the staff member’s Service Years is greater than 1. Remember to use a structured reference to the Service Years column.

b. The function should return the text Eligible if the staff member’s Service Years is greater than 1.

c. The function should return the text Not Eligible if the staff member’s Service Years is not greater than 1.

Answer 1

11.

Note: The provided solution is correct as per the question requirements. If you need further assistance, feel free to comment in the comment section. I'm happy to help you. :)

Screenshot of the excel with the formula:

Put the given below formula into N2 cell with fulfilling all the given condition:

=IF([Service Years]>1,"Eligible","Not Eligible")

11.

In cell N2, enter a formula using the IF function and a structured reference to determine if Alison Simoneau is eligible for tuition remission.

=IF([Service Years]>

Note: Here, firstly stored the excel table by any name with select all the created data in the excel file. By using ctrl+t than enter “ok” after that going in design an than give the table name.

1. The IF function should first determine if the staff member’s Service Years is greater than 1. Remember to use a structured reference to the Service Years column:

=IF([Service Years]>1,

2. The function should return the text Eligible if the staff member’s Service Years is greater than 1.

=IF([Service Years]>1,"Eligible"

3. The function should return the text Not Eligible if the staff member’s Service Years is not greater than 1.

=IF([Service Years]>1,"Eligible","Not Eligible")

Created table:

Employee ID

Name

Full- Time

Service Years

Pay Rate

HR Training Year

Year since HR Training

College Graduate

Academic TechnologyTraining

Subject Leader

Supervisor

Online Tutoring Supervisor

Eligible for academic Technology Training

Tuition Remission

2012

Adam

Yes

3

$ -

2015

2

Yes

Yes

No

Yes

Yes

Completed

Eligible

2024

Peter

No

5

$ -

2017

0

Yes

Yes

Yes

No

No

No

Eligible

2025

Breet Lee

Yes

16

$ -

2018

1

No

No

No

Yes

Yes

Yes

Eligible

2021

Kein Williamson

Yes

4

$ -

2016

0

Yes

No

Yes

Yes

Yes

Completed

Eligible

2023

Kim Michel

No

0

$ -

2017

1

No

No

No

No

Yes

Yes

Not Eligible

2002

Jackson tiger

Yes

3

$ -

2020

3

No

Yes

Yes

Yes

No

Completed

Eligible

2007

Lone darlo

Yes

1

$ -

2015

2

Yes

Yes

Yes

Yes

No

No

Not Eligible

Tuition Remission

=IF([Service Years]>1,"Eligible","Not Eligible")