Question: 1 5 . In the range E 5 :E 1 0 of the Metrics worksheet, do the following to count the number of appli -

15. In the range E5:E10 of the Metrics worksheet, do the following to count the number of appli-cants who reach each stage of the recruitment process: a. In cell E5, 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 E6, use the SUBTOTAL function with the COUNT function to count the number of values in the Phone Date field. c. In cell E7, use the SUBTOTAL function with the COUNT function to count the number of values in the Manager Date field. d. In cell E8, use the SUBTOTAL function with the COUNT function to count the number of values in the Onsite Date field. e. In cells E9 and E10, 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!