Microsoft Core Data Analysis, Manipulation, and Presentation - 77-727 FREE EXAM DUMPS QUESTIONS & ANSWERS
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Hiderows 29 and 30.
Overview
You are updating the inventory worksheet for a local tree farm.
Hiderows 29 and 30.
Correct Answer:
See explanation below.
Explanation
1. Select the rows you want to hide, in this case rows number 29 and 30 by clicking on them.
2. Right-click on the selected rows then click Hide.
References:
https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f
Explanation
1. Select the rows you want to hide, in this case rows number 29 and 30 by clicking on them.
2. Right-click on the selected rows then click Hide.
References:
https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f
Project 4 of 7: Car Inventory
Overview
You manage the office of a used car business. You have been asked to prepare the inventory list for a big
annual sale.
Apply the Rose, Table Style Light 17 (Table Style Light 17) to the "Inventory" table.
Overview
You manage the office of a used car business. You have been asked to prepare the inventory list for a big
annual sale.
Apply the Rose, Table Style Light 17 (Table Style Light 17) to the "Inventory" table.
Correct Answer:
See explanation below.
Explanation
1. On the "Inventory" table, click on any cell.
2. Click onFormat as Tablefrom theHometab.
3. Select the Rose, Table Style Light 17 as desired.
References:
https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370
Explanation
1. On the "Inventory" table, click on any cell.
2. Click onFormat as Tablefrom theHometab.
3. Select the Rose, Table Style Light 17 as desired.
References:
https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370
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.
Navigate to the range named "Oregon", and remove the contents of the selected cells.
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a
workbook containing lists of donors.
Navigate to the range named "Oregon", and remove the contents of the selected cells.
Correct Answer:
See explanation below.
Explanation
1. ClickFind & Selectfrom theHometab then click onGo To.
OR
1.Press Ctrl+G on the keyboard.
2. Double-click the name range you want, in this case "Oregon".
3. Delete the contents in the selected cells by pressing Delete on your keyboard.
References:
https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03-968905B244E6
Explanation
1. ClickFind & Selectfrom theHometab then click onGo To.
OR
1.Press Ctrl+G on the keyboard.
2. Double-click the name range you want, in this case "Oregon".
3. Delete the contents in the selected cells by pressing Delete on your keyboard.
References:
https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03-968905B244E6