Скачать или смотреть Module 6: SAM Project 1a | Shelly Cashman Excel 365/2021 | City of Honu Point

To Get this Solution Contact us on WhatsApp or Email
WhatsApp: +92312-8248802
Email address: [email protected]
WhatsApp Link : https://wa.link/48io8n

#Module6
#SAMProject1a
#ShellyCashmanExcel365/2021
#CityOfHonuPoint

"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 2024.

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."
Format a range as a table.
Apply a table style.
Set the name of a table.
Filter a table.
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."
Add a record to a table.
3. Sort the CurrentProjects table in ascending order by funding amount so that Dean can quickly identify the projects by funding amount.
Sort a range in ascending order.
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."
Use an advanced filter to copy data.
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."
Filter a table.
6. "Go to the Proposed Projects worksheet, which lists projects that were proposed in 2024. Dean suspects the ProposedProjects table has a duplicate record. Identify the duplicate as follows:
a. Clear the filter from the ProposedProjects table to display all the records.
b. In the range A2:A14, create a conditional formatting Highlight Cells Rule that displays cells with duplicate values using Light Red Fill and Dark Red Text.
c. Delete the second instance of the duplicate record so that you can summarize the data accurately. "
Remove filters from a table.
Create a Find Duplicates conditional formatting rule.
Delete a record from a table.
7. "The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding.

Add a column to the ProposedProjects table, and determine which projects meet the criteria as follows:
a. In cell G1, type Fast Track as the column heading.
b. In cell G2, enter a formula using the AND function that includes structured references to display TRUE if a project has a [@[Project Type]] of ""Mixed Use"" and a [@[Funding Type]] of ""Loan"". Fill the range G3:G13 with the formula in cell G2 if Excel does not do so automatically."
Add a column to a table.
Create a formula using a function.
Copy a formula into a range.
8. "Add a Total Row to the ProposedProjects table, which automatically counts the number of Fast Track values.

Using the total row, display the sum of the funding amounts."
Insert a total row in a table.


shelly cashman excel 2019 | module 1: sam project 1b,#shelly cashman excel 2019 | module 1: sam project 1b,module 5 sam project 1a,shelly cashman excel 365/2021,shelly cashman excel 2019 | module 5: sam project 1a,new perspectives excel 2019 module 1 sam project 1a,excel module 5 sam project a,new perspectives excel 2019 | module 10: sam project 1b,module 5: sam project 1a,module 1: sam project 1a,excel module 8 sam end of module project 1,excel module 8 sam project