Online Access Free 77-727 Practice Test

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 M10 on the "Summer Bookings" worksheet, insert a function that calculates the total amount of sales
from the "Total" column for groups containing 12 or more people even if the order of the rows is changed.

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.

Project 7 of 7: Farmers Market
Overview
You are the Director of a local farmers' market. You are creating and modifying charts for a report which
shows the amounts and variety of products sold during the season.


On the "Spring Sales" worksheet, apply Style 3 and Monochromatic Color 2 (Monochromatic Palette 2) to the
3-D Pie chart.

Project 4 of 7: Car Inventory
Overview
You manage the office of a used car business. You have been asked to prepare the inventory list for a big
annual sale.

Simultaneously replace all instances of the text "Pickup" with the text "Truck".

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.

On the "$5,000 Donors" worksheet, hyperlink cell C3 to the email address "[email protected]".