Title: Project 2.3
Course: CGS1061: Introduction to Computers > Section: Spreadsheets

Directions: Using the Internet, school library, your textbook and other resources, complete TWO parts listed below and develop your responses in ONE document. Clearly title each part. For any information that you found in your research, type the name of the resource (web page, book title, etc.) in parenthesis at the end of the information, then create ONE References page for both parts at the end of the document. For examples, see the Syllabus.

Part A: Create a new blank spreadsheet in Excel and save it as Project 2.3A.

1. Beginning in cell A1, enter the following data in the cells. Use the AutComplete feature to save time entering sme of the repetitive data.

Male | Adult | bird | Cockatiel
Male | Young | dog | Keeshound
Female | Adult | dog | Rat terrier
Male | Adult | rabbit | American
Female | Adult | dog | American Bulldog
Female | Young | cat | Domestic Shorthair
Female | Adult | dog | Retriever
Male | Adult | bird | Cockatoo
Female | Senior | cat | Siamese
Female | Adult | dog | Akita
Male | Adult | bird | Canary
Female | Young | other | Ferret
Male | Adult | rabbit | Mini Rex
Female | Adult | other | Chinchilla
Male | Young | cat | Maine Coon

2. Insert a new column to the left of the current column A and add the names below:

Cookie
Prince
Lady
Greasy
Dutchess
Luna
Nellie
Clive
Niko
Rosie
Dusty
Misty
Pepper
Hope
Heifer

  - Insert a new column F to the right of current column E and add the following amounts:

200
30
20
15
30
10
65
150
20
90.75
15.99
75
15
15.5
5.2

  - Use the AutoFit feature on all column widths.
  - Add three new rows at the top of the worksheet.
  - In cell A1, type Adoptable pets.
  - In the third row, enter the following column headings: Name; Gender; Age; Type; Breed; Cost
  - In cell C17, change Adult to Senior
  - Delete row 12.

Save the changes and attach this document as a separate file IN ADDITION TO the documents for Parts B and C.

Part B: Reopen Project 2.3A and save it as Project 2.3B. Make the following changes to the document:

1. Rename Sheet 1 in the workbook as All Pets
2. Format cells F4:F18 to currency with 2 decimal places and a dollar sign ($)
3. Add an additional sheet and rename it Dogs
4. Sort the data on the All Pets sheet in alphbetical order by type (Column D)
5. In the Dogs worksheet, insert a row and copy the headers from the All Pets page.
6. Copy all the information on the dogs from the All Pets worksheet to the Dogs worksheet
7. Add inside borders to all filled cells.
8. Sort all the dogs in descending order (highest to lowest) by the Cost column.
9. Shade the most expensive dog's row in gray
10. Use the Table Styles to format the table.

Save the changes and attach this document as a separate file IN ADDITION TO the documents for Parts A and C.

Part C: Reopen Project 2.3B and save it as Project 2.3C. Make the following changes to the document:

1. Enter a formula in Cell F19 that calculates the average cost of all adoptable pets.
2. Beginning with row 21, type Birds, Cats, Dogs, Other and Rabbits (one in each row) in column A.
3. In column B, add the number of each type of pet so that you create a 2 column, 5 row data table.
4. Using this data table, create a column, line, pie, bar or area graph within the worksheet.
5. Move the chart to a new worksheet page named All Pets Chart.
6. Move the All Pets Chart worksheet to the end position (to the right of Dogs)
7. Add the column header % Average to current column G
8. Create a formula that calculates the percentage of average each pet costs using the average cost as an absolute cell reference.
9. Format column G to display percentages in whole numbers only.
10. Using the Max function, calculate which pet costs the highest percentage of average in in cell G19. Place its name in cell H19.
11. Using the Min function, calculate which pet costs the lowest percentage of average in in cell G20. Place its name in cell H20.

Save the changes and attach this document as a separate file IN ADDITION TO the documents for Parts A and B.

Submission: To submit your files, choose the link titled, Project 2.3, above. Use the "Browse My Computer" button in the Attach File area to attach ALL THREE your documents (Project 2.3A, Project 2.3B, and Project 2.3C). Be sure to complete your submission by choosing the "Submit" button at the bottom of the screen.

Grading: This Project will be graded using the Project Rubric. Please use it as a guide toward successful completion of this lab.