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 least on salaries?
(1 point)
Responses
Accounting
Accounting
IT
IT
Marketing
Marketing
Media & Design
Media & Design
Media & Design
To answer the question, "Which department is spending the least on salaries?", we can use the provided table to create a pivot table.
Here's how you can create a pivot table using the provided data:
1. Open the data in a spreadsheet application like Microsoft Excel or Google Sheets.
2. Select all the data, including the headings and the values.
3. Go to the "Data" tab in the menu and find the option for creating a pivot table. In Excel, it is usually under the "PivotTable" option.
4. Choose where you want to place the pivot table. You can either create it on a new worksheet or on the existing worksheet.
5. In the pivot table setup, select the "Department" column as the "Rows" or "Labels" field.
6. Add the "Salaries" column in the "Values" field. Make sure to choose the "Sum" or "Total" option for aggregation, as we are interested in the total salary expenditure for each department.
7. Now, look at the pivot table and find the department with the lowest total salary expenditure. This will be the department that is spending the least on salaries.
Based on the provided data, the department spending the least on salaries is Accounting, as it has the lowest total salary expenditure of $29,123.
Therefore, the answer to the question is Accounting.