Excel 2016 Data and List Management

Lesson 1 – Using Advanced Functions

Excel 2016

15. Use the ROUND function to round the results of the commission formula in cell C5 to two decimal places. ( Hint: Modify the existing formula in C5.) Then, copy the formula to the range C6:C13. 16. Format the numbers in the range B5:B13 so that no decimal places appear. 17. Limit the precision of numbers. Notice that the values in C5:C13 change accordingly. 18. Close the workbook without saving it.

Page 30

OFFICEPRO, Inc.