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

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. Right-click the text title “Adult_Program” and clickFormat Objectthen clickAlt Text.

2. Type “Adult Enrollment” in theTitlebox as desired.

3. ClickOK.

References:

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

OR

1. SelectInsertfrom theHometab, then clickInsert Sheet.

References: