Insert a funnel chart of the data in the range F$8$:G$13.$ Move and resize the chart to cover the range J$6$:K$15.$ Change the chart title to Application History.

In cell F$19,$ create a list validation based on the data in the range O$8$:O$18.$ In cell G$19,$ create a list validation based on the data in the range Q$8$:Q$13.$ The application will now be able to retrieve data on applicants that match specified search criteria.

Use the arrow buttons in cells F$19$ and G$19$ to select the values Accountant and Onsite Interview.

In the Dashboard worksheet, hide the contents of columns O through Q$.$

Hide the Applicants, Application PivotTable, and Terms and Definitions worksheets.

Protect the workbook. Do not specify a password for the document.

In the Dashboard worksheet, unlock cells F$19$ and G$19,$ and then protect the worksheet to allow only selecting locked and unlocked cells. Do not specify a password for the protected sheet.

Save the workbook, and then use the macro recorder to create a macro for this workbook named Lookup$\_$Applicants with the description Retrieve application data using an advanced filter.

Start the recorder, and perform the following tasks to create the macro:

a$.$ Unprotect the worksheet.

b$.$ Click the Data tab, and then in the Sort & Filter group, click the Advanced button.

c$.$ In the Advanced Filer dialog box, click the Copy to another location option button, enter Applicants$[$#AII$]$ in the List range box to retrieve data from the Applicants table, verify that Copy to box. Click click OK to apply the advanced filter.

d$.$ Protect the worksheet.

e$.$ Stop the recorder.