77-727 試験問題を無料オンラインアクセス

Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.

Configure the worksheet so that row 9 and the WordArt remain visible as you scroll vertically.

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.

The discount price is 95 percent of the price. Modify column J to show the discount price for each car.

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 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.

Add a new worksheet named "$1,000 Donors" to the workbook.

Project 7 of 7: Farmers Market
Overview
You are the Directorof 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 "Summer Sales" worksheet, switch the rows with the columns on the first column chart.