Practical Evaluation - Microsoft Excel 2000

Relative and Absolute References Using Relative References Absolute References Modifying the Value of an Absolute Reference Hiding a Column Naming Cells Naming a Cell Naming a Range of Cells Using the Names of Cells in Formulas Deleting a Cell Name Calculating Complex Formulas/Protecting Cells Completing a Preliminary Study Identifying Unprotected Cells Maintaining a Selection of Cells Unprotected Protecting a Worksheet Verifying the Protection Function Managing Multiple Worksheets Moving Around on a Worksheet Moving Between Worksheets in a Workbook Worksheets in Workbooks - Adding and Removing Naming a Worksheet Grouping Worksheets Breaking Links Between Worksheets Formulas Using Data From Multiple Worksheets Finding and Opening a Workbook Modifying the Display Options Using the 'Search' Tool Defining Search Criteria The 'Quick View' Dialog Box		Opening and Viewing Multiple Workbooks Opening Two Workbooks The 'Window' Menu Hiding/Showing a Workbook Displaying Two Workbooks Simultaneously Copying and Moving Information Between Workbooks Correcting Spelling Initiating the Correction Using the Spelling Correction Tool Adding a Word to the Custom Dictionary Using the AutoCorrect Tool Styles and AutoFormats Saving a Style The 'Style' Dialog Box Applying a Style to a Cell Displaying the Automatic Table Formats Modifying a Table's AutoFormat Options Inserting a WordArt Object Displaying the 'WordArt' Toolbar The 'Insert WordArt' Dialog Box Moving a 'WordArt' Object The 'WordArt' Toolbar Resizing a 'WordArt' Object Shortcut Keys Opening a Workbook Printing a Document Copying a Worksheet Modifying a Document
Practical Evaluation Microsoft Excel 2000 - Module 2 MXL00ACCP2P

	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.