77-727 Questions and Answers
Question # 1
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.
Question # 2
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.
Question # 3
Project 6 of 7: Bike Tours
Overview
You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next six months.
In cell M9 on the “Summer Bookings†worksheet, insert a function that calculates the number of groups containing 12 or more people even if the order of the rows is changed.
