Dumpsbuddy logo
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.
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,sortthe 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.
TESTED 21 Nov 2024
