Nobody’s Pets$127,000$154,200$142,600$152,800Pets Unlimited154,500251,000213,500220,300FOCAS14,50019,20012,50014,700Wood Green Animal Shelter2,3002,5002,2004,200Pet Where Shelter1,2001,5001,4001,600ASPCA129,100154,300148,500142,400New River Animal Shelter11,2001,53011,70010,500New Pet Shelter19,30019,90018,90025,300City of Dogs Shelter10,20011,50014,20013,500Humane World29,10012,50026,70029,900     Total$498,400$628,130$592,200$615,200     Student Name    Date 1. Edward Corwin works for the Animal Rescue Foundation.  One of his responsibilities is to collect and analyze data on the animals that enter the shelters.  He has compiled a list of the cost of housing animals by the local shelters for four different years.  After following the directions below to complete the worksheet, your solution will be similar to that shown here.2. Create the workbook.  Spell check the worksheet and correct any misspelled words.3. Format the numbers using the Accounting style with zero decimal places.  Adjust the column widths so all the data is fully displayed.  4. Use the Sum function to calculate the totals for each of the columns.   Add font and fill colors to the worksheet.    Add a thick double border around the spreadsheet.5. Enter your name in cell A20 and the current date in cell A21.  Format cell A21 to display the month, day, and year date (March 14, 2001) format

The given data represents the cost of housing animals by different local shelters over a four-year period. Edward Corwin, an employee of the Animal Rescue Foundation, has collected and analyzed this data. In order to complete the worksheet, the following steps need to be followed:

1. Create the workbook: Begin by creating a new Excel workbook. This will be the platform on which the data will be organized and analyzed.

2. Spell check and correct misspelled words: It is important to ensure that the worksheet is free from any spelling errors. By using the built-in spell check feature, any misspelled words can be identified and corrected.

3. Format numbers using Accounting style: The numbers in the worksheet should be formatted using the Accounting style with zero decimal places. This style provides a professional and consistent look to the data. Additionally, adjust the column widths so that all the data is fully displayed and easily readable.

4. Calculate totals for each column using the Sum function: Use the Sum function in Excel to calculate the totals for each column. This function automatically adds up the values in a selected range of cells and displays the sum in a specified cell. By using this function, the total cost of housing animals can be calculated for each year.

5. Add font and fill colors to the worksheet: To enhance the visual appeal of the worksheet, font and fill colors can be added. Choose colors that are visually pleasing and make the data easier to read and understand.

6. Add a thick double border around the spreadsheet: To give the worksheet a polished and professional look, add a thick double border around the entire spreadsheet. This will create a clear separation between the data and any surrounding elements.

7. Enter name and current date: In cell A20, enter your name as instructed. In cell A21, enter the current date. Format cell A21 to display the date in the desired format, which in this case is “March 14, 2001”. This formatting can be accomplished using Excel’s built-in formatting options.

By following these steps, the worksheet will be complete and resemble the provided example. This organized and analyzed data will enable Edward Corwin and the Animal Rescue Foundation to make informed decisions and identify any trends or patterns in the cost of housing animals over time.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.

Click Here to Make an Order Click Here to Hire a Writer