Excel Work for a project to be completed

Excel Work for a project to be completed

Order ID: 89JHGSJE83839

Style: APA/MLA/Harvard/Chicago

Pages: 5-10

Instructions:

Question Description
You are developing a demographic analysis of Miami-Dade County’s population. Follow the steps to produce the results shown in the figures at the end of this document.
Notes:
This workbook has 2 worksheets: the Documentation worksheet (for the history of this workbook), and the Population worksheet. You will create a 3rd worksheet named Selected Demographics later in the project. Be sure to work on the correct worksheet as indicated in the instructions.
You should use cell references in all formulas – do not re-enter data.
Use the images at the end of this document to validate the correctness of your work.
1. Create a Line Chart with Markers showing the total population by age segments, as shown in Figure 2. Position this chart at B19:G35. Format as follows:
a. Change the chart title to Total Population by Age Segments.
b. Rotate the text in the horizontal axis to 270 degrees. (Hint: Use the Text direction dropdown list for this.)
c. Change the line and marker colors to Orange Accent 2 Darker 25%.
d. Format the vertical axis options to have major units set to 50,000 and minor units set to 25,000.
e. Add Primary Major Vertical gridlines and Primary Minor Horizontal gridlines.
f. Format the plot area to have no border. Set the fill to be gradient, with a preset gradient named Light Gradient Accent 2.
g. Add a border to the entire chart with color Orange Access 2 Darker 50%.
2. Set the page orientation to Landscape, and the Margins to Narrow. Open the Custom Margins setting and adjust the settings provided by the Narrow choice so that top and bottom margins are now set to 0.25. Set Col. A to repeat on each page. You should have 3 pages, with data through age 30-34 and chart on the first page, and data from age 35-39 to 65-69 on the second page, and the rest of the data on the last page. There should be no scaling for print.
3. Insert a page footer with your name in the right-hand section, and the date you completed this worksheet in the right section. Use Page Break Preview to ensure that your print options are set up correctly on the Population worksheet.
4. Create a new worksheet named Selected Demographics. Move it to the last position in the tabs.

5. Return to the Population worksheet to create a Line Chart showing all race and age segments, as shown in Figure 3. Format at follows:
a. Move this chart to the Selected Demographics worksheet, and position it at B3:M26.
b. Change the chart title to Population by Race and Age Segments.
c. Rotate the text in the horizontal axis to -45% using the Custom angle option.
d. Set the Maximum Bounds on the vertical axis to 60000. Set the Major units to 10,000 and the Minor units to 5,000.
e. Add Primary Major Vertical gridlines and Primary Minor Horizontal gridlines.
6. Return to the Population worksheet to create a Clustered Column Chart showing the black population by age segment, as shown in Figure 4. Format this chart as follows:
a. Move this chart to the Selected Demographics worksheet and position it at B28:M42.
b. Move the legend to the top.
c. Change the title to Black Population by Age Segment.
d. Set the Maximum Bounds on the vertical axis to 25000. Set the Major units to 5,000 and the Minor units to 2,500.
e. Add Primary Major Vertical gridlines and Primary Minor Horizontal gridlines.
7. Return to the Population worksheet to create a 3-D pie chart showing senior citizens’ totals by age segment as shown in Figure 5. Include ages 60 and above. Format this chart as follows:
a. Move this chart to the Selected Demographics worksheet and position it at O3:U18.
b. Change the chart title to Senior Citizens by Age Segment.
c. Change the chart style to Style 4.
d. Move the legend to the top.
e. Add data labels on the outside ends.
f. Format data labels to show percentages and the legend key.
g. Explode the slice for age 65-69.
8. On the Selected Demographics worksheet, add a title of Selected Demographics in cell B1. Merge and center B1 across B1:U1, and format with the Title style.
9. Set the page orientation to Landscape, and the Margins to Narrow.
10. Use Page Break Preview to remove any page breaks on the Selected Demographics worksheet.
11. Use File – Print to determine if you need to do custom scaling to make all charts appear on a single page.
Save your file, close Excel, and sub

RUBRIC
Excellent Quality 95-100%	Introduction 45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.		Literature Support 91-84  points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.			Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score 50-85%	40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.		83-76  points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.			52-49  points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality 0-45%	37-1 points The background and/or significance are missing. No search history information is provided.		75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.			48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Excel Work for a project to be completed

Excel Work for a project to be completed

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!