Pass the Microsoft MOS-Microsoft Office Specialist 77-727 Questions and answers with ExamsMirror

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

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

3. ClickOK.

References:

https://support.office.com/en-us/article/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-or-other-object-44989b2a-903c-4d9a-b742-6a75b451c669#bkmk_o2016_2013

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 rows you want to hide, in this case rows number 29 and 30 by clicking on them.

2. Right-click on the selected rows then click Hide.

References:

https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8

1. ClickSort Sheetsfrom theWorksheetgroup in theKutools Plustab.

2. Click theAlpha sortbuttonORtheAlpha Numeric Sortbutton in theSort Sheetsdialog box, the results can be previewed in theNew sheets tab orderlist box.

3. Use theMove uporMove downbutton to manually change the order of the sheets so that the “$5,000 Donors” worksheet is first in theNew sheet tabs orderlist.

4. ClickOKonce satisfied with the results.

References:

https://www.extendoffice.com/product/kutools-for-excel/sort-worksheets-in-one-workbook-in-alphabetical-order.html

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

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:

https://support.office.com/en-us/article/Change-the-layout-or-style-of-a-chart-A346E438-D22A-4540-AA87-BCE9FEB719CF

1. Select cell N2 on the “Customers” worksheet, which is where you want the Excel function to return the result to.

2. In theAddressbar, type the average function syntax;=AVERAGE(K1:K101).

References:

https://support.office.com/en-us/article/AVERAGE-function-047BAC88-D466-426C-A32B-8F33EB960CF6

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

OR

1. SelectInsertfrom theHometab, then clickInsert Sheet.

References:

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2