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

To display the names of employees who earns more than the average salary of allemployees.SELECT last_name, first_nameFROMemployeeWHEREsalary > AVG(salary);Which change should you make to achieve the desired results?Select one:a.Move the function to the SELECT clause and add a GROUP BY clause and a HAVING clause.b.Move the function to the SELECT clause and add a GROUP BY clause.c.Use a subquery in the WHERE clause to compare the average salary value.d.Change the function in the WHERE clause.

Question 3What combination of settings was used to create this Pivot Table?

In the above Pivot Table, you want to add a column for "Average % Increase" (increase in price from the issue price to the current estimated value).   To do this, you should:Group of answer choicesClick the "% increase" check box then change the formula type to AverageDrag the "% increase" field into the Report Filter areaCreate the formula =(C5-B5)/C5 in cell D5 and copy down the column.Average percentage increase is not something Excel can display inside of a pivot table

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

Calculations on pivot table in HR analytics dataset - Data Analysis in Excel, Aggregating and Summarizing Data in Pivot tables - Post ClassGiven an Employees dataset, there are different categories for people who are required to travel as part of their job, your task is to find the following insights for each category in order to reconsider budget allocation.Tasks1.Find the percentage of employees from each department using pivot table in the cells B2:B5 in sheet named Pivot