1. To be a Supervisor, the staff member must either have more than 5 service years or be a college graduate. In cell K2 enter a formula using the IF and OR functions, as well as structured references to determine if Alison Simoneau can be a supervisor. a. The IF function should first determine if the staff member’s Service Years is greater than 5 OR if the staff member’s college graduate status is "Yes". Remember to use a structured reference to the Service Years and the College Graduate columns. b. The function should return the text Yes if a staff member meets one or both of those criteria. c. The function should return the text No if a staff member meets neither of those criteria.

See explaination

Explanation:

First convert the above data into a table in excel from Insert tab, selecting the entire table and clicking on insert table

Then add the following formulas

Column K: IF(OR([at[Service Years]]>5,[at[College Graduate]]="Yes"),"Yes","No")

Column L: IF(AND([atSupervisor]="Yes",[at[Academic Technology Training]]="Yes"),"Yes","No")

See attachment for the result of the inputted formula.

Note: replace all the "at" with yhe at symbol.

depends on what software you are using. google docs or microsoft word or other?

solution:

the auto-correct option of the auto-correct tool enables you to add and delete words that do not follow abbreviation rules because:

it is a feature that allows outlook to correct common spelling and typing errors and to replace characters with symbols. we can also can use auto-correct as a shortcut, which means we can type a small string of characters and have those characters replaced by a longer string.