Excel Basics:
Exercise Excel 2-1

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

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.
Full floppy disk How to handle a full disk


Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel Basics  
    Getting StartedTo subtopics      
    ArrangeTo subtopics  
    AutoFillTo subtopics
    FinishTo subtopics
    Summary
    Quiz
    Exercises arrow to open subtopic 
    Exercise" Ex. 1 Theater tickets
    Exercise" Ex. 2 Soccer budget
    Exercise" Ex. 3 Pings
    Exercise" Ex. 4 On Your Own

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics

Search
Glossary
Appendix

Exercise Excel 2-1:

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

Start with: Class disk, theater.xls from resource files

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.

  1. Open file: Open the file theater.xls from your resource files or download it now.
     
  2. Class diskSave 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. Class disk Save. [theater tickets2.xls]
  16. Print Print and close the workbook.

Final result for Exercise Excel 2-1