Spreadsheet 1A

Type in the following spreadsheet, and format it to look like the sample above.

Instructions

1) Type in all text and numbers shown in the spreadsheet below.

2) Format all numbers with appropriate formats.

3) Center the spreadsheet heading "NBA Championship Team Appearances and Wins" across the spreadsheet.

4) Format all text as displayed in the sample ("Appearances" and "Wins" are centered.)

5) Apply all borders and shading (color) shown in the sample below, feel free to experiment with your own color schemes.

6) Sort the teams into alphabetical order. Make sure the correct data stays with each team!

7) Add (Sum) the "Wins" column in order to determine the number of total championships.

8) Put your name in the heading along with the date. (View>Header and Footer>Custom Header> Left Section).

(9) Print your spreadsheet to Lab Dell 1760.

(30 points)