Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 5 . In the range E 5 :E 1 0 of the Metrics worksheet, do the following to count the number of appli -
In the range E:E of the Metrics worksheet, do the following to count the number of applicants who reach each stage of the recruitment process: a In cell E use the SUBTOTAL function with the COUNTA function to count the number of entries in the Applicant ID field of the Recruits table.b In cell E use the SUBTOTAL function with the COUNT function to count the number of values in the Phone Date field.c In cell E use the SUBTOTAL function with the COUNT function to count the number of values in the Manager Date field.d In cell E use the SUBTOTAL function with the COUNT function to count the number of values in the Onsite Date field.e In cells E and E use the SUBTOTAL function with the COUNT function to count the number of values in the Offer Date and Acceptance Date fields, respectively.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started