March Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

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

Demo: 5 questions
Total 35 questions

Excel 2016: Core Data Analysis, Manipulation, and Presentation Questions and Answers

Question 1

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.

On the “Adult Program” worksheet, insert aColumnsparkline for each sport that shows the enrollment for the past five years.

Options:

Question 2

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.

Simultaneously replace all instances of the text “Pickup” with the text “Truck”.

Options:

Question 3

Project 7 of 7: Farmers Market

Overview

You are the Directorof 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, switch the rows with the columns on the first column chart.

Options:

Question 4

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.

On the “Youth Program” worksheet, create a table from the cell range A9:G19. Include row 9 as headers.

Options:

Question 5

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

Options:

Demo: 5 questions
Total 35 questions