TechTrain "Just-In-Time" - SEARCH for mini-lessons for busy people!"Step-By-Step" tutorials and lesson modules.TechTrain Home
About TechTrain
Step- By-Step
Just- In-Time Search
Products
Services
Guestbook
Technology Certificates
Graduate Courses
   

Excel 2000 Menu Excel - Creating, Saving, and Printing Next Topic
 

Objectives:

  1. Learn to use the New file function
  2. Learn to use the Save As function
  3. Learn to use the Print function
  4. Take a Quiz

A worksheet is a set of spreadsheets used to store numeric data. The worksheet data may be printed, graphed, sorted, and used in a variety of calculations.

Your first worksheet will consist of a single spreadsheet that contains climatic data for Michigan and Alaska.

Create a new worksheet

  1. Select File / New / Workbook.
  2. Type the following information in the cells of your sheet1.

(A cell is the intersection of a row and column in a spreadsheet.

A cell is named with the Column letter and Row number, i.e. B3, A4, G127)

Use the tab key or arrow keys to move from cell to cell in your sheet.

Note: The example data is not scientifically accurate.

Your sheet should look like the one illustrated above. Do not worry about the formatting of your worksheet. You will be changing the formatting options in Activity 2.

Top of Page

Saving Your Work.

  1. Select File / Save As.

    2. The Save As dialog box will appear.

  2. Save In: Choose drive A:
    (If you have a geography folder from a previous exercise, save your work in it.
  3. Filename: Name the file weather.
  4. Save as type: Microsoft Excel Wookbook .xls
  5. Click Save.

Top of Page

Printing Your Output.

  1. Choose File/Print.

    2. The Print dialog box will appear.

  2. Click Preview button to see what printed output will look like.

    3. (Note that the data spans 2 pages.)

  3. Click Close. This closes the Print Preview only.

    4. Let’s change the settings so all the output fits on one piece of paper.

  4. Choose File / Page Setup.

    5. The Page Setup dialog box will appear.

    1. Make sure the Page Tab is selected.
      We’ll cover the other tabs in another activity.
    2. Choose Fit to One Page wide and One Page tall.
  5. Click OK.
  6. Choose File / Print Preview to see new format.
  7. Choose Close on Print Preview.
  8. Close the weather file and Save.

Top of Page
   
TechTrain Home
Copyright - Technology Training Team
Please contact us at TechTrainTeam