Multiple Choice
Before you create a pivot table, it is important to (1 point)
• create a databse
• sort a database
• filter a database
• format a database
• sort a database
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
Use the pivot table to answer the question
How many positions are there in the Media & Design department?
(1 point)
• one
• two
• three
O four
• three
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
Use the pivot table to answer the question.
Which department is spending the least on salaries?
(1 point)
• Accounting
O IT
• Marketing
• Media & Design
• 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
Use the pivot table to answer the question.
Which department is spending the most on salaries?
(1 point)
• Accounting
O IT
• Marketing
• Media & Design