Excel+-+Basketball+Assignment

Microsoft Excel 2007 Youth Basketball League Assignment You are the coordinator of your town’s youth basketball league. You want to find cheaper sources for supplies for the league, especially trophies and uniforms. You will start by searching the Internet to find an inexpensive source for trophies, and then create a formatted worksheet listing this information.


 * 1) Start Excel and open a new, blank workbook.
 * 2) Save the workbook as last name_basketball
 * 3) Type Trophy Prices in the first row.
 * 4) Use your favorite search provider and conduct a search on the Internet for Web sites that sell trophies. Find at least five Web sites from which you can buy trophies. Examine each Web site and look for the same or similar trophies.
 * 5) Type the name of each Web site in one column, the URL of the Web site in the next column, a description of the trophy in the next column, and then the price for the trophy you chose in the next column.
 * 6) In subsequent rows, figure out the average, minimum, and maximum costs of a trophy according to the information you found. Label each value.
 * 7) Format all cells containing prices in the Accounting Number format. Decrease the decimal places to zero.
 * 8) Insert a new row below the top row, and then insert the current date, formatted as in the Short Date format.
 * 9) Merge and center the contents of cell A1 across columns A through D, apply the Cambria (Headings) font, and then increase the font size to 22. Change the font color to a dark red color in the theme color palette.
 * 10) Adjust the widths of all columns to accommodate the data.
 * 11) Format the table with a built-in table style.
 * 12) Put a double-line border around the minimum, maximum, and average labels and values.
 * 13) Add data bars to the minimum, maximum, and average values.
 * 14) Bonus: Use conditional formatting to highlight all the cells in the table that are greater than the average price.
 * 15) Create a custom footer with Your Name in the left section, the page number in Page 1 of ? format in the center section and the text, “Printed on:”, followed by today’s date using the Date button in the right section.
 * 16) Change the sheet tab name to Trophies, and the tab color of the sheet tab to a color that matches the table style you chose.
 * 17) Save your changes. Make sure you save the completed assignment in the Computer folder on the Public Drive.