Summary ISM 3011: New Perspectives Excel 2019 | Module 7: Textbook Project - SUBMISSION #3 | SCORE IS: 70 OUT OF 100

1. To calculate the total engagements per post 2/2 To calculate the engagement rate per post 2/2 To create the vertical lookup table of engagement levels 3/3 To apply the VLOOKUP function with an approximate match 3/3 2. To nest the OR function in an IF function to display the product's profitability 3/3 3. To do conditional counting with the COUNTIF function 3/3 To calculate a conditional sum with the SUMIF function 3/3 To calculate a conditional average with the AVERAGEIF function 3/3 4. To create a PivotTable from the Media table 3/3 To change the PivotTable name 0/3 The Data Explore worksheet should contain a PivotTable named "Explore PivotTable". To place fields in the Values, Columns, and Rows areas 0/3 In the Data Explore worksheet, the Site field in the PivotTable should be used as a column. To modify the PivotTable to show shares by media site and profit group 0/3 In the Data Explore worksheet, the SHARES field should be added to the Values area of the PivotTable. To nest fields within a PivotTable 0/3 In the Data Explore worksheet, the Months field should be added to the Rows area of the PivotTable. (This will be marked correctly on performing step 8.) To add the Topic field to the Filters area 0/3 In the Data Explore worksheet, the TOPIC field should be added to the Filters area of the PivotTable. To filter the column and row categories 0/3 In the Data Explore worksheet, the filters should be cleared from the PivotTable. 5. To create a PivotTable that summarizes social media engagement 3/3 To format the five PivotTable calculated value fields 0/3 In the Dashboard worksheet, the fields in the Values area of the Engagement Pivot PivotTable should be formatted using the Number number format, zero decimal places, and a comma separator. To create a PivotTable counting the number of social media posts 3/3 To create a PivotTable of average engagement rates 3/3 To create a PivotTable of engagement level vs. media site 3/3 To rearrange the Engagement Level categories 3/3 6. To set the PivotTable options 0/3 In the Dashboard worksheet, the Engagement Level Pivot PivotTable should not display grand totals for columns. 7. To apply a design style to a PivotTable 3/3 To complete the designs of the remaining PivotTables 3/3 8. To change the chart type 3/3 To name and move the PivotChart 3/3 To create the pie PivotChart showing the breakdown of user engagements 3/3 To format the pie chart PivotChart 3/3 To create a PivotChart of the engagement rate per month 3/3 To place the line chart in the Dashboard worksheet 3/3 9. To add a slicer for the Topic field to the Engagement Pivot PivotTable 3/3 To create the Date timeline slicer 3/3 To filter the timeline by dates 0/3 In the Dashboard worksheet, the PivotTable should be filtered using the DATE slicer so that it displays only data from December 2021. 10. To drill down the Engagement Levels PivotTable 0/3 In the Excellent Posts worksheet, the width of columns A through M should be set using AutoFit.