최신Microsoft Core Data Analysis, Manipulation, and Presentation - 77-727무료샘플문제
문제1
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.
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.
정답:
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
문제2
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,sortthe table to order the records by the "CountryOrRegion" field, with
customers in the United States first and customers in Canada second.
Then sort the customers in each country alphabetically (from A to Z) by the "StateOrProvince" field.
Finally, sort the customers in each state or province in ascending order by the 'PostalCode" field.
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,sortthe table to order the records by the "CountryOrRegion" field, with
customers in the United States first and customers in Canada second.
Then sort the customers in each country alphabetically (from A to Z) by the "StateOrProvince" field.
Finally, sort the customers in each state or province in ascending order by the 'PostalCode" field.
정답:
See explanation below.
Explanation
1. Select a cell in the "CountryOrRegion" field on the "Customers" worksheet.
2. Select Sort from theSort & Filtergroup in theDatatab.
3. In theSortdialog box, underColumnin theSort bybox, Select the "CountryOrRegion" field.
4. Under theSort Onoption, select the type of sort desired, in this caseValues, to sort by text.
5. UnderOrder, selectCustom List, then set it for customers in the United States to appear first, then the
customers in Canada.
6. Then to add another column to sort by, clickAdd Level.
7. In theSortdialog box, underColumnin theSort bybox, Select the "StateOrProvince" field.
8. Under theSort Onoption, selectValues.
9. UnderOrder, selectA to Z.
10. Add a final column by clickingAdd Level.
11. In theSortdialog box, underColumnin theSort bybox, Select the "PostalCode" field.
12. UnderSort On, selectValues.
13. UnderOrder, selectSmallest to Largest.
14. ClickOK.
References:
https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654
Explanation
1. Select a cell in the "CountryOrRegion" field on the "Customers" worksheet.
2. Select Sort from theSort & Filtergroup in theDatatab.
3. In theSortdialog box, underColumnin theSort bybox, Select the "CountryOrRegion" field.
4. Under theSort Onoption, select the type of sort desired, in this caseValues, to sort by text.
5. UnderOrder, selectCustom List, then set it for customers in the United States to appear first, then the
customers in Canada.
6. Then to add another column to sort by, clickAdd Level.
7. In theSortdialog box, underColumnin theSort bybox, Select the "StateOrProvince" field.
8. Under theSort Onoption, selectValues.
9. UnderOrder, selectA to Z.
10. Add a final column by clickingAdd Level.
11. In theSortdialog box, underColumnin theSort bybox, Select the "PostalCode" field.
12. UnderSort On, selectValues.
13. UnderOrder, selectSmallest to Largest.
14. ClickOK.
References:
https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654
문제3
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.
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.
정답:
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/
문제4
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Change themarginsto 1.0'' (2.54 cm) on the top and bottom, 0.75'' (1.90 cm) on the left and right, with a 0.5''
(1.27 cm) header and footer.
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Change themarginsto 1.0'' (2.54 cm) on the top and bottom, 0.75'' (1.90 cm) on the left and right, with a 0.5''
(1.27 cm) header and footer.
정답:
See explanation below.
Explanation
1. Select the worksheet you want to apply the margin changes to.
2. Select Margins in thePage Setupgroup from thePage Layouttab.
3. ClickCustom Margins, then in theTopandBottomdialog box enter 1.0'' (2,54cm), in theLeftandRightdialog
box enter 0.75''(1.90cm), and enter 0.5''(1.27cm) in theHeaderandFooterdialog box.
References:
https://support.office.com/en-us/article/Set-page-margins-before-printing-a-worksheet-353F52FC-0D2C-4958-91
Explanation
1. Select the worksheet you want to apply the margin changes to.
2. Select Margins in thePage Setupgroup from thePage Layouttab.
3. ClickCustom Margins, then in theTopandBottomdialog box enter 1.0'' (2,54cm), in theLeftandRightdialog
box enter 0.75''(1.90cm), and enter 0.5''(1.27cm) in theHeaderandFooterdialog box.
References:
https://support.office.com/en-us/article/Set-page-margins-before-printing-a-worksheet-353F52FC-0D2C-4958-91