Microsoft 77-727 Actual Free Exam Questions & Community Discussion
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.
On the "Summer Bookings" worksheet, remove the table functionality from the table. Retain the cell
formatting and location of the data.
Overview
You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next
six months.
On the "Summer Bookings" worksheet, remove the table functionality from the table. Retain the cell
formatting and location of the data.
Correct Answer:
See explanation below.
Explanation
1. ClickDesignfrom the Ribbon onTable Tools.
2. In theToolsgroup, click onConvert to Range.
OR
1. Right-click thetablethen click on Table then pressConvert to Range.
References:
https://support.office.com/en-us/article/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786
Explanation
1. ClickDesignfrom the Ribbon onTable Tools.
2. In theToolsgroup, click onConvert to Range.
OR
1. Right-click thetablethen click on Table then pressConvert to Range.
References:
https://support.office.com/en-us/article/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786
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.
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.
Correct Answer:
See explanation below.
Explanation
1. To check the accessibility select theReviewtab from the ribbon.
2. SelectCheck Accessibility.
3. Review the results.
4. Exit theAccessibility Checker.
5. Right-click on the worksheet then clickFormatand then clickAlt Text.
6. Type "Tree Nursery Inventory" in theDescriptionbox.
7. ClickOK.
References:
https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issues-a16f6de0-2f39
Explanation
1. To check the accessibility select theReviewtab from the ribbon.
2. SelectCheck Accessibility.
3. Review the results.
4. Exit theAccessibility Checker.
5. Right-click on the worksheet then clickFormatand then clickAlt Text.
6. Type "Tree Nursery Inventory" in theDescriptionbox.
7. ClickOK.
References:
https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issues-a16f6de0-2f39
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.
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.
Correct Answer:
See explanation below.
Explanation
1. In cell M10 on the "Summer Bookings", insert the followingSUMIFformula: "=SUMIF(G6:G24, ">= 12",
I6:I24)."'
References:
https://support.office.com/en-us/article/SUMIF-function-169B8C99-C05C-4483-A712-1697A653039B
Explanation
1. In cell M10 on the "Summer Bookings", insert the followingSUMIFformula: "=SUMIF(G6:G24, ">= 12",
I6:I24)."'
References:
https://support.office.com/en-us/article/SUMIF-function-169B8C99-C05C-4483-A712-1697A653039B
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
On the "Customers" worksheet, enter a formula in cell N2 that uses an Excel function to return the average age
of the customers based on the values in the "CurrentAge" column.
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
On the "Customers" worksheet, enter a formula in cell N2 that uses an Excel function to return the average age
of the customers based on the values in the "CurrentAge" column.
Correct Answer:
See explanation below.
Explanation
1. Select cell N2 on the "Customers" worksheet, which is where you want the Excel function to return the
result to.
2. In theAddressbar, type the average function syntax;=AVERAGE(K1:K101).
References:
https://support.office.com/en-us/article/AVERAGE-function-047BAC88-D466-426C-A32B-8F33EB960CF6
Explanation
1. Select cell N2 on the "Customers" worksheet, which is where you want the Excel function to return the
result to.
2. In theAddressbar, type the average function syntax;=AVERAGE(K1:K101).
References:
https://support.office.com/en-us/article/AVERAGE-function-047BAC88-D466-426C-A32B-8F33EB960CF6
0
0
0
10