77-727 Web TestEngine demo

Exit VCEDump 77-727 Excel 2016 Core Data Analysis, Manipulation, and Presentation
Question 1 of 6
0% complete
Q1 Lab

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.

Question 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagramQuestion 1 diagram

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.

Not auto-scored - compare your configuration against the model answer.

Previous Check answer

Sign in to mark questions

Sign in to save marked questions and return to this demo.

Sign in