To complete this activity, you will need to have Excel installed on your computer. This exercise requires you to work in Excel and answer questions in Connect. You will read a brief scenario and then download an Excel file that you will need to complete the requirements in Parts $1$ through $8$ of this exercise.

Some of the requirements include brief video tutorials on using Excel functions. After viewing the tutorials, you will then use what you learned to work directly in Excel to answer the required questions in Connect.

$[$The following information applies to the questions displayed below.$]$

Chapman Realty Company is seeking your help in analyzing its sales across counties and property types over the last four months. During this time period the company's $12$ realtors sold $99$ properties $($residential$,$ commercial, and land$)$ across six counties for a total of $$30,637,161.$

Refer back to the Excel workbook and use your work from requirements $1$a$.$ and $1$b$.$ to answer question $1$c$.$ below.

$1$c$.$ Which counties had the third and fifth highest sales? How much did each of them sell during the four$-$month period?

$\backslash$table$[[$Third highest,,Sold,$],[$Fifth highest,,Sold,$]]$