Microsoft 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation Exam Practice Test

Page: 1 / 14
Total 35 questions

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

Unhide the ''Summary'' worksheet.



Answer : A

Question 2

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.



Answer : A

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



Answer : A

Question 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, add the ''Total'' data series to the ''Top Sellers'' column chart. Include the total only for ''Fruits'', ''Vegetables'', and ''Jams & Honey''.



Answer : B

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



Answer : A

Page:    1 / 14   
Total 35 questions