Free Microsoft 77-727 Practice Test & Real Exam Questions
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, use the data in the "Products" and "Total" columns only to create a 3-D
Pie chart. Position the new chart to the right of the column charts.
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, use the data in the "Products" and "Total" columns only to create a 3-D
Pie chart. Position the new chart to the right of the column charts.
Correct Answer:
See explanation below.
Explanation
1. Select the data you would like to use, in this case it would be the data in the "Products" and "Total"
columns from the "Summer Sales" worksheet.
2. Click onInsert Pie Chartsituation on theInserttab then pick the 3-D Pie chart as desired.
3. Format the chart as desired by usingChart Elements, theChart Styles, or theChart Filters.
4. Drag the Pie Chart to the desired location which is to the right of the column charts.
References:
https://support.office.com/en-us/article/Add-a-pie-chart-1A5F08AE-BA40-46F2-9ED0-FF84873B7863
Explanation
1. Select the data you would like to use, in this case it would be the data in the "Products" and "Total"
columns from the "Summer Sales" worksheet.
2. Click onInsert Pie Chartsituation on theInserttab then pick the 3-D Pie chart as desired.
3. Format the chart as desired by usingChart Elements, theChart Styles, or theChart Filters.
4. Drag the Pie Chart to the desired location which is to the right of the column charts.
References:
https://support.office.com/en-us/article/Add-a-pie-chart-1A5F08AE-BA40-46F2-9ED0-FF84873B7863
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.
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.
Correct Answer:
See explanation below.
Explanation
1. Right-click the text title "Adult_Program" and clickFormat Objectthen clickAlt Text.
2. Type "Adult Enrollment" in theTitlebox as desired.
3. ClickOK.
References:
https://support.office.com/en-us/article/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-or-other-ob
Explanation
1. Right-click the text title "Adult_Program" and clickFormat Objectthen clickAlt Text.
2. Type "Adult Enrollment" in theTitlebox as desired.
3. ClickOK.
References:
https://support.office.com/en-us/article/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-or-other-ob
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.
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.)
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a
workbook containing lists of donors.
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.)
Correct Answer:
See explanation below.
Explanation
1. Select cell A5 of the "$5,000 Donors" worksheet where you want the source file to be imported to.
2. Click on File, then selectOpen.
3. SelectText Filesfrom theOpendialog box.
4. Locate the contributors.txt file in the Documents folder, then double-click it.
5. ClickFinishto complete the operation.
References:
https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391
Explanation
1. Select cell A5 of the "$5,000 Donors" worksheet where you want the source file to be imported to.
2. Click on File, then selectOpen.
3. SelectText Filesfrom theOpendialog box.
4. Locate the contributors.txt file in the Documents folder, then double-click it.
5. ClickFinishto complete the operation.
References:
https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391
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
