Microsoft Core Data Analysis, Manipulation, and Presentation - 77-727 Exam Practice Test
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/
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 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