Microsoft 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation Online Training

The following 77-727 free online test questions are collected from real test,you can practice to know the exam pattern and correct answers.If this 77-727 exam updated, we will share it to you,pls pay attention to our site.

Page 1 of 2

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, format the table so that every other row is shaded. Use a technique that automatically updates the formatting if you insert a new row.

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

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

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 “Products” worksheet, apply a number format to display the numbers in the “Weight” column to three decimal places.

5. 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, use an automatic formatting method to format cells in the “OrderTotal” column that contain above-average values by applying Green Fill with Dark Green Text. Use a technique that automatically updates the formatting if the column values change.

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

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

8. 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.)

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

Navigate to the range named “Oregon”, and remove the contents of the selected cells.

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

Add a new worksheet named “$1,000 Donors” to the workbook.


 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

  • Sign up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
We do not share your personal details with anyone.