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.

what am i matchin tho

professionals can use many types of technology that can them. some examples are, computers (they research and can use for programs for data, they are also used for job applications, school work, and even to make new ideas), speedometers (can get data for unknown data), sometimes something as small as a pen (used for rough drafts, to insert data, and again job applications).