1. Pivot Tables: Chapter 7 Level 2 starting on Page 450. Skip the first section and start from : Analyzing Data Using a Pivot Table Report on Page 460. Refer to Figure 7.27 on page 461. You will note that Excel 2013 has Recommended Pivot Tables icon. If you have an earlier version, this icon is not available but you can skip the references to its usethe rest of the Figures show you how to set up Pivot tables. Use the attached Pacific Sales.xlsx file as your starting file to follow along with your textbook instructions. You might also want to watch the following www.youtube.com videos: Excel Basics #20 and Highline Excel Class 20 When you have finished these tutorials, you should complete and post the Steps to Success: Level 2 exercise starting on Page 472. I have already converted the Pacific.accdb file to the PacificSales.xlsx file you will need. A copy of the file is attached.