Expert answer:Excel Project
Solved by verified expert:i will sent file please you must folow the step one by one is really important
excel_project__1_4555454545.xlsx
excel_project_instructions_345454545454.pdf
excel_project_scoring_245454545.pdf
Unformatted Attachment Preview
NAME
BENNINGTON
BURLINGTON
COLCHESTER
ESSEX
SOUTH BURLINGTON
RUTLAND
BARRE CITY
BRATTLEBORO CITY
HARTFORD
MILTON
TOTAL
AVERAGE
MAXIMUM
COUNT
2016 State Population
Expected Increase
2017 Projected Population
2012
626,562
379
2013
2014
2015
2016 Projected 2017
Population Increase6%
Excel Project Instructions
1. Open Excel Project file from Moodle class file listing in the Excel 2016 folder.
2. Save the file as Excel Project – Your Name
3. Enter the missing data so your spreadsheet looks like the illustration below:
4. Type Vermont Population Statistics in cell A1.
5. Center the title you just entered in cell A1 across cells A1 through H1.
6. Format the title in cell A1 to be 20 point, Times New Roman font and bold. Color the text a dark
blue.
7. Edit cells B10 and B11 to remove the word “City” from the town names.
8. Use AutoFit to adjust columns A through J.
9. Create a formula in cell C21 that calculates the total expected 2017 population.
The formula should be 2016 State Population plus Expected Increase.
10. Create a formula in cell H4 that calculates the projected 2017 population for Bennington.
The formula should be the Bennington 2016 Population number plus the Bennington 2016
Population number multiplied by the Population Increase percentage.
11. Modify the formula so that the reference to the Population Increase percentage is an absolute
reference.
12. Using the Fill Handle, copy the formula from cell H4 to the cells H5 through H13.
13. Insert a blank row between rows 13 & 14.
14. Change the values in cells D10 (Barre/2013), E5 (Burlington/2014) and F12 (Hartford/2015) to
N/A.
15. Format the values for cells D10, E5 and F12 so they are right aligned and match the alignment of
the other entries.
16. Using Autosum, total the numbers in column C so that the resulting total appears in cell C15.
Note: Make sure you are not including the year title in your calculation.
17. Copy the formula in cell C15 to cells D15 through H15.
18. Create a formula in cell C16 that calculates the average population for 2012.
19. Create a formula in cell C17 that calculates the maximum population for 2012.
20. Create a formula in cell C18 that calculates the total number of numeric entries for 2012.
21. Copy the formulas in cells C16, C17 & C18 to columns D through H.
22. Use AutoFit to adjust all columns again so that the numbers display correctly
23. Use Conditional Formatting to format the values in cells G4:G13 so that any values that are less
than 10,000 are formatted with light red fill with dark red text.
24. Format all the numbers in columns C through H to that they are in Comma Style and have zero
decimal places.
25. Format the Year Titles in cells C3 through H3 as text.
26. Format the Year Titles in cells C3 through H3 to make them 12 Point, Times New Roman font,
bold, underlined and right aligned.
27. Delete the row for Milton.
28. Add a comment to G5 that says “Even Burlington has seen a population decrease.”
29. Create a clustered bar chart that plots the population statistics for 2012 through 2016 for all
towns in the worksheet.
Note: Do not include the Projected 2016 figures, the totals, the average, maximum or count
amounts.
30. Move the chart so it appear to the right of the numbers. Resize the chart as necessary.
31. Change the title of the Chart to Vermont Population Statistics.
32. Change the chart type to a clustered column chart.
33. Rename the Sheet1 tab Population and color the tab green.
34. Add an additional tab. Name that tab Income and color that tab yellow.
35. Switch back to the Population tab.
36. Change the page orientation to landscape.
37. Change the scaling so that the worksheet will print on one page.
38. Turn off gridlines for both viewing and printing.
39. Switch to Page Layout view.
40. Add your name to the left side of the header. Add the current date to the right side of the
header.
41. Save your file.
42. Email the completed file to your instructor.
The main part of your resulting worksheet should look similar to the following:
Excel Project Scoring
Student Name:
Partial points for each item are possible if some elements are partially correct.
Possible Actual
Points
Points
Project Element
5
Data entered correctly
5
Title centered across columns
correctly and formatted correctly
5
Column titles formatted correctly
5
Town names edited correctly
5
Column widths have been adjusted
using AutoFit.
5
Correct basic formula calculation
for Projected State Population
5
Correct complex calculation for
Projected 2016 Bennington
population formula.
Absolute cell reference used
correctly in formulas.
5
5
5
All formulas have been copied
correctly to adjacent columns/rows
per instructions.
SUM function entered correctly
5
Other Functions created correctly.
5
Numbers formatted correctly
5
Rows deleted and inserted
correctly.
Feedback
Possible Actual
Points
Points
Project Element
5
Comments added correctly.
5
Chart created & moved correctly
5
Conditional Formatting applied
correctly.
5
Worksheet tabs renamed and
colored correctly.
5
Page orientation changed to
landscape and scaling applied.
5
Gridlines removed.
5
Header/Footer information added
correctly.
100
Total Points
Feedback
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades