Practical Evaluation - Microsoft Excel 97

Creating and Modifying a Chart Accessing the Chart Wizard Going Through the Steps of the Chart Wizard Adding Titles Modifying the Chart Type Modifying and Deleting a Chart Displaying the Default Chart Deleting the Default Chart Improving the Presentation of a Chart Updating a Chart Formatting the Chart Title Formatting the Title Axis Changing a Title Formatting the Axis Data Formatting the Data Series Pictures and Default Charts Displaying the Default Chart Inserting Pictures into Column Bars Stacking your Pictures Changing the Default Chart Type Deleting a Full-Screen Chart Displaying a Pre-defined Chart Creating and Managing a List Entering Data Labels Updating a Table Displaying the 'Form' Dialog Box Entering a New Record Modifying a Record Entering Search Conditions Deleting Search Conditions Deleting a Record Subtotals Sorting Records in a Table Adding Subtotals to a Table Adjusting the Width of a Column Changing Subtotals to Averages Applying a 'Currency' Format to a Cell Creating a Chart Based on the Averages Deleting Subtotals Sort Keys and Nested Subtotals Sorting Data in a List Defining Sort Keys Displaying the 'Options' Dialog Box Adding Subtotals to a List Adding Nested Subtotals Deleting Nested Subtotals The AutoFilter Adding an AutoFilter to a List Viewing Filtered Lists Working with an AutoFilter Creating a Customized Filter Modifying a Customized Filter Removing an AutoFilter		The Advanced Filter Entering Criteria Using the Advanced Filter Indicating the List and Criteria Range Redisplaying the Filtered Data Using a Formula as Criteria Applying the Advanced Filter PivotTable Reports Renaming Sheets Accessing the PivotTable Wizard Creating a PivotTable Viewing One Retailer's Data Modifying PivotTables Updating PivotTables Displaying Data Based on Products Managing Scenarios Creating a Scenario Displaying the 'Scenario Manager' Dialog Box Naming Scenarios Entering a Value for the Changing Cell Viewing a Scenario Onscreen Modifying a Scenario Creating Scenario Summary Reports The Audit Option Entering Formulas Copying Formulas Displaying the 'Auditing' Toolbar Displaying and Removing Precedent Arrows Displaying and Removing Dependent Arrows Tracing Errors Creating a Summary Report Extracting the Year From a Date Creating a PivotTable Entering a Formula Using the 'IF' Logical Function Copying a Formula Excel 97 and the Internet Displaying the Web Toolbar Inserting Hyperlinks Accessing a Web Site Adding Addresses to the 'Favorites' Folder Opening a Favorite Web Site Using the Internet Wizard Entering the HTML File Path Opening an HTML File
Practical Evaluation Microsoft Excel 97 - Module 3 MXL97ACCP3P

	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.