|
MS Excel 2003 – Advanced is designed for power level users. The topics covered are analysis, data manipulation, working with formulas and functions, pivot tables, macros, lookups and more. This test includes 16 interactive questions and allows 5 tries per question. Test questions may be skipped and a review session is provided at the end of the test. The score report will outline each question, whether it was correct or incorrect. For any incorrect answer the test will provide study tips.
Test Outline:
Editing & Formatting
-
Conditional Formatting
-
Paste Link
File Management
- Merging Workbooks
- Importing Data
Analysis
- Absolute Cell
- Charts
- If Statements
- Ranges
- HLookup
- VLookup
- Multiple Workbooks & Formulas
- PivotTable
-
Tools & Automation
|
