Question

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
Answer
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
Answer
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
Answer
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
There are no AI answers yet. The ability to request AI answers is coming soon!