New Perspectives Excel 365/2021 | Module 6: End of Module Project 1

Описание: Contact us on Phone,WhatsApp or Email
WhatsApp: +1(209)345-9376
Email address: [email protected]
Whatsapp link : https://wa.link/t4mgjz


#NewPerspectivesExcel365/2021
#PerspectivesExcel365/2021
#Excel365/2021
#Module6EndofModuleProject1
#EndofModuleProject1
#ModuleProject1
#Project1
#VeritateOnline
#Online
#NP_EX365_2021_EOM6-1
#EX365_2021_EOM6-1
#EOM6-1
#NewPerspectives
#Perspectives
#Module6
Padma Laghari is a content manager for Veritate Online, a website that sells electronics, home furnishings, and other goods throughout the United States. Padma oversees the contractors the company hires to research, write, and edit content for the website, including product descriptions and answers to customer questions. She is organizing information about the contractors in an Excel workbook, and asks for your help in updating and analyzing the data.
Switch to the Contractors worksheet. Unfreeze the top row of the worksheet.
2. Padma wants to sort and filter the contractor data. Format the range A4:G52 as a table with headers using Blue-Gray, Table Style Medium 9. Use Contractors as the name of the table.
3. Apply the First Column table style option to separate the ID values from the rest of the data. Resize column A to its best fit.
4. A new contractor started last week, and Padma wants to include her data with the other contractors. Insert the record shown in Table 1 to the end of the Contractors table above row 53.
Table 1: New Record for the Contractors Table

ID First Last Specialty Start Year Pay Category Eval Rating
c5496 Mai Vang Garden and home 2025 1 3

5. Padma wants to quickly identify the contractors who have been working with Veritate the longest. Sort the data in the Contractors table first in ascending order by the Start Year field and then in ascending order by the Last field.
6. Padma knows the Contractors table contains a duplicate record. In the range A5:A53, create a conditional formatting Highlight Cells Rule that identifies duplicate cell values by formatting them with Light Red Fill with Dark Red Text. Delete the second instance of the duplicate record, the one with a Start Year of 2025.
7. The conditional formatting rule in column G highlights cells that contain the value 5, the highest evaluation rating. Padma wants to change the highlighting to use colors that are associated with positive values. Edit the conditional formatting Highlight Cells Rule for the range G5:G52 to highlight the cells containing values equal to 5 with a font color of Teal, Accent 2, Darker 50% (6th column, 6th row in the Theme Colors palette) and a fill color of Teal, Accent 2, Lighter 60% (6th column, 3rd row in the Theme Colors palette).
8. Padma wants to list the number of years each contractor has been working for Veritate. Insert a column to the right of the Eval Rating column. Use Years as the column heading. In cell H5, insert a formula without a function that uses a structured reference to subtract the Start Year from 2025, the current year