Practical Evaluation
Microsoft Excel 2000 - Module 1

MXL00ACCP1P

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 2000

Knowledge evaluated


 

1 - 2 hours
 
 

  1. Exploring the Excel 2000 Screen
    Opening Excel 2000
    Making Excel 2000 an Active Resource
    Sheet Tabs and the Workbook
    Making Data Entries in a Cell
    Activating a Cell
    Replacing Cell Contents
    Modifying Cell Contents

  2. Modifying the Excel Window
    Hiding/Showing the Formula and Status Bars
    Hiding/Showing the Standard Toolbar
    Displaying Two Toolbars on the Same Line
    Displaying the Formatting Toolbar Buttons
    Displaying Two Toolbars on Separate Lines
    Displaying a Worksheet Full-Screen
    Displaying a Worksheet in Normal View

  3. Entering and Formatting Data
    Entering Data into Cells
    Aligning Data Within a Cell
    Using the 'Format Cells' Dialog Box Options
    Modifying the Date Format

  4. Performing Calculations on an Excel Worksheet
    Inserting a Formula
    Copying a Formula
    Using the 'Sum' Function
    Using Logical Functions
    Modifying Data on a Table
    The 'Paste' Function

  5. Enhancing the Appearance of Cells
    The Drag-and-Drop Technique to Select Cells
    The 'Center', 'Bold' and 'Merge and Center' Buttons
    Selecting Non-Adjacent Cells
    Copying Formatting
    Modifying the Font Type and Size
    Applying Borders
    Enhancing the Appearance of Empty Cells

  6. Copying, Incrementing and Moving Data
    Deleting Data from a Cell
    Copying Content Between Cells
    Using the Fill Handle
    Incremented Copying
    Moving Values Between Cells
    Using the 'Undo' Button


  1. Creating a Series
    Saving a New Series of Data
    Creating an Incremented List Using a New Series
    Inserting a Date Series
    The 'Series' Dialog Box

  2. Modifying the Appearance of a Worksheet
    Inserting a Cell
    Deleting a Cell
    Inserting Rows
    Inserting a Column
    Deleting a Column

  3. Opening and Saving a Workbook
    Creating a Folder
    Naming and Saving a Workbook
    Modifying the Default Folder Used by Excel
    Opening and Closing a Workbook

  4. Printing an Excel Worksheet
    Displaying a Worksheet in Print Preview
    Using the 'Zoom' Button
    Displaying the 'Page Setup' Dialog Box
    The 'Margins' Tab Menu
    Creating a Footer
    Creating a Custom Header
    The 'Sheet' Tab Menu
    The 'Print' Dialog Box
    Printing a Worksheet

  5. Getting Help in Excel
    The 'What's This?' Function
    Deactivating the 'Office Assistant'
    The 'Help' System Dialog Box
    The 'Answer Wizard'
    Using the 'Office Assistant'
    Displaying a Different '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.