Microsoft 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation Exam Practice Test

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. ClickFind & Selectfrom theEditinggroup situated on theHometab.

2. ClickReplace.

3. Type the text “Pickup” in theFine whatbox.

4. ClickOptionsto further define the search, specify the “Car Inventory” worksheetselect Sheet in theWithinbox.

5. Type “Truck” in theReplace withbox.

6. ClickFind All, and then clickReplace All.

7. Finalize by clickingOK.

References:

https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

1. Select the first row OR column on the “Summer Sales” worksheet andCopyeither from theHometabORby pressing Ctrl+C on the keyboard.

2. Select the first cell where you want topastethe data, then click on the arrow next to Paste situated on theHometab, then selectTranspose.

3. Pick a spot with enough space to paste your data, the copied data will overwrite the already existing data that is already there.

4. Once completed, you can delete the original data if desired.

References:

https://support.office.com/en-us/article/Transpose-data-from-rows-to-columns-or-vice-versa-in-Excel-for-Mac-9c16dd55-ed1a-4aa2-8b74-b1b9211e2ede

1. On the “Youth Program” worksheet, selectFormat as Tablefrom theHometab.

2. Choose the desired style for the table.

3. Select the desired cell range of A9:G19 in theFormat as Tabledialog box.

4. Mark row 9 as a header.

5. ClickOK.

References:

https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664

1. Select the “Top Sellers” column chart.

2. Click on the particular data point you want to label, clickAdd Chart Element +, from the upper right corner next to the chart, then selectData Labels.

3. Then clickFormat Data Labels.

4. TheData Label Rangedialog box would appear, select the data range which are the cell values you want to appear in the labels, in this case it would be the “Total” colunn for “Fruits”, “Vegetables”, and “Jams & Honey”, then clickOK.

References:

https://support.office.com/en-us/article/add-or-remove-data-labels-in-a-chart-884bf2f1-2e29-454e-8b42-f467c9f4eb2d