Excel Intro:
Exercise Excel 1-1

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007/2010  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 Intro
     InterfaceTo subtopics
    Select & NavigateTo subtopics
    Common TasksTo subtopics
    Exercises To subtopics 
    Exercise" Ex. 1: AutoCalculate
    Exercise" Ex. 2: AutoSum, Sort, Format
    Exercise" Ex. 3: Chart

Project 2: Excel BasicsTo subtopics

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Exercise Excel 1-1: Select and AutoCalculate

What you will do:

show that you can select cells, rows, columns, ranges
use AutoCalculate to add up selected cells

Start with: budget.xls from resource files

Show you have mastered selecting and navigating in Excel by using the method of your choice to select the cell(s) listed below. Write down the value that AutoCalculate gives on the status bar.

  1. From your resource files, open the file budget.xls in the numbers  folder.
  2. Set AutoCalculate: Right click on the status bar. Click on  Sum  so that it will be the function that AutoCalculate will use.

    Problem: AutoCalculate area does not appear
    You used the link above and budget.xls opened in an Internet Explorer window instead of in a normal Excel window.
    Solution: Save the file to your hard drive and open from inside Excel.
  3. Select the named cell(s) below and on a separate sheet of paper write the value that AutoCalculate shows.
  1. On sheet Budget - range B7:D13  = _____
  2. On sheet Budget - cells B25:B27, B30, B33, B37, B39 = _____
  3. On sheet Actual - Row 15  = _____
  4. On sheet Actual - Rows 36 through 38 = _____
  5. On sheet Actual - Column F = _____
  6. On sheet Actual - Columns D, K, and L = _____
  7. On sheet Actual - ranges B15:D24 and I15:K24 = _____
  8. Named cell: TotalGrossSales = _____
  9. Named range: AugustInflows = _____
  10. Named range: Print_Area = _____

Check your answers