# Excel Intro: Exercise Excel 1-3

Did you want Working with Numbers: 2007,2010,2013,2016  or español

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

Project 3: Format & Arrange

Project 4: Groups & Formulas

Project 5: Design

Search
Glossary
Appendix

## 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

### Create a chart using the Chart Wizard.

1. 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. Save.
How to handle a full disk

7. Print.