Practical Evaluation
Microsoft Excel 97 - Module 1

MXL97ACCP1P

This entirely interactive practical evaluation was designed to evaluate your knowledge of this application. You will be able to determine, through a series of practical exercises, if you understand the essential concepts required to master this application.
 

Basic Knowledge of Microsoft Excel 97

Knowledge evaluated


 

1 - 2 hours
 
 

  1. Discovering the Excel 97 Screen
    Running Excel 97
    Minimizing and Maximizing the Excel Window
    Opening the View Menu
    Opening the 'Customize' Dialog Box
    Entering Data
    Modifying a Cell's Contents

  2. Entering and Formatting Data
    Entering Text
    Entering Dates and Numbers
    Modifying the Date Format
    Applying a Currency Format

  3. Creating your First Report with Excel
    Inserting Formulas
    Copying a Formula
    Using Regular Functions
    Using Logical Functions
    Pasting a Function
    Modifying Formulas

  4. Selecting and Enhancing Cells
    Selecting a Range of Cells
    Formatting Cells
    Formatting Entire Rows and Columns
    Selecting Non-Adjacent Cells and/or Ranges of Cells
    Changing the Font and Font Size
    Using the 'Undo' Toolbar Button
    Copying a Format
    Applying Borders to Cells


  1. Copying and Incrementing
    Deleting the Contents of a Cell
    Copying and Pasting Through the 'Edit' Menu
    Using Fill Handles
    Incremented Copying
    Moving Data

  2. Modifying the Appearance of a Sheet
    Inserting and Deleting a Cell
    Inserting One or More Rows
    Deleting One or More Rows
    Inserting and Deleting a Column
    Displaying a Row's Standard Height
    Modifying the Standard Column Width
    Automatic Column Adjustments
    Returning a Column to its Standard Width

  3. Saving a Workbook
    Accessing the 'Save As' Dialog Box
    Creating a Folder
    Creating Default Folder
    Saving Your Work
    Closing a Workbook
    Opening a Workbook

  4. Finding Help in Excel
    The 'What's This?' Option
    Displaying the 'Help Topics' Dialog Box
    Using the 'Contents' Tab Menu
    Using the 'Index' Tab Menu
    Displaying the Office Assistant
    Printing a Help Topic
    Displaying Tips from the Office Assistant

 

Using any computer with Internet access, the learner enters his/her confidential ID and obtains a list of evaluations to which he/she is subscribed. Once a practical evaluation is selected, a list of subject titles is displayed. When a title is clicked, the evaluation begins. The learner can obtain the definition of certain terms through the glossary at any time.

 

• No installation required
• IBM PC compatible, Pentium 233 MHz minimum, 330 MHz and more strongly recommended.
• Video card that supports 800x600 or greater monitor resolution, and 16-bit color
• 32 MB RAM minimum, 96 MB and more strongly recommended.
• Microsoft compatible mouse
• Operating system: Windows 95, 98, 2000, NT 4.0, or more recent

• Sound card, speakers or headphones
• Netscape 4.7 or Internet Explorer 5.0 (or more recent)
• Internet connection: Modem 56 K minimum, high-speed connection is strongly recommended or network connection 10 Mbit minimum.

• * If you use Windows XP, Internet Explorer 6 will only work if Java 1.4.0 or higher has been installed. In fact, due to a conflict between Sun and Microsoft, Microsoft excluded the JVM from it's distribution of Windows XP for Internet Explorer. In order to download and install the JVM, please consult the following site : http://www.eduperformance.com/download/jre.exe

 

EDU-PERFORMANCE CANADA
7900 Taschereau Blvd. W.
Suite A-207
Brossard, Quebec J4X 1C2
Canada
Tel.: (450) 466-7275
Fax: (450) 466-4915
Toll free: 1-888-EDU-PERF
              1-888-338-7373
E-mail: info@eduperformance.com
Web site: www.eduperformance.com

EDU-PERFORMANCE EUROPE



International number: 1-450-466-7275
E-mail: infoepe@eduperformance.com
   

 

© 2006 Edu-Performance Canada Inc. All rights reserved. Duplication prohibited. All products and product names mentioned in this publication are trademarks or registered trademarks of their respective holders.