Project 3H: Schools

 

Excel

 

For Project 3H, you will need the following file:

e03H_Schools

You will save your workbook as:

 

Lastname_Firstname_3H_Schools

In this project, you will correct a worksheet that contains three years of enrollment

information for the elementary schools in Pacifica Bay. The worksheet also includes a

chart with the 2016 enrollment data by school. From the student files that accompany

this textbook, open the file e03H_Schools, and then save the file in your Excel Chapter 3

folder as

Lastname_Firstname_3H_Schools

To complete the project, you must find and correct errors in formulas and formatting.

Review the format and title of the pie chart and make corrections and formatting changes

as necessary. In addition to errors that you find, you should know:

•

The Chart Area should include the Tan, Accent 6 solid fill background.

The chart should include category and percentage data labels, formatted in 14 pt.

The pie chart should be in a separate worksheet named

Enrollment Analysis Chart

(Don't forget to attach the errors in separate note, so I can show them to the Professor)

 

Add a footer to both sheets, and add your name, your course name and section,

and the tags

elementary schools, enrollment

to the document properties. Save your file

and then print or submit your worksheet electronically as directed by your instructor. If

required by your instructor, print or create an electronic version of your worksheets with

formulas displayed by using the instructions in Project 1A, and then close Excel without

saving so that you do not save the changes you made to print formulas.

GO! Fix It

 

 

 

Pacifca Bay Unifed School DistrictElementary School Enrollment TrendSchool Level201420152016Coronita582535530Rogers698525470Johnson886802761McKinley562540502Raney889875801Total3,6173,2771,7612014 High School EnrollmentCoronitaRogersJohnsonMcKinleyRaney

• 1495772682-e03H_Schools-2.xlsx

ComputerScienceExpert

(11)

Status NEW Posted 26 May 2017 04:05 AM My Price 9.00

-----------

Attachments

file 1495772685-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer