Microsoft Excel 97 Exam Information
Quick Info
Time: Proficient: 25 mins for reading questions; 45 mins for answering questions. Expert: 25 mins for reading questions, 85 mins for answering questions.
Number of Questions: 41 in Proficient; 36 in Expert
Pass Mark: 80% for Proficient; 75% for Expert
| MOUS Level | Skill Set | Activity |
| Proficient | Create Workbooks | Open Workbooks |
| Enter text and numbers | ||
| Enter formulas | ||
| Save Workbooks | ||
| Close Workbooks | ||
| Modify Workbooks | Delete Cell Contents | |
| Delete Worksheets | ||
| Revise text and numbers | ||
| Rotate and indent text | ||
| Revise formulas | ||
| Copy and move data | ||
| Insert, modify and delete rows and columns | ||
| Use references (absolute, relative, and mixed) | ||
| Sort data | ||
| Print Workbooks | Preview and Print Worksheets | |
| Print the screen and ranges | ||
| Print headers and footers | ||
| Format Worksheets | Modify cell size and alignment | |
| Apply general number formats | ||
| Apply font formats | ||
| Apply outlines | ||
| Create and Apply Ranges | Create and name ranges | |
| Clear and format ranges | ||
| Copy and move ranges | ||
| Use functions | Use the AVERAGE, MIN and MAX functions | |
| Use worksheet functions | ||
| Use draw | Create and modify lines and objects | |
| Create and modify 3D Shapes | ||
| Use charts | Create, format and modify charts | |
| Preview and Print charts | ||
| Save Spreadsheets as HTML | Save Spreadsheets as HTML documents | |
| Expert | Format Worksheets | Apply formats (Accounting, Fraction and Scientific) |
| Create Custom Formats | ||
| Use Styles and AutoFormats | ||
| Use lists | Sort data | |
| Query from a list | ||
| Print Workbooks | Preview workbooks | |
| Print workbooks | ||
| Audit a Worksheet | Check and Review Data | |
| Find cells referred to in a specific formula | ||
| Find formulas that refer to a specific cell | ||
| Find errors | ||
| Use Advanced Functionality | Query Databases | |
| Extract Data | ||
| Use Filters | ||
| Use Data Analysis and Pivot Tables | ||
| Use Data Map | ||
| Use Data Validation | ||
| Use Conditional Formatting | ||
| Perform multi-level sorts | ||
| Use macros | Create and record macros | |
| Edit macros | ||
| Run macros | ||
| Import and Export Data | Import from other applications | |
| Export to other applications | ||
| Use templates | Work with existing templates | |
| Create templates | ||
| Edit templates | ||
| Use multiple workbooks | Link workbooks | |
| Use multiple workbooks | ||
| Use workgroup functions | Cell tips | |
| Share Lists | ||
| Track Changes | ||
| Resolve Conflicts | ||
| Show History of Changes | ||
| Merge Workbooks |
This page has had visits.