1. Student organizations sometimes require transportation for off-campus activities, and school policy requires students to be o
ver 23 years old to serve as transport. Lael wants to determine how many of the active students will be eligible to transport other group members. In cell J2, enter a formula using the IF function as follows to determine if Kay Colbert can serve as authorized transport: A. The function should use a reference to the Age column to determine if the student's age is greater than 23, and should return the text.
B. Fill the formula into the range J3:J31, if necessary.
2. To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post-secondary education or have gone through the organization finance training. In cell K2 enter a formula using the IF and OR functions as follows to determine if Kay Colbert can join the leadership training program:
A. The IF function should determine if the student's Post-Secondary Years is greater than or equal to 2 or if the student's finance certified status is "Yes", returning the text. Yes if a student meets one or both of those criteria or the text. No if a student meets neither of those criteria.
B. Fill the formula into the range K3:K31, if necessary.
A(n) anti-forensics process is initiated by individuals who are subjected to forensic techniques with the intention of hiding or obfuscating items or objects with evidentiary value.
