Practical Evaluation - Microsoft Excel 97

Finding and Opening a Document Displaying the 'Open' Dialog Box Changing the Display and Search Options Searching for a File Name Running the 'Find' Tool Viewing Documents Displaying the 'Advanced Find' Dialog Box Opening a File Spell Check and Print Preview Running the Spell Check Ignoring a Word Manually Correcting an Error Accessing the 'Print Preview' Mode Using the 'Zoom' Function Changing the Page Setup Adding a Header to a Document Printing a Document Relative and Absolute References Using Relative References Using Absolute References Hiding a Column Displaying a Hidden Column Naming Cells and Columns Naming Cells Naming Columns Displaying the 'Name Box' List Using Names in Formulas Modifying and Deleting Cell Names Creating Formulas and Protecting Cells Naming a Column Creating an Estimate Using the 'AutoSum' Function Unlocking Cells Protecting the Entire Sheet Modifying the Contents of Unprotected Cells Trying to Modify Protected Cells Unprotecting Sheets		Multi-Sheet Workbooks Moving Around in a Sheet Displaying Sheet Tabs Inserting and Deleting Sheet Renaming a Sheet Creating a Work Group Using the 'AutoSum' Function Removing a Workgroup Creating a Formula with Values from Different Sheets Styles and AutoFormats Creating a Customized Style Naming a Style Defining a Style Applying a Style Modifying an Existing Style Applying an AutoFormat Deleting an AutoFormat Creating Templates Displaying the 'New' Dialog Box Previewing the 'Invoice' Template Opening the 'Invoice' Template Customizing Templates Naming and Saving a Customized Template Creating a Document Based on a Template Inserting a WordArt Object Displaying the WordArt Toolbar Choosing a Special Effect Entering Text Changing the Shape of a WordArt Object Centering the Text in a WordArt Object Resizing and Moving a Logo Deleting a Logo
Practical Evaluation Microsoft Excel 97 - Module 2 MXL97ACCP2P

	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


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.