# Excel Basics: Exercise Excel 2-1

Did you want Working with Numbers: 2007,2010,2013,2016  or español

You need to use what you just learned, and maybe learn a little more. Complete all parts of the following exercises. Don't forget to backup your Class disk when you have completed the exercises or whenever you stop for the day and saved a document along the way.

These exercises use files from the numbers resource files. The default location for these files is c:\My Documents\complit101\numbers\ You cannot make changes to these files and save them in the same place. Save the changed documents to your Class disk. This keeps the original resource files intact in case you need to start over or another student will be using this same computer.
How to handle a full disk

Where you are:
JegsWorks > Lessons > Numbers

Project 3: Format & Arrange

Project 4: Groups & Formulas

Project 5: Design

## Theater Tickets -  AutoFill & AutoSum

 What you will do: enter data use AutoFit to size rows and columns use AutoFill to complete data entry create formula use AutoSum to add columns format numbers as currency create a header print

The City Theater ran three plays on three weekends in August, 1998. You will construct a spreadsheet that presents information on the number of seats sold at each of three ticket prices.

At an evening performance the best seats are type A tickets and the rest of the seats are type B tickets. M type tickets are for afternoon matinees on Saturdays and Sundays. At a matinee the price is the same for all seats.

2. Save to your Class disk in the folder excel project2 with the name theater tickets2.xls.

3. Resize columns: Drag Column A wide enough to read all of "West Side Story" in cell A11

4. AutoFit: Use AutoFit to set column width for C, D, and E.

5. Data Entry: Enter the date of the opening performance for the other two plays: B17 =  8-7-98  , B26 =  8-14-98 . These are Fridays but West Side Story started on a Saturday.

6. AutoFill: Select the first date cell and two blank cells below (B11:B13) and drag down the column to the end of the cells for that particular play to B16. Repeat for B17:B19 to B25 and B26:B28 to B34. This gives you 3 rows for each date, for the 3 types of tickets.

7. AutoFill: Copy the ticket types and prices, which are the same for every play by selecting C11:D13, holding the CTRL key down and dragging down the column to row 34. (If you do not hold down the CTRL key, the numbers will not be copied correctly.)

8. Formula: Select cell F11 in the Total column. Enter a formula in this cell that will multiply the ticket price by the number sold. (Don't forget the =)

9. AutoFill: Copy the formula in cell F11 down the column through F34.

10. AutoSum: In cell A36 type  Totals:  Use AutoSum in cell E36 to add up the number of tickets sold for all three plays. You must change the range because of the blanks in the column.

11. AutoSum: Use AutoSum in cell F36 to add up the amount of money for all of the tickets.

12. Numbers: Select range D11:D34, range F11:F34, and cell F36. Format as Currency.) Decrease Decimals twice. (If you see cells change to  #######  as you work, this just means that the column is not wide enough to show the whole number.)

13. Header: Create a header with your name and the date on the left, the file and sheet names in the middle, and Exercise Excel 2-1 on the right.

14. Prepare to Print: Arrange for the sheet to print with no gridlines, no headings showing, and centered horizontally across the page, but not vertically. (Hint: Page Setup) Spell Check. Check the Print Preview and make corrections if necessary.

15. Save. [theater tickets2.xls]
16. Print and close the workbook.