11.11 Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

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

Page: 1 / 4
Total 35 questions

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

Question 1

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.

Question # 1

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.

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.

Question # 2

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

Question # 3

Question # 3

On the “Spring Sales” worksheet, apply Style 3 and Monochromatic Color 2 (Monochromatic Palette 2) to the 3-D Pie chart.

Options:

Question 4

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.

Question # 4

Beginning at cell A5 of the “$5,000 Donors” worksheet, import the data from the tab-delimited sourcefile, contributors.txt, located in the Documents folder. (Accept all defaults.)

Options:

Question 5

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.

Question # 5

Arrange the worksheets so that “$5,000 Donors” is first.

Options:

Page: 1 / 4
Total 35 questions