Microsoft Core Data Analysis, Manipulation, and Presentation - 77-727무료 덤프문제 풀어보기
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.)
정답:
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 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.
정답:
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.
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]".
정답:
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.
정답:
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