Microsoft 77-727 Exam Questions - 77-727 PDF

Latest Microsoft 77-727 Exam Questions

We regularly update our Microsoft 77-727 Exam Questions, following is the glimpse of the latest 77-727 Exam Questions updated in our Microsoft 77-727 Exam preparation products. Buy Microsoft 77-727 Exam preparation material listed above to avail full set of updated exam preparation material.

Question 1

SIMULATION

Project 1 of 7: Tailspin Toys

Overview

You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.

On the ''Customers'' worksheet, sort the table to order the records by the ''CountryOrRegion'' field, with customers in the United States first and customers in Canada second.

Then sort the customers in each country alphabetically (from A to Z) by the ''StateOrProvince'' field.

Finally, sort the customers in each state or province in ascending order by the 'PostalCode'' field.

A1. 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.
5. In the Sort dialog box, under Column in the Sort by box, Select the ''PostalCode'' field.
6. Under Sort On, select Values.
7. Under Order, select Smallest to Largest.
8. Click OK.

B1. 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.

Question 2

SIMULATION

Project 1 of 7: Tailspin Toys

Overview

You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.

On the ''Customers'' worksheet, enter a formula in cell N2 that uses an Excel function to return the average age of the customers based on the values in the ''CurrentAge'' column.

A1. Select cell N2 on the ''Customers'' worksheet, which is where you want the Excel function to return the result to.
2. In the Address bar, type the average function syntax; =AVERAGE(K1:K101).

B1. Select cell N2 on the ''Customers'' worksheet, which is where you want the Excel function to return the result to.
2. In the Address bar, type the average function syntax; =AVERTGE(K1:K181).

Question 3

SIMULATION

Project 1 of 7: Tailspin Toys

Overview

You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.

On the ''Orders'' worksheet, enter a formula in cell J2 that uses an Excel function to return the ''OrderTotal'' value of the individual order that has the highest ''OrderTotal'' value.

A1. Select the cell J2 where you want the highest ''OrderTotal'' value to be.
2. Type in the formula: =MAX(G1:G550).

B1. Select the cell J2 where you want the highest ''OrderTotal'' value to be.
2. Type in the formula: =MAX(G1:G660).

Question 4

SIMULATION

Project 1 of 7: Tailspin Toys

Overview

You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.

On the ''Customers by Order'' worksheet, use an Excel data tool to remove all records with duplicate ''CustomerID'' values from the table. Do not remove any other records.

A1. Select the cells in the ''CustomerID'' column which you want to have checked for duplicates.
2. Select Remove Duplicates from the Data tab.
4. Click OK.

B1. Select the cells in the ''CustomerID'' column which you want to have checked for duplicates.
2. Select Remove Duplicates from the Data tab.
3. Select the ''CustomerID'' column which you want to have checked under the Columns options.
4. Click OK.

Question 5

SIMULATION

Project 2 of 7: Donor List

Overview

You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.

Beginning at cell A5 of the ''$5,000 Donors'' worksheet, import the data from the tab-delimited source file, contributors.txt, located in the Documents folder. (Accept all defaults.)

A1. Select cell A5 of the ''$5,000 Donors'' worksheet where you want the source file to be imported to.
2. Click on File, then select Open.
3. Select Text Files from the Open dialog box.
4. Locate the contributors.txt file in the Documents folder, then double-click it.
5. Click Finish to complete the operation.

B1. Select cell A5 of the ''$8,000 Donors'' worksheet where you want the source file to be imported to.
2. Click on File, then select Open.
3. Select Text Files from the Open dialog box.
4. Click Finish to complete the operation.

Hurry Up and Get 25% Discount! Special Offer - Limited Time | Extra 25% Off - Ends In 00:00:00 Coupon code: SAVE25

Prepare Microsoft 77-727 Exam

With Excel 2016: Core Data Analysis, Manipulation, and Presentation Exam Questions

77-727 Desktop Practice Test Software

77-727 Questions & Answers (PDF)

77-727 Web-Based Self-Assessment
Practice Test

Latest Microsoft 77-727 Exam Questions

Hurry Up and Get 25% Discount! Special Offer - Limited Time | Extra 25% Off - Ends In 00:00:00 Coupon code: SAVE25

Prepare Microsoft 77-727 Exam

With Excel 2016: Core Data Analysis, Manipulation, and Presentation Exam Questions

77-727 Desktop Practice Test Software

77-727 Questions & Answers (PDF)

77-727 Web-Based Self-Assessment Practice Test

Latest Microsoft 77-727 Exam Questions

77-727 Web-Based Self-Assessment
Practice Test