Spec Ops Qualifications

Spec Ops qualifications are coming up. You need to create an Excel document that will determine which people are accepted and which are declined. In order to pass each applicant must earn at least four fitness points, meet a weight standard, and have been drug free for 7 years.

1.) Create Columns for 3 Mile Time, Crunches, Push-ups, Total Fitness Points, Drug Free 7 Years, Weight Standard, and Accepted. Weight Standard and Drug Free colums will have simple Yes/No answers. 

2.) Copy the data from these charts into your document. 

3.) Use Lookup formulas to calculate the Total Fitness Points column. 

Note- you will have to add three lookup formulas together to get total fitness points. 

=Lookup(x,x1:x5,x1:x5)+Lookup(x,x1:x5,x1:x5)+Lookup(x,x1:x5,x1:x5)

4.)Use the ADD formula to determine whether or not an applicant will Pass. 

5.) Make sure to bold and center all titles. Make information clear and easy to read. 

Save and submit to drive.