Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101
Home > Jan's CompLit 101 > Working with Numbers > Intro > Ex. Excel 1-1
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Numbers

    Intro: Exercise Excel 1-1

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 after you download and unzip them is
c:\My Documents\complit101\numbers\

You do not want 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.

Exercise Excel 1-1: Budget

What you will do: Show that you can select cells, rows, columns, ranges
Show calculations on the Status bar

Start with: budget-2010.xlsx from resource files

Exercise Excel 1-1Show 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 for the SUM on the Status bar.

  1. From your resource files, open the file budget-2010.xlsx  in the numbers resources folder. (Yes, you are going back to the original file instead of the one you have been working with.)
  2. If necessary, click the button Enable Editing in the yellow bar across the top.

  3. Set Status Bar: Right click on the Status bar. If necessary, click on Sum to put a check mark beside it.

    Icon: TroubleProblem: AutoCalculate area does not appear
    You used the link above and the spreadsheet 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.

  4. Select the named cell(s) below and on a separate sheet of paper or in a Word or Excel document, write the value that the Status Bar shows for the sum.

    It matters which sheet you are on!
    Be sure you are using the ORIGINAL resource file and not the one you edited.

    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 = _____