Exam 77-420: Microsoft Excel 2013 3. Create Tables 3.3 Filter and Sort A Table: Change Sort Order

Sort the Data Microsoft Excel has data tools to analyze data. What does our product inventory look like? How many movies are new?   5. Try it: Sort the Data Select the entire spreadsheet. Go to Data ->Sort & Filter->Sort.     What Do You See? You will be prompted to select the Sort criteria. Sort by: Year Sort on: Values Order: Largest to Smallest   Click OK. Keep going... Data ->Sort & Filter->Sort