Answer Happy

DE PROJECT STEPS 1. 2. 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. b. C. Format the completed projects data (range A1: F12) as a table using Brown, Table Style Medium 7. Use Completed Projects as the name of the table. Filter the table using a custom AutoFilter to display projects with a Funding amount greater than $10,000. Go to the Current Projects worksheet, which contains the Current Projects 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 Current Projects table for a new record containing the data shown in Table 1. Table 1: New Record for the CurrentProjects Table Project Name Start Date rn Orchid Drive Zoning 11/20/2021 Focus