Excel 2016 Tips and Tricks

Lesson – Using Advanced Functions

Excel 2016

Select cell C7. Notice that, although the salary displayed on the worksheet is 4975 , the actual value in the cell is 4974.554 . All the salaries in column C have three or more decimal places, even though the decimal places do not appear due to the cell formatting.

Steps

Practice Data

1. Select the File tab.

Click

The File menu opens.

2. Select the Options button. The Excel Options dialog box opens.

Click Options

3. Select Advanced .

Click Advanced

The Advanced page is displayed.

4. Under the When calculating this workbook section, select the Set precision as displayed option. The option is selected and a Microsoft Office Excel warning box opens to inform you that the data will permanently lose accuracy.

Click

Set precision as

displayed

5. Select OK .

Click

The Microsoft Office Excel warning box closes, and the numbers in the worksheet are recalculated using limited precision.

6. Select OK .

Click

The Excel Options dialog box closes.

Select each of the cells in column C, one at a time. Notice that the decimal places have been removed. Close SALES72.XLSX.

Page 94

OFFICEPRO, Inc.