Excel Intro:
Exercise Excel 1-2

 Title: Jan's Illustrated Computer Literacy 101

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 floppy disk


Numbers Home

Project 1: Excel Intro
     InterfaceTo subtopics
    Select & NavigateTo subtopics
    Common TasksTo subtopics
    Summary
    Quiz
    Exercises To subtopics
     Exercise" Ex. 1: AutoCalculate
     Exercise" Ex. 2: AutoSum, Sort, Format
     Exercise" Ex. 3: Chart

Project 2: BasicsTo subtopics

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics

Search
Glossary
Appendix

Exercise Excel 1-2: AutoSum, Sort, & Format

What you will do:

 save a copy of a spreadsheet
use AutoSum
sort rows
format numbers
save and print

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

Use the toolbar buttons for AutoSum and sorting to create totals and arrange the rows.

Copy spreadsheet

  1. From your resource files in the numbers folder open the file halfyear.xls, or  download the file directly. 
     
  2. Class disk Select Save As from the File menu. In the Save As dialog, click Button: New Folder the New Folder button and create a new folder in the my docs folder:  excel project1. 
     
  3. Class disk Save the workbook as halfyeartotals.xls to the excel project1 folder.

AutoSum and Sort

  1. Row Totals: Use AutoSum to create row totals in Column I. After you get two values in Column I, Excel will try to sum the column instead of the row. Change the range when that happens. Remember to press ENTER to accept the formula.
     
  2. Sort: Sort the category rows, Rows 7 - 19, into alphabetical order.
    Your formulas refer only to cells in the same row, so you will not mess up the formulas by sorting. Whew!
     
  3. Column Totals: Use AutoSum to create column totals in Row 21. Again Excel will get confused after you have two values in the row. It will try to sum the row instead of the column. Change the range when that happens.
     
  4. Grand Total: In cell I22 use AutoSum to create a grand total, but change the range to include all the cells with Light Turquoise background, B7:H20. Type Grand Total = in cell G22.

Format Numbers

  1. Format currency: Format the new totals in column I and in Row 21 and in cell I22 as Currency. 
     
  2. Format decimals: There is one value in the table data with a decimal point. Increase the decimals by one for that value. 
     
  3. Format Painter: Use the Format Painter button to copy the format of cell E14 to range G22:I22, the grand total and its label. While that range is selected, make the cells bold. Reset I22 to Currency.
     
  4. Label sheet: Select cell D1 and type your name and press ENTER. Select cell E1 and type the date and press ENTER. Select cell D2 and type Exercise Excel 1-2
     
  5. Prepare to Print: Switch to Button: Print Preview Print Preview. Check what will print. Make corrections if necessary. This sheet prints on two pages.
     
  6. Class disk Save.
     
  7. Printer Print.

    8. Ex. 2 results