Illustrated Excel $2019|$ Modules $1-4$: SAM Capstone Project $1$b

Yuki wants to display the total number of clients who signed policies in April.

In cell M$5,$ enter a formula using the COUNTA function to count the client IDs $($the

range B$6$:B$19).$

He also wants to determine the average number of years clients have been with

Youngwood Insurance.

In cell M$6,$ enter a formula using the AVERAGE function to average the number of years

$($the range E$6$:E$19).$

Your workbook should look like the Final Figures on the following pages. Save your changes,

close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your

completed project.