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 filter the column and row categories 0/3 In the Data Explore worksheet, the filters should be cleared from 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 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. 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 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 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 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 nest the OR function in an IF function to display the product's profitability 3/3 3. 3 To apply the VLOOKUP function with an approximate match 3/3 2. 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.

New perspectives excel 2019