Need help with this

3. Create charts based on the above table. Pay attention to details in the charts. You must replicate every detail in the charts. This helps you review a few things about charts. 4. The beauty of setting up the summary this way is that you can dynamically select any keywords in B1:D1. Figures, numbers and conditional formatting will change according to your selection. You can even expand the KeywordsTable to allow more keywords in B1:D1. For example, you may add Sales, Helpers, and/or Transportation to expand the list. Remember, every row you add to an Excel table becomes part of the table. 5. I will change the values in cells B1:D1 when I check your assignment. Everything should still work correctly. ection 4: Data Aggregation through Pivot Tables 1. Create the first simple Pivot Table to show average annual salary between management and fastest growing jobs. Save this worksheet as Pivot Table. a. The pivot table shows column and row headings (i.e., Management and Fastest growing). This is done by changing the layout of pivot tables. b. All numbers have dollar sign and only two decimal places. 4 2640 c. The YES category is displayed before the NO category. Usually Excel displays NO before YES. (Why?) You will drag the border of a category to move it to the desired location