77-727 무료 덤프문제 온라인 액세스
| 시험코드: | 77-727 |
| 시험이름: | Core Data Analysis, Manipulation, and Presentation |
| 인증사: | Microsoft |
| 무료 덤프 문항수: | 35 |
| 업로드 날짜: | 2025-08-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 "Products" worksheet, apply a number format to display the numbers in the "Weight" column to three
decimal places.
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 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 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, format the table so that every other row is shaded. Use a technique that
automatically updates the formatting if you insert a new row.
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, add the "Total" data series to the "Top Sellers" column chart. Include the
total only for "Fruits", "Vegetables", and "Jams & Honey".