Accounting IT Marketing Media & Design Grand Total
Accounting Assistant $29,123 $29,123
Associate Director $100,900 $100,900
Design Assistant $36,521 $36,521
Design Specialist $45,457 $45,457
Director $120,511 $120,511
Marketing Intern $22,921 $22.921
Senior Director $167,334 $167,334
Tech Support Specialist $38,921 $38,921
Grand Total $29,123 $206,255 $143,432 $182,878 $561,688
Position Accounting IT Marketing Media & Design Grand Total
Accounting Assistant $29,123 $29,123
Associate DIrector $100,900 $100,900
Design Assistant $36,521 $36,521
Design Specialist $45,457 $45,457
Director $120,511 $120,511
Marketing Intern $22,921 $22,921
Senior DIrector $167,334 $167,334
Tech Support Specialist $38,921 $38,921
Grand Total $29,123 $206,255 $143,432 $182,878 $561,688
Question
Use the pivot table to answer the question.
Which department is spending the least on salaries?
(1 point)
Responses
Accounting
Accounting
IT
IT
Marketing
Marketing
Media & Design
Media & Design
Position Accounting IT Marketing Media & Design Grand Total
Accounting Assistant $29,123 $29,123
Associate Director $100,900 $100,900
Design Assistant $36,521 $36,521
Design Specialist $45,457 $45,457
Director $120,511 $120,511
Marketing Intern $22,921 $22.921
Senior Director $167,334 $167,334
Tech Support Specialist $38,921 $38,921
Grand Total $29,123 $206,255 $143,432 $182,878 $561,688
Position Accounting IT Marketing Media & Design Grand Total
Accounting Assistant $29,123 $29,123
Associate DIrector $100,900 $100,900
Design Assistant $36,521 $36,521
Design Specialist $45,457 $45,457
Director $120,511 $120,511
Marketing Intern $22,921 $22,921
Senior DIrector $167,334 $167,334
Tech Support Specialist $38,921 $38,921
Grand Total $29,123 $206,255 $143,432 $182,878 $561,688
Question
Use the pivot table to answer the question.
Which department is spending the most on salaries?
(1 point)
Responses
Accounting
Accounting
IT
IT
Marketing
Marketing
Media & Design
IT
Media & Design
To use the pivot table to answer the question, follow these steps:
Step 1: Select the table containing the salary information and department names.
Step 2: Insert a pivot table. In Excel, you can do this by selecting the table and going to the "Insert" tab, then clicking on "PivotTable."
Step 3: In the PivotTable Field List, drag the "Department" field to the Rows area, and drag the "Salary" field to the Values area.
Step 4: Make sure that the "Values" area is set to summarize the data by "Sum" or "Total."
Step 5: Look for the department with the lowest sum of salaries in the pivot table. This will be the department that is spending the least on salaries.
In this case, based on the provided data, the department spending the least on salaries is the "Accounting" department.