Study Resources: Practice Exam - Our free online practice exam Forum - Get answers and help others Find Training - CBT, testing software, online training, etc.
Links: Official Exam Site Microsoft Excel Tutorials Money Saving Tips Intro to Microsoft Certifications About This Exam:
This Microsoft Office Specialist exam is performance-based, requiring you to perform a series of tasks using Microsoft Excel version 2002. Many of the questions in this Microsoft Office Specialist exam require you to complete a series of tasks to create or modify a typical business document.
This exam uses the actual Microsoft Excel version 2002 program. All menu items, keyboard shortcuts and right-click options will be available to complete the tasks. The help menu, including use of the Office Assistant, is not available in any of the exams.
There is one to three points are possible per question, depending on the number of specified tasks. At the conclusion of an exam your final score is derived by converting the task score to a 1000-point scale.
While some questions involve more tasks than others, each question is scored on a total-score basis (i.e.; number correct) rather than on a pass/fail basis. For example, a 20-question exam may have 34 possible points; one point for each task.
Enter and edit cell data including text, numbers, and formulas
Check spelling
Find and replace cell data and formats
Work with a subset of data by filtering lists
Managing Workbooks
Manage workbook files and folders
Create workbooks using templates
Save workbooks using different names and file formats
Formatting and Printing Worksheets
Apply and modify cell formats
Modify row and column settings
Modify row and column formats
Apply styles
Use automated tools to format worksheets
Modify Page Setup options for worksheets
Preview and print worksheets and workbooks
Modifying Workbooks
Insert and delete worksheets
Modify worksheet names and positions
Use 3-D references
Creating and Revising Formulas
Create and revise formulas
Use statistical, date and time, financial, and logical functions in formulas
Creating and Modifying Graphics
Create, modify, position, and print charts
Create, modify, and position graphics
Workgroup Collaboration
Convert worksheets into Web pages
Create hyperlinks
View and edit comments
Sponsor
Sponsor
Training Picks
CareerAcademy Expert-led On-Demand Certification training courses with 7x24 LIVE Mentoring. Topics cover MCSE 2008 Training, A+ Certification, IT Security CEH Training, Cisco Training and many more.Training Videos We offer streaming or CD certification training videos for Microsoft, CompTIA, Cisco, Citrix, Oracle, CISSP, CET, CWNA, LPI, SCJP, CIW, MOS, PMP and other certifications. View our free videos!EDULEARN Certification Training on CD-ROMs & Videos: Microsoft MCSE Training, A+ Certification, Windows 2003, & Free demos. MCSE certification training includes videos and labs.Online Computer Trainingby K Alliance. Certification training videos for MCTS, MCITP, Oracle OCA/OCP, A+, CCNA, RHCE and more. Our e-learning courses come with 24/7 online mentoring.More Training
