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
The department that is spending the least on salaries is Accounting.
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.
How many positions are there in the Media & Design department?
(1 point)
Responses
one
one
two
two
three
three
four
four
There are four positions in the Media & Design department.
Multiple Choice
Before you create a pivot table, it is important to___________.
(1 point)
Responses
create a databse
create a databse
sort a database
sort a database
filter a database
filter a database
format a database