Can someone complete by deadline

Filter Sales Data Lab 3, Step 4 A. Make a copy of the Sales Data in order to ensure that you have a backup copy of the original data. Right click on the Sales Data Tab and select Move or Copy:

Make sure that you click the Create a Copy checkbox and select Move to End:

Click OK. Rename the new sheet Filtered Data.

B. Convert the data list range to a table. Select the range of cells that contains the Sales Data. Click the Insert Tab and select Tables from the Tables Group:

The Create Table dialog box will open. Make sure that the “My table has headers” checkbox is checked:

Click OK. The data will be converted into a Table and the Table Tools tab will open.

C. Click the dropdown box next to Selling Agent. Uncheck Select All and then check Carey.

Click OK. Only the properties sold by Carey will be displayed. Notice the Filter icon next to the Selling Agent column heading. This indicates that the data has been filtered.

Now click the dropdown next to City and select only Miami. Now only the properties sold by Carey in Miami will display: