Introduction
Use the information given below to create a spreadsheet that totals up the two rounds of golf from the tournament and also finds the low score.

Objectives and Skills

• Create a worksheet in a spreadsheet program
• Use formulas for calculations
• Center titles
• Use functions like SUM(), AVG(), MAX(), MIN()
• Use borders, lines, shading to enhance the worksheet
• Adjust column widths and row heights

Instructions

1. Open a spreadsheet program
2. The report titles need to be bolded and centered if possible.
3. Use italics on the "Prepared by...." line.
4. Double space between the title lines and the column headings.
5. Column headings need to be bolded, underlined, and aligned appropriately.
6. Format numbers to whole numbers.
7. Use a formula to add the first nine holes to the second nine holes for the 18 hole total.
8. Use a function to find the low score from the five scores in each column.
9. Use lines to separate the scores from the Low Score at the bottom. Add a double under the low scores if possible.
10. Proofread, save and print.

Top Five Players
Utah Desert Golf Classic
Prepared by Your Name
                First       Second       18 Hole
Player          9 Holes     9 Holes      Total
Aaron Black        41          35
Ben Jenson         32          40
Jose Barrera       36          43
Candy Finlinson    41          38
Melisa Snow        38          37
Low Score

Sort and Print

1. Sort the spreadsheet by the 18 Hole Total column. Make any needed adjustments.
2. Proofread, save and print.