Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

Open the Top 10 AutoFilter dialog box again and change Percent to Items , then click OK . Notice that the filtered list now contains 15 rows but that they are not in any particular order. Click the Sales Filter button and select Sort Largest to Smallest .

Click the Clear button in the Sort & Filter group on the Data tab to clear both sorting and filtering from all the columns. Close TABLEA.XLSX.

U SING D ATA V ALIDATION  D ISCUSSION

Tables can contain incorrect information due to data entry errors. One method of controlling the accuracy of data entered is to place validation limits on the type of data to be entered and to decide whether blank entries are allowed.

Using data validation, you can restrict the type of data allowed in a cell and the minimum, maximum, or upper and lower limits for whole numbers, decimals, dates, or times. If the cell will contain text, you can set an upper and lower limit for the number of characters permitted.

When a user enters an invalid entry into a cell that contains data restrictions, Excel opens a Microsoft Office Excel message box, called an alert, which explains that the entry is not valid and only restricted values can be entered into this cell.

OFFICEPRO, Inc.

Page 53