Recruiting Coordinator Excel Quiz
Business Finance
Hourly Recruiting Coordinator Excel Quiz
1. Enter the following information in Row 5 of your ATS:
• Name: Candidate B
• Job: Grill Operator (GO)
• Unit: 2222
• Division: Division 2
• Status: Offered
• Step: Orientation
• Phone: 222-222-2222
• Email: candidateb@wafflehouse.com
• Source: Referral
• In Columns L – W, enter the same information found in Row 4.
• OP: 7
2. Highlight Rows 4 and 5 light green.
3. Cut Rows 4 and 5 and insert them into Rows 20 and 21.
4. Copy and paste the entire ATS into the sheet labeled Worksheet.
5. On the Worksheet, change the status of Candidate A to Regret. Highlight that candidate’s row red.
Bonus: The Time to Hire formula for one of the rows is not working – it is blank (use the ATS sheet). Extend the formula to that cell (a 0 should appear if you have done this correctly).
When finished save your ATS as HRC Excel Quiz – First Name Last Name and send it back to
