Question No 1

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

Choose the Choices:

Question No 2

SIMULATION 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 M9 on the “Summer Bookings” worksheet, insert a function that calculates the number of groups containing 12 or more people even if the order of the rows is changed.

Choose the Choices:

Question No 3

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

Choose the Choices:

Question No 4

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

Choose the Choices:

1. Select the data you would like to use, in this case it would be the data in the “Products” and “Total” columns from the “Summer Sales” worksheet. 2. Click on Insert Pie Chart situation on the Insert tab then pick the 3 - D Pie chart as desired. 3. Format the chart as desired by using Chart Elements, the Chart Styles, or the Chart Filters. 4. Drag the Pie Chart to the desired location which is to the right of the column charts.

1. Select the data you would like to use, in this case it would be the data in the “Products” and “Total” columns from the “Summer Sales” worksheet. 2. Click on Insert Pie Chart situation on the Insert tab then pick the 3 - D Pie chart as desired. 3. Drag the Pie Chart to the desired location which is to the right of the column charts.

Question No 5

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

Choose the Choices:

1. Select the “Top Sellers” column chart. 2. Click on the particular data point you want to label, click Add Chart Element =, from the upper right corner next to the chart, then select Data Labels. 3. Then click Format Data Labels. 4. The Data Label Range dialog box would appear, select the data range which are the cell values you want to appear in the labels, in this case it would be the “Total” colunn .

1. Select the “Top Sellers” column chart. 2. Click on the particular data point you want to label, click Add Chart Element +, from the upper right corner next to the chart, then select Data Labels. 3. Then click Format Data Labels. 4. The Data Label Range dialog box would appear, select the data range which are the cell values you want to appear in the labels, in this case it would be the “Total” colunn for “Fruits”, “Vegetables”, and “Jams & Honey”, then click OK.

Practice Microsoft 77-727 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

77-727 Exam Features

77-727 PDF Dumps