Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
