Practical Evaluation - Microsoft Excel 2000

Creating and Modifying a Chart Accessing the 'Chart Wizard' Using the 'Chart Wizard' The 'Chart' Toolbar Modifying a Chart Type Having Chart Data Change Automatically Displaying the Default Chart Type Enhancing a Chart's Appearance Adding Data to a Chart Resizing a Chart Modifying a Chart Title Modifying the Axis Title Modifying the Formatting Options of an Axis Inserting Pictures into Charts Setting Up a Default Chart Type Inserting a Picture into a Chart Modifying Picture Settings Setting a Default Chart Deleting a Chart Using the Default Chart Type Creating and Managing Lists Creating a List Displaying the 'Data Form' The 'Data Form' Dialog Box Adding a Record to a List Modifying a Record Defining Search Criteria Calculating Subtotals Sorting Data Based on One Column Displaying Subtotals Using the Outline Structure Modifying Criteria to Obtain Different Results Formatting a Cell Using Formatting Toolbar Options Creating a Chart Based on an Average Sort Keys and Nested Subtotals Using Multiple Criteria to Sort a List Obtaining a First-level Subtotal Obtaining Nested Subtotals		Filtering Data Applying an AutoFilter Filtering Data Using the AutoFilter Removing Filters Customizing a Filter The 'Advanced Filter' Option Defining the Criteria Range Accessing the Advanced Filter Setting Up the Advanced Filter Applying the Advanced Filter Using a Formula as Search Condition PivotTable Reports The PivotTable/PivotChart Wizard Selecting Table Items Hiding a Table Item The PivotTable Report Modifying a PivotTable Report Creating Scenarios Opening the Scenario Manager Defining a Scenario Viewing a Scenario Entering Real Data on the Table Generating a Comparative Table The 'Audit' Option Inserting Formulas into a Table Displaying the 'Auditing' Toolbar Displaying an Active Cell's Precedents Tracing an Active Cell's Dependents Excel 2000 and the Internet Displaying the 'Web' Toolbar Inserting a Hyperlink Adding a Web Site to the 'Favorites' Folder Converting an Excel Worksheet into HTML Format Opening a Worksheet Saved as a Web Page
Practical Evaluation Microsoft Excel 2000 - Module 3 MXL00ACCP3P

	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


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.