77-727 Exam Dumps : Excel 2016: Core Data Analysis, Manipulation, and Presentation

1. Select cell N2 on the “Customers” worksheet, which is where you want the Excel function to return the result to.

2. In theAddressbar, type the average function syntax;=AVERAGE(K1:K101).

References:

1. Select the cells in the “Weight” column which you want to apply the number formatting to.

2. ClickIncrease Decimaltill the desired decimal places of three is selected, this is found on theHometab.

OR

1. Select the cells in the “Weight” column which you want to apply the number formatting to.

2. On theHometab, in theNumbergroup, click the arrow next to the list of number formats, then selectMore Number Formats.

3. Select the type of data you have in theCategorylist, in this case it would beScientific.

4. Enter the desired amount ofdecimal placesyou want to display in the Decimal places box, in this case it would be three.

References:

1. Select the plus icon at the bottom of the screen.

OR

1. SelectInsertfrom theHometab, then clickInsert Sheet.

References: