Question

average of current salary employee sex
employee name f m grand total
november $ 32,011 $ 32,011
abel 85,000 85,000
baker 40,000 40,000
charlie 37,244 37,244
delta 80,000 80,000
uniform 122,500 122,500
victor 200,000 200,000
wiskey 31,761 31,761
xray 65,000 65,000
yankee 24,752 24,752
zulu 175,000 175,000
grand total $ 54,717 $ 80,528 $ 67,622

employee id
employee sex
total salary
average salary

Explanation:

Analyze the Pivot Table structure

The image shows an Excel Pivot Table. Let's examine the layout and labels to identify the fields placed in different areas of the Pivot Table:

• Row Labels: The rows list individual names such as November, Abel, Baker, Charlie, Delta, Uniform, Victor, Wiskey, Xray, Yankee, and Zulu. These represent the "Employee Name" field.
• Column Labels: The columns are labeled "F" and "M", representing female and male. The header above these columns is "Employee Sex". Thus, "Employee Sex" is placed in the Columns area.
• Values Area: The values inside the table represent the average of current salaries (e.g., 85,000, 40,000, etc.). The top-left cell of the Pivot Table displays "Average of Current Salary", which indicates the summary calculation being performed on the "Current Salary" field.

Identify the Column Field

The question asks to identify a specific field based on the Pivot Table layout. Looking at the column headers:

• The header "Employee Sex" is located at the top of the columns (with a filter dropdown icon next to it).
• The columns themselves are split by "F" (Female) and "M" (Male).
• Therefore, "Employee Sex" is the field used as the Column field in this Pivot Table.

Evaluate the given options

Let's match our analysis with the multiple-choice options:

• Employee ID: Not visible or used as a header in this Pivot Table.
• Employee Sex: This is the field displayed in the columns area, categorizing the data by 'F' and 'M'.
• Total Salary: The table displays "Average of Current Salary", not "Total Salary".
• Average Salary: This is the calculation/value field, not the column field itself.

Thus, "Employee Sex" is the correct field representing the columns in this Pivot Table.

Answer:

• Employee ID
• Employee Sex (Correct answer)
• Total Salary
• Average Salary