Free and Premium Microsoft 77-727 Dumps Questions Answers

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.

Add the Alternative Text Title “Adult Enrollment” to the “Adult_Program” table.

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 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 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, apply Style 3 and Monochromatic Color 2 (Monochromatic Palette 2) to the 3-D Pie chart.