Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

the Slicer Style Dark 5. Move the slicer helonT the Pivot'l'ahle. 11 5 Note, depending upon the version of Office being used1 the style name

image text in transcribed
the Slicer Style Dark 5. Move the slicer helonT the Pivot'l'ahle. 11 5 Note, depending upon the version of Office being used1 the style name may he Light Blue, Slicer Style Dark 5. Use the Expenses worksheet to create another hlanlr PivotTable on a sheet named Totals. Add the Employee to the Rows and add the Expense eld to the Values area. Sort the PivotTable from largest to 12 smallest expense. 1'0 Change the name for the Expenses column to Totals and format the eld withAccounting number 13 format. 4 Insert a calculated eld to subtract 2659.72 from the Expense eld. Format the eld with the custom 14 name Above or Belon-r Average and apply Accounting number format to the eld. 10 Set 12.25 width for column B and column C, change the row height of row 3 to 30, and apply word 15 wrap to cell C3. 4 Cleate a clustered column PivotChart from the PivotTable. Move the PivotChart to a new sheet named Chart. Hide all eld buttons in the PivotChart, if necessary. 16 Note, Mac users, select the range A3:CB in the PivotTable. On the Insert tab, dick Recommended 10 Charts, and then click Clustered Column to make the chart 1? Add a chart title above the chart and type Expenses by Employee. Change the chart style to Style 14. 5 18 Apply 11 pt font size to the value axis and display vertical axis as Acooumzing with zero decimal placa. 4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction to the Mathematics of financial Derivatives

Authors: Salih N. Neftci

2nd Edition

978-0125153928, 9780080478647, 125153929, 978-0123846822

More Books

Students also viewed these Mathematics questions