From below image determine the Art Type and Sum of Est. Value fall under which area of pivot table.Group of answer choicesArt Type: Rows; Sum of Est.Value: ValuesArt Type: Filter; Sum of Est.Value: ValuesArt Type: Values; Sum of Est.Value: ColumnsArt Type: Rows; Sum of Est.Value: Columns

Which of the following statements are true for Pivot Tables?(Multiple answers possible. Partial credit awarded)1 pointYou can use a text field in the Values areaYou can apply different functions - average, count, etc - to numeric fieldsNumeric values can only be summedCount can only be applied to text field

Employee data of Phoenix Game Studio Company:You want to find average salary of male and female using a Pivot Table. What change would you make in "Pivot Table Fields" (shown below)?Group of answer choicesAdd salary to 'Values' and change its setting to show 'average'Add salary to 'Columns' and change its setting to show 'average'Add salary to 'Rows' and change its setting to show 'average'No change is required

Sophie is working on sales data from her company and wishes to see what the total profits were for each Region, on each month. What PivotTable would she draw? 0 / 1 pointThe PivotTable would have: Months as Values, Profits as Columns, and Profits as Rows.The PivotTable would have: Region as Values, Months as Columns, and Profits as Rows.The PivotTable would have: Profits as Values, Region as Columns, and Months as Rows.The PivotTable would have: Region as Values, Profits as Columns, and Months as Rows.

Use the SUMIF function when you want to:Group of answer choicesDisplay the sum of a range only if the answer is a positive numberCalculate and display the sum of a range only if it meets specific criteriaDisplay the larger of the sums of two rangesFind sum pi

Which of the following is not an area listed in the PivotTable Fields task pane?Group of answer choicesRowsFiltersDataColumns