FINISH: Before you leave today you will know how to enter a formula to calculate the total, how to calculate projected revenue, and how to change the number of decimal places when using currency format.

2. THE DREAM TEAM EXCEL UNIT
1. Create a new blank workbook using Excel
2. Save the workbook to your 7th Grade Tech Apps The Dream Team folder as E-4 Projected Revenue
3. In cell A1, enter the title: Bellevue Buckeyes Stadium Projected Ticket Sales Revenue
4. In cell A2 enter the following subtitle: Based on a stadium seating capacity of 65,000
5. In cells A3 to E3 enter the following column headings: Section, Price, # of Seats, # of Home Games, Total Sales
6. Bold and center align cells A3 to E3
7. Enter your section names, price per ticket for each section, number of seats in each section, and the number of home games
8. Enter a formula in cell E4 to compute the Total Sales for the first section. This is computed by multiplying the Price by the # of seats by the number of home game. All formulas in Excel must start with an equal sign (=) and the multiplication symbol is the astrick (*). So click on cell E4 and type the following: =b4*c4*d4 and hit enter. You just calculated the Total Sales for the first section in your stadium.
9. Copy the formula in cell E4 to cells E5 through E8:
1. Click on cell E4 one time
2. Point at the NOTCH in the lower right corner of the cell & when it turns into a BLACK PLUS SIGN click and drag to cell E8. You just coped the formula to the other cells to calculate the Total Sales for the other sections of your stadium!
10. In cell D9 enter the following text: Total Projected Sales–you will most likely need to make column D wider by pointing at the small line between columns D & E and clicking & dragging
11. Enter a formula in cell E9 to compute the Total Projected Sales for all of the sections in the Total Sales column:
1. Click 1 time in cell E9
2. Click the HOME tab
3. Click on the arrow on the right side of the AUTOSUM button
4. Click SUM
5. Hit enter
12. Format column E as currency showing the “\$” symbol and 0 decimals
13. Merge & center align the title in A1 across all 5 columns
14. Merge & center align the subtitle in A2 across all 5 columns
15. Format the title, subtitle, and the column headings with an appropriate font size and style
16. Center align cells D4 to D9
17. Format the worksheet using your team’s colors
18. Rename the worksheet tab: Tix Sales
2. Type Tix Sales
21. Save
1. File
2. Print–choose the M553 or the 8600 printer
3. Change the orientation from PORTRAIT to LANDSCAPE
4. Toward the bottom of the print options click the CUSTOM SCALING button–choose to fit to all columns to 1 page if it is on more than 2 pages
5. Change PRINT ONE SIDED to PRINT TWO SIDED FLIP ON THE SHORT EDGE
6. Click PRINT
1. Formulas tab
2. Click SHOW FORMULAS (toward the right end of the ribbon options)
3. File tab
4. Print
5. Print Orientation — LANDSCAPE
6. Custom Scaling — FIT ALL COLUMNS ON 1 PAGE
7. Change PRINT ONE SIDED to PRINT TWO SIDED FLIP ON THE SHORT EDGE
8. Click PRINT
3. Create your own Projected Ticket Sales spreadsheet–create a new Excel spreadsheet to start and use Joe’s and mine (in the video) as examples. Use the steps above to help you. WHEN YOU ARE DONE:
1. File
2. Print–choose the M553 or the 8600 printer
3. Change the orientation from PORTRAIT to LANDSCAPE
4. Toward the bottom of the print options click the CUSTOM SCALING button–choose to fit to all columns to 1 page if it is on more than 2 pages
5. Change PRINT ONE SIDED to PRINT TWO SIDED FLIP ON THE SHORT EDGE
6. Click PRINT
1. Formulas tab
2. Click SHOW FORMULAS (toward the right end of the ribbon options)
3. File tab
4. Print
5. Print Orientation — LANDSCAPE
6. Custom Scaling — FIT ALL COLUMNS ON 1 PAGE
7. Change PRINT ONE SIDED to PRINT TWO SIDED FLIP ON THE SHORT EDGE
8. Click PRINT
4. At the TOP of the Word Online file for this class write about how you can use what you learned today outside of this classroom. SHARE the Word Online file with me AGAIN.

Before you leave today you will know how to sort a spreadsheet and insert a pie chart.

2. THE DREAM TEAM EXCEL UNIT
1. E 5–Top 5 Salaries
1. From the FILE menu choose SAVE AS and rename it E-5 TOP 5 SALARIES
2. Change the HEADER of the spreadsheet to the following: TOP 5 PLAYER SALARIES
3. Delete the entire row  that contains the AVERAGE SALARY
1. with your cursor, POINT at the ROW NUMBER on the left side of your screen and RIGHT CLICK 1 time (my average salary row is 12)
2. choose DELETE when you RIGHT CLICK on the ROW NUMBER that contains the average salary information
4. Sort the spreadsheet by Salary from HIGHEST to LOWEST
1. Click in cell G4
2. Click the DATA tab
3. Click SORT
4. Sort by: CHOOSE SALARY from the drop down list
5. Under ORDER choose LARGEST TO SMALLEST from the drop down list
6. Click OK
5. Delete all of the rows that do not contain the top five salaries
1. Point at the first row number below the top 5 salaries (mine is row 7) and when you have a RIGHT POINTING BLACK ARROW, CLICK and DRAG to the last row in the spreadsheet
2. RIGHT CLICK on the selected rows & choose DELETE
6. Create a PIE CHART to show a comparison by last name of the top 5 paid players and their salaries
8. Save
1. File
2. Print–choose the M553 or the 8600 printer
3. Change the orientation from PORTRAIT to LANDSCAPE
4. Toward the bottom of the print options click the CUSTOM SCALING button–choose to fit to all columns to 1 page if it is on more than 2 pages
5. Change PRINT ONE SIDED to PRINT TWO SIDED FLIP ON THE SHORT EDGE
6. Click PRINT