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

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.

Navigate to the range named "Oregon", and remove the contents of the selected cells.

Project 5 of 7: City Sports
Overview
The city events manager wants to analyze the enrollment changes over the past five years for various adult and
youth sports programs. You have been tasked to prepare tables for the analysis.


On the "Adult Program" worksheet, insert aColumnsparkline for each sport that shows the enrollment for the
past five years.

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.

Modify the cell formatting of cell J9 to display the text on two lines.

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

Hiderows 29 and 30.

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.