Microsoft 77-727 dumps - 100% Pass Guarantee!

Correct Answer: See explanation below.

Explanation:

1.

Select a cell in the “CountryOrRegion” field on the “Customers” worksheet.

2.

Select Sort from the Sort and 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-a6ae2e545c4a4654

Correct Answer: See explanation below.

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-issuesa16f6de0-2f39-4a2b-8bd8-5ad801426c7f

Correct Answer: See explanation below.

Explanation:

1.

On the “Car Inventory” worksheet, click Print Titles from the Page Setup group, situated on the PageLayout tab.

2.

Under Print Titles, on the Sheet tab, type the reference of the row you want to reappear (row 9) in the Rows to repeat at top box.

References:

https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-D3550133F6A1-4C72-AD70-5309A2E8FE8C

Correct Answer: See explanation below.

Explanation:

1.

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

2.

On the Home tab in the Cells group click on Format.

3.

Specify a row height by clicking Row Height and 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

Correct Answer: See explanation below.

Explanation:

1. In cell M9, on the “Summer Bookings” worksheet, insert the following COUNTIF formula: “=COUNTIF (G6:G24, >= 12”)”

References:

https://support.office.com/en-us/article/count-numbers-greater-than-or-less-than-a-number-453b0ccc-cfaa4332-ad02-6e148e01aa0a