New Perspectives Excel 2019 | Module 6 End of Module Project 1 | Veritate Online скачать в хорошем качестве

New Perspectives Excel 2019 | Module 6 End of Module Project 1 | Veritate Online

New Perspectives Excel 2019 | Module 6: End of Module Project 1 #newperspectives #module6 #eom1 If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇 https://wa.me/message/PPXGSJS2TLWUA1 Whatsapp Contact Number: +91 8114420233 Email ID: excelprojectshelp@gmail.com 1. "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." Unfreeze rows. 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. Format a range as a table. Set the name of a 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. Format a table. Change the column width. 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. Add a record to a table. 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. Sort a table by multiple columns. 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 2022. Create a Find Duplicates conditional formatting rule. Delete a record from a table. 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). Format a conditional formatting rule. Format a conditional formatting rule. 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 2022, the current year. If Excel does not automatically copy the formula to the other cells in column H, fill the range H6:H52 with the formula in cell H5. Clear the conditional formatting rule from the range H5:H52 if Excel applies it. Add a column to a table. Enter text in a cell. Create a formula. Copy a formula into a range. Remove a conditional formatting rule. 9. Padma asks you to make it easy to filter the table based on the contractor's specialty and starting year. Insert two slicers, one based on the Specialty field and the other based on the Start Year field. Add a slicer to a table. Add a slicer to a table. 10. Resize both slicers to a height of 2.2" and a width of 1.5". Move the Specialty slicer so its upper-left corner is in cell I4 and its lower-right corner is in cell I14. Move the Start Year slicer so its upper-left corner is in cell J4 and its lower-right corner is in cell J14. Resize a slicer. Resize a slicer. 11. Use the slicers to filter the Contractors table to show contractors who started in 2021 or 2022 with specialties of Electronics and Movies and music. Filter a table using a slicer. Filter a table using a slicer. 12. Since Padma is using slicers to filter the data, hide the filter buttons in the Contractors table. Hide filter arrows in a table. #newperspectives #samprojects #eom1 #excel2019 #samprojects #cengageassignments #NP_EX19_EOM6-1 #NP_EXCEL #excel_assignments #excel_sam_projects #Module6EndOfModuleProject1 #veritate_online #new_perspectives_excel #NP_EX19_EOM6-1_FirstLastName_1.xlsx #NP_EX19_EOM6-1_FirstLastName_2.xlsx