Download Excel 2016: Core Data Analysis, Manipulation, and Presentation.77-727.ActualTests.2019-05-18.11q.vcex
| Vendor: | Microsoft |
| Exam Code: | 77-727 |
| Exam Name: | Excel 2016: Core Data Analysis, Manipulation, and Presentation |
| Date: | May 18, 2019 |
| File Size: | 4 MB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
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.
- See explanation below.
Correct answer: 1
Explanation:
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 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.
- See explanation below.
Correct answer: 1
Explanation:
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 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”.
- See explanation below.
Correct answer: 1
Explanation:
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 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.
- See explanation below.
Correct answer: 1
Explanation:
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 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.
- See explanation below.
Correct answer: 1
Explanation:
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 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
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!