Question
1 of 41 of 4 Items
Question
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
Answers
Answer
2 of 42 of 4 Items
Feature
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
Answer
3 of 43 of 4 Items
Feature
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
Answer
4 of 44 of 4 Items
Feature
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
Media & Design
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.