Download Excel 2016-Core Data Analysis, Manipulation, and Presentation.actualtests.77-727.2019-05-18.1e.11q.vcex

File Info

Exam	Excel 2016: Core Data Analysis, Manipulation, and Presentation
Number	77-727
File Name	Excel 2016-Core Data Analysis, Manipulation, and Presentation.actualtests.77-727.2019-05-18.1e.11q.vcex
Size	3.99 Mb
Posted	May 18, 2019
Downloads	141

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

Question 1

Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.

Check the spreadsheet for accessibility problems. Correct the error by adding “Tree Nursery Inventory” as an alternative text file. You do not need to fix the warning.

A: See explanation below.

Correct Answer: 1

1. To check the accessibility select the Review tab from the ribbon.
2. Select Check Accessibility.
3. Review the results.
4. Exit the Accessibility Checker.
5. Right-click on the worksheet then click Format and then click Alt Text.
6. Type “Tree Nursery Inventory” in the Description box.
7. Click OK.
References:
https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issues-a16f6de0-2f39-4a2b-8bd8-5ad801426c7f

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.

Configure the “Car Inventory” worksheet so the column headings in row 9 appear on all printed pages.

A: See explanation below.

Correct Answer: 1

1. On the “Car Inventory” worksheet, click Print Titles from the Page Setup group, situated on the Page Layout tab.
2. Under Print Titles, on the Sheet tab, type the reference of the row you want to reappear (row 9) in the Rows to repeat at top box.
References:
https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-D3550133-F6A1-4C72-AD70-5309A2E8FE8C

Question 3

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

A: See explanation below.

Correct Answer: 1

1. Click Find & Select from the Editing group situated on the Home tab.
2. Click Replace.
3. Type the text “Pickup” in the Fine what box.
4. Click Options to further define the search, specify the “Car Inventory” worksheet select Sheet in the Within box.
5. Type “Truck” in the Replace with box.
6. Click Find All, and then click Replace All.
7. Finalize by clicking OK.
References:
https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

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.

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

A: See explanation below.

Correct Answer: 1

1. Right-click the text title “Adult_Program” and click Format Object then click Alt Text.
2. Type “Adult Enrollment” in the Title box as desired.
3. Click OK.
References:
https://support.office.com/en-us/article/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-or-other-object-44989b2a-903c-4d9a-b742-6a75b451c669#bkmk_o2016_2013

Question 5

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.

A: See explanation below.

Correct Answer: 1

1. In cell M9, on the “Summer Bookings” worksheet, insert the following COUNTIF formula: “=COUNTIF(G6:G24, >= 12”)”
References:
https://support.office.com/en-us/article/count-numbers-greater-than-or-less-than-a-number-453b0ccc-cfaa-4332-ad02-6e148e01aa0a

CONNECT US

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset