Скачать или смотреть New Perspectives Excel 2019 | Module 7 End of Module Project 2 | Content Shop

New Perspectives Excel 2019 | Module 7: End of Module Project 2 #newperspectives #module7 #eom2

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:
[email protected]

1. Alex Makula is a project manager for the Content Shop, an online firm based in New Haven, Connecticut, that provides written content for websites. Alex is compiling data on the contract writers and editors the company works with, and he asks for your help completing the workbook and analyzing the data. Switch to the Contract Writers worksheet, where Alex created a formula with the VLOOKUP function to look up contractor names by their Contractor ID. Other project managers will use this workbook, and he wants to alert them when they enter an incorrect ID number. In cell B4, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, display "Invalid Contractor ID" as the error text.
Create a formula using a function.
2. Alex needs to complete the Writers table in the range A7:I27. First, determine whether each contractor can write questions and answers for information websites. In cell G8, enter a formula using the IF function that uses a structured reference to the Years column ([@Years]) to determine if the value is greater than 1. The formula returns the text Yes if true and No if false. Fill the formula into the range G9:G27, if necessary.
Create a formula using a function.
Copy a formula into a range.
3. Contractors who can write reviews must have at least 2 years of experience or an average evaluation rating from Contract Shop managers of 7 or more. In cell H8, enter a formula using the IF and OR functions to determine whether the value in the Years column is greater than or equal to 2 OR whether the value in the Avg Eval column is greater than or equal to 7. Use a structured reference to both columns ([@Years] and [@[Avg Eval]]). The formula returns the text Yes if a contractor meets one or both of the criteria, and it returns No if a contractor meets neither criteria. Fill the formula into the range H9:H27, if necessary.
Create a formula using a function.
Copy a formula into a range.
4. Contractors can take copywriting assignments if they have at least 3 years of experience and a customer score of at least 7. In cell I8, enter a formula using the IF and AND functions to determine whether the value in the Years column is greater than or equal to 3 AND whether the value in the Avg Score column is greater than or equal to 7. Use a structured reference to both columns ([@Years] and [@[Avg Score]]). The formula returns the text Yes if a contractor meets both criteria or the text No if a contractor meets none or only one of the criteria. Fill the formula into the range I9:I27, if necessary.
Create a formula using a function.
Copy a formula into a range.
5. Switch to the Editing PivotTable worksheet. It contains the EditingProjects PivotTable, which is based on the Editors table on the Editing Projects worksheet. Display the PivotTable Field List, and then remove the Average of Total Projects field from the Values area. Move the GroupID field so that it appears as the second field in the Rows area to make the PivotTable easier to interpret.
Remove a value field in a PivotTable.
Move fields in a PivotTable.
6. Alex wants another way to compare the editing projects by level, but not by group. Collapse the outline in the EditingProjects PivotTable to display the Level names and to hide the Group IDs. Insert a PivotChart based on the EditingProjects PivotTable using the Stacked Column chart type. Resize and reposition the PivotChart so that the upper-left corner is located within cell A12 and the lower-right corner is located within cell F25. Change the PivotChart colors to Monochromatic Palette 5 to coordinate with the PivotTable.
Collapse the outline in the PivotTable.
Insert a PivotChart.
Resize a PivotChart.
Change the chart colors.
7. Alex needs to concentrate on copywriting and internal editing projects. Use the Specialty slicer to filter the PivotTable and PivotChart to display only Copywriting and Internal editing projects.
Filter a PivotTable using a slicer.

#samprojects #cengageassignments #NP_EX19_EOM7-2 #NP_EXCEL #excel_assignments #excel_sam_projects #Module7EndOfModuleProject2 #content_shop #new_perspectives_excel #NP_EX19_EOM7-2_FirstLastName_1.xlsx #NP_EX19_EOM7-2_FirstLastName_2.xlsx