Free Microsoft 77-727 Practice Test & Real Exam Questions
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.
Unhide the "Summary" worksheet.
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.
Unhide the "Summary" worksheet.
Correct Answer:
See explanation below.
Explanation
1. SelectFormatfrom theHometab then chooseHide and Unhidethen selectUnhide.
OR
1. Hold on the Ctrl button on the keyboard and choose all the worksheet tabs then choose theUnhideoption in
the right menu.
2. Click on the first worksheet tab, then hold down the Shift key on the keyboard as you click on the last
worksheet tab, then choose theUnhideoption.
OR
1. From theViewtab, clickCustom Viewsin theWorkbook Viewsgroup.
2. Click the "Summary" view which is hidden, then clickShow.
References:
https://www.isunshare.com/blog/hide-or-unhide-sheets-in-excel-2016/
Explanation
1. SelectFormatfrom theHometab then chooseHide and Unhidethen selectUnhide.
OR
1. Hold on the Ctrl button on the keyboard and choose all the worksheet tabs then choose theUnhideoption in
the right menu.
2. Click on the first worksheet tab, then hold down the Shift key on the keyboard as you click on the last
worksheet tab, then choose theUnhideoption.
OR
1. From theViewtab, clickCustom Viewsin theWorkbook Viewsgroup.
2. Click the "Summary" view which is hidden, then clickShow.
References:
https://www.isunshare.com/blog/hide-or-unhide-sheets-in-excel-2016/
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.
On the "$5,000 Donors" worksheet, hyperlink cell C3 to the email address "[email protected]".
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a
workbook containing lists of donors.
On the "$5,000 Donors" worksheet, hyperlink cell C3 to the email address "[email protected]".
Correct Answer:
See explanation below.
Explanation
1. Click on cell C3.
2. Enter the following formula: "=HYPERLINK([email protected], C3)
References:
https://support.office.com/en-us/article/HYPERLINK-function-333C7CE6-C5AE-4164-9C47-7DE9B76F577F
Explanation
1. Click on cell C3.
2. Enter the following formula: "=HYPERLINK([email protected], C3)
References:
https://support.office.com/en-us/article/HYPERLINK-function-333C7CE6-C5AE-4164-9C47-7DE9B76F577F
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.
On the "Adult Program" worksheet, insert aColumnsparkline for each sport that shows the enrollment for the
past five years.
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.
On the "Adult Program" worksheet, insert aColumnsparkline for each sport that shows the enrollment for the
past five years.
Correct Answer:
See explanation below.
Explanation
1. On the "Adult Program" worksheet, select the area you want the sparkline to be inserted.
2. Click Column in theSparklinesgroup from theInserttab.
3. Enter the range of cells in theData Rangebox, in this caseA10:A19.
OR
3. Select the range of cells by temporarily collapsing the dialog box and manually selecting the cells.
4. ClickOKand theSparkline Toolswill appear, theDesigntab can be used to customize the sparklines.
References:
https://support.office.com/en-us/article/analyze-trends-in-data-using-sparklines-be6579cf-a8e3-471a-a459-87361
Explanation
1. On the "Adult Program" worksheet, select the area you want the sparkline to be inserted.
2. Click Column in theSparklinesgroup from theInserttab.
3. Enter the range of cells in theData Rangebox, in this caseA10:A19.
OR
3. Select the range of cells by temporarily collapsing the dialog box and manually selecting the cells.
4. ClickOKand theSparkline Toolswill appear, theDesigntab can be used to customize the sparklines.
References:
https://support.office.com/en-us/article/analyze-trends-in-data-using-sparklines-be6579cf-a8e3-471a-a459-87361
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 "Spring Sales" worksheet, add the title "New Products" to the column chart. Label the vertical axis
"Gross Sales" and the horizontal axis "Months".
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 "Spring Sales" worksheet, add the title "New Products" to the column chart. Label the vertical axis
"Gross Sales" and the horizontal axis "Months".
Correct Answer:
See explanation below.
Explanation
1. Click on the title on the "Spring Sales" worksheet, then type "New Products".
2. You can edit theFontof the title from the mini-toolbar that appearsORfrom theHometab.
3. Click directly on either the x-axisory-axis in the chart OR click theChart Elementsbutton.
4. For editing the x-axis which is the horizontal category then type "Months".
5. Do the same to edit the y-axis which is the vertical category and type "Gross Sales".
6. You can further edit the text of the data in either of the axis as desired.
References:
https://www.dummies.com/software/microsoft-office/excel/how-to-edit-chart-titles-in-excel-2016/
Explanation
1. Click on the title on the "Spring Sales" worksheet, then type "New Products".
2. You can edit theFontof the title from the mini-toolbar that appearsORfrom theHometab.
3. Click directly on either the x-axisory-axis in the chart OR click theChart Elementsbutton.
4. For editing the x-axis which is the horizontal category then type "Months".
5. Do the same to edit the y-axis which is the vertical category and type "Gross Sales".
6. You can further edit the text of the data in either of the axis as desired.
References:
https://www.dummies.com/software/microsoft-office/excel/how-to-edit-chart-titles-in-excel-2016/
