Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

19. Select a cell in the Product column and test the data validation by typing shoes . Click Cancel in the error message box. 20. Use a Number Filter on the Sales column to display Below Average sales. 21. Use a Number Filter on the Sales column to display the top 5% . Then clear the filter from the Sales column. 22. Use a Text Filter on the Product column to show only sales of balls . 23. Close the workbook without saving it.

OFFICEPRO, Inc.

Page 65