77-727 무료 덤프문제 온라인 액세스

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 by Order" worksheet, use an Excel data tool to remove all records with duplicate
"CustomerID" values from the table. Do not remove any other records.

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.

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 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, add the title "New Products" to the column chart. Label the vertical axis
"Gross Sales" and the horizontal axis "Months".

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 "Summer Sales" worksheet, use the data in the "Products" and "Total" columns only to create a 3-D
Pie chart. Position the new chart to the right of the column charts.