Скачать или смотреть Excel Module 4 Sam Project A |Alanis Parks Department |Analyze and Chart Financial Data| NP EX19 4a

Excel Module 4 Sam Project A |Alanis Parks Department |Analyze and Chart Financial Data| NP EX19 4a

#Excel Module 4 Sam Project A#Module 4 Sam Project A#Alanis Parks Department#Module 4: SAM Project 1a#ANALYZE AND CHART FINANCIAL DATA#NP_EX19_4a_FirstLastName_1.xlsx#Project A#Sam Project A |Alanis Parks Department#Excel Module 4#Module 4 Sam#NP_EX19_4a
#EX19_4a#Sam Project A |Alanis ParksAlanis Parks Department#Alanis
#FINANCIAL DATA
#Sam Project A



Contact:

WhatsApp : +92 3255683413
Email : [email protected]

Direct WhatsApp link
https://wa.link/d27yzv



Alanis Parks Department
ANALYZE AND CHART FINANCIAL DATA

GETTING STARTED
• Open the file NP_EX19_4a_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as NP_EX19_4a_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• With the file NP_EX19_4a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling spending data in preparation for a city bond offering for park funding. She wants to use Excel to create charts to illustrate some of her data and to apply a function to calculate the potential monthly and yearly costs to the city of different bond scenarios.

Switch to the Spending worksheet. In the range E5:E10, add Conditional Formatting to show Solid Blue Data Bars.
2. In the range F5:F10, add Line sparklines based on the data in the range B5:E10.
3. Apply the Blue, Accent 1, Darker 25% (5th column, 5th row in the Theme Colors palette) sparkline color to the range F5:F10.
4. Gudrun has created a pie chart representing the percentage of the parks' budget that went to each park in 2018. Modify the chart in the range G2:O20 as follows:
a. Enter 2018 Park Spending as Percentage of Total as the chart title.
b. Change the data labels to include the Category as well as the Percentage, and position the labels in the Outside End location.
c. Remove the Legend from the chart.
5. Gudrun would like a pie chart representing the percentage of the parks' budget that would go to each park in 2021.
a. Create a 2-D Pie chart based on the data in the range E5:E9 and using the category labels in the range A5:A9.