1. Dean Yamaguchi is a development officer for the city of Honu Point in Hawaii. Dean is analyzing city development projects that have been completed, are in progress, and have been proposed. He asks for your help in using Excel tables to complete the analysis. Go to the Completed Projects worksheet, which lists the development projects that were completed in Honu Point in 2021. Create a table as follows so that Dean can summarize and filter the data and display projects with the highest funding amounts:

a. Format the completed projects data (range A1:F12) as a table using Brown, Table Style Medium 7.

b. Use CompletedProjects as the name of the table.

c. Filter the table using a custom AutoFilter to display projects with a Funding amount greater than $10,000.

2. Go to the Current Projects worksheet, which contains the CurrentProjects table listing city development projects that are under review or in development. The city recently received a proposal for a new development project. Insert a new row after the Lahua Street Apartment record in the CurrentProjects table for a new record containing the data shown in Table 1.

Table 1: New Record for the CurrentProjects Table

Project Name	Orchid Drive Zoning
Start Date	11/20/2021
Number of Days	30
Project Type	Public
Funding Type	Loan
Funding	$2,000
Approved?	No
In Development?	No

3. Sort the CurrentProjects table in ascending order by funding amount so that Dean can quickly identify the projects by funding amount.

4. Dean wants to list the projects that are in development in a separate part of the worksheet. Use an advanced filter as follows to list these projects in a new range:

a. In cell H17, type Yes as the value to filter on in the criteria range.

b. Create an advanced filter using the CurrentProjects table (range A1:H12) as the List range.

c. Use the range A16:H17 as the Criteria range.

d. Copy the results to another location, starting in the range A19:H19.

5. As a contrast, Dean also wants to list the projects that are not in development. In the CurrentProjects table, use the filter arrows to limit the table display to projects that are not in development.