77-727 Microsoft Excel 2016: Core Data Analysis, Manipulation, and Presentation Free Practice Exam Questions (2025 Updated)

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

1. SelectFormatfrom theHometab then chooseHide and Unhidethen selectUnhide.

OR

1. Hold on the Ctrl button on the keyboard and choose all the worksheet tabs then choose theUnhideoption in the right menu.

2. Click on the first worksheet tab, then hold down the Shift key on the keyboard as you click on the last worksheet tab, then choose theUnhideoption.

OR

1. From theViewtab, clickCustom Viewsin theWorkbook Viewsgroup.

2. Click the “Summary” view which is hidden, then clickShow.

References:

https://www.isunshare.com/blog/hide-or-unhide-sheets-in-excel-2016/

1. Select the cells in the “CustomerID” column which you want to have checked for duplicates.

2. SelectRemove Duplicatesfrom theDatatab.

3. Select the “CustomerID” column which you want to have checked under theColumnsoptions.

4. ClickOK.

References:

https://support.office.com/en-us/article/Find-and-remove-duplicates-00E35BEA-B46A-4D5D-B28E-66A552DC138D

1. Select the cell J9 where you want to modify the formatting.

2. On theHometab in theCellsgroup click onFormat.

3. Specify arow heightby clickingRow Heightand then typing in the desired height of 2 lines in the Row Height box.

References:

https://support.office.com/en-us/article/Wrap-text-in-a-cell-2A18CFF5-CCC1-4BCE-95E4-F0D4F3FF4E84

1. In cell M10 on the “Summer Bookings”, insert the followingSUMIFformula: “=SUMIF(G6:G24, “>= 12”, I6:I24).”’

References:

https://support.office.com/en-us/article/SUMIF-function-169B8C99-C05C-4483-A712-1697A653039B

1. ClickFind & Selectfrom theHometab then click onGo To.

OR

1.Press Ctrl+G on the keyboard.

2. Double-click the name range you want, in this case “Oregon”.

3. Delete the contents in the selected cells by pressing Delete on your keyboard.

References:

https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03-968905B244E6

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

1. On the “Customers” worksheet, click theSelect AllbuttonORpress Ctrl+A.

2. Click the arrow next toConditional Formattingfrom theHometab in theStylesgroup, then selectNew Rule.

3. ClickSelect a Rule Typein theNew Formatting Ruledialog box, then selectUse a formula to determine which cells to format.

4. In theFormat values where this formula is truebox, enter =MOD(ROW(),2)=0.

5. Click onFormat.

6. Click theFilltab from theFormat Cellsdialog box.

7. Select the desired shade background and then clickOK, you are able to view how the background would look in thePreviewwindow in theNew Formatting Ruledialog box.

8. Once satisfied, apply the formatting to the cells by clickingOK.

References:

https://support.office.com/en-us/article/Apply-shading-to-alternate-rows-in-a-worksheet-A443B0F5-2025-42F6-9099-5DE09C05E880

1. Click on cell C3.

2. Enter the following formula: “=HYPERLINK(john@bellowsollege.com, C3)

References:

https://support.office.com/en-us/article/HYPERLINK-function-333C7CE6-C5AE-4164-9C47-7DE9B76F577F