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

1. On the “Adult Program” worksheet, select the area you want the sparkline to be inserted.

2. Click Column in theSparklinesgroup from theInserttab.

3. Enter the range of cells in theData Rangebox, in this caseA10:A19.

OR

3. Select the range of cells by temporarily collapsing the dialog box and manually selecting the cells.

4. ClickOKand theSparkline Toolswill appear, theDesigntab can be used to customize the sparklines.

References:

https://support.office.com/en-us/article/analyze-trends-in-data-using-sparklines-be6579cf-a8e3-471a-a459-873614413ce1

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:

https://support.office.com/en-us/article/Round-a-number-to-the-decimal-places-I-want-49B936F9-6904-425D-AA98-02FFB7F9A17B