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

Filter the Data Each field in the Header Row has a Filter. You can use the filters to show the records that meet your criteria, say only the new movies released in 2012.   6. Try it: Filter the Data The sample spreadsheet is open.  Go to Cell B1: Year. Click on Filter. Clear all of the check marks EXCEPT: 2012 What Do You See? There are three movies in this list that were released in 2012. The filter Hides the other movies that do not match the criteria for the year.   Try This, Too: Remove the Filters Go to Data ->Sort & Filter->Filter The Filters should be gone.   Do This: Save the Spreadsheet. Go to File->Save. Close Microsoft Excel, please.   Let's start our work with Microsoft Access. Data ->Sort & Filter->Filter