In cell n2, enter a formula using the if function and a structured reference to determine if allison simoneau is eligible for tuition remission

Full Question

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.

See Attachment for answer

Explanation:

Given:

Cell: N2

Condition: to check if the staff member's Service Years is greater than 1

Before this question can be solved, a table name is needed.

The query to test the above condition will be executed on this table;

Assume table name is; Staffs;

In cell N2, write the following:

--- See attachment-----

The query checks if SERVICE YEAR is greater than 1. The result of this condition determines the next line of action.

1. If yes; it displays "ELIGIBLE" without the quotes in cell N2

2. Else, it displays "NOT ELIGIBLE" without the quotes in cell N2

answer; peter zenger;

given the lack of choices, i'm gonna wing it and say that pushing your car off a cliff might not be the best idea. your car might sustain damage from the fall and will probably result in the car being too damaged to jump start.

if that's not good enough, avoid filling the car with bees. bees might get agitated when trapped or during the moving process, and might result in death or painful stings that will make jump starting your car very difficult. but in the event that you do choose to fill your car with bees, remember to wear protective gear!