Free 77-727 Exam Dumps Preview

Explanation:
1. Select a cell in the "CountryOrRegion" field on the "Customers" worksheet.
2. Select Sort from the Sort & Filter group in the Data tab.
3. In the Sort dialog box, under Column in the Sort by box, Select the "CountryOrRegion" field.
4. Under the Sort On option, select the type of sort desired, in this case Values, to sort by text.
5. Under Order, select Custom List, then set it for customers in the United States to appear first, then the customers in Canada.
6. Then to add another column to sort by, click Add Level.
7. In the Sort dialog box, under Column in the Sort by box, Select the "StateOrProvince" field.
8. Under the Sort On option, select Values.
9. Under Order, select A to Z.
10. Add a final column by clicking Add Level.

11. In the Sort dialog box, under Column in the Sort by box, Select the "PostalCode" field.
12. Under Sort On, select Values.
13. Under Order, select Smallest to Largest.
14. Click OK.

References:
https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654

Explanation:
1. Select the worksheet you want to apply the margin changes to.
2. Select Margins in the Page Setup group from the Page Layout tab.
3. Click Custom Margins, then in the Top and Bottom dialog box enter 1.0'' (2,54cm), in the Left and Right dialog box enter 0.75''(1.90cm), and enter 0.5''(1.27cm) in the Header and Footer dialog box.

References:
https://support.office.com/en-us/article/Set-page-margins-before-printing-a-worksheet-353F52FC-0D2C-4958-9166-99FBD22B963A

Explanation:
1. Click Sort Sheets from the Worksheet group in the Kutools Plus tab.
2. Click the Alpha sort button OR the Alpha Numeric Sort button in the Sort Sheets dialog box, the results can be previewed in the New sheets tab order list box.
3. Use the Move up or Move down button to manually change the order of the sheets so that the "$5,000
Donors" worksheet is first in the New sheet tabs order list.
4. Click OK once satisfied with the results.

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

Explanation:
1. Click on the title on the "Spring Sales" worksheet, then type "New Products".
2. You can edit the Font of the title from the mini-toolbar that appears OR from the Home tab.
3. Click directly on either the x-axis or y-axis in the chart OR click the Chart Elements button.
4. For editing the x-axis which is the horizontal category then type "Months".
5. Do the same to edit the y-axis which is the vertical category and type "Gross Sales".
6. You can further edit the text of the data in either of the axis as desired.

References:
https://www.dummies.com/software/microsoft-office/excel/how-to-edit-chart-titles-in-excel-2016/

Explanation:
1. Select the cells below the rows and to the right of the columns you want to keep visible, which in this case is row 10 and column H.
2. Click Freeze Panes from the Freeze Panes group in the View tab.

References:
https://support.office.com/en-ie/article/Freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f

Explanation:

1. To check the accessibility select the Review tab from the ribbon.
2. Select Check Accessibility.
3. Review the results.
4. Exit the Accessibility Checker.
5. Right-click on the worksheet then click Format and then click Alt Text.
6. Type "Tree Nursery Inventory" in the Description box.
7. Click OK.

References:
https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issues-a16f6de0-2f39-4a2b-8bd8-5ad801426c7f