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

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.

View Answer

Answer: See explanation below.