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. Click on the 3-D Pie Chart on the “Spring Sales” worksheet.

2. This would display theChart Tools, click on the desired style which is Style 3 Monochromatic Color 2 from theChart Stylesgroup situated on theDesigntab.

References:

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

OR

1. SelectInsertfrom theHometab, then clickInsert Sheet.

References: