Excel Intro:
Exercise Excel 1-3

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.

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-3: Chart Wizard

What you will do:

select data and label cells
use Chart Wizard to create a bar chart
label and title the chart
save and print

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

Create a chart using the Chart Wizard.

  1. Class disk Open halfyeartotals.xls, if necessary, from your Class disk. (You created this file in the previous exercise.)
  2. Select Data series: Select the column labels, B4:G4, and the column totals in B21:G21.
  3. Chart Wizard: Use the Chart Wizard to create a column graph (the default).
    Title = Key Categories
    Category (X) axis = First Six Months
    Do not show the legend or data labels.
    Create the chart on a new sheet and name the sheet Column Chart.
  4. Label: Click in the Formula bar and type your name, 2 spaces, the date, 6 spaces, Exercise Excel 1-3 and press ENTER. A frame containing your text appears in the middle of the chart. Drag the frame to the upper left of the chart's white background.
  5. Prepare to Print: Spell Check and look at Print Preview. Make corrections if necessary.
  6. Class disk Save.
    How to handle a full disk
  7. PrinterPrint.

    Ex. 3 results