Excel Practice Certification Exams.
PART 1: Excel Practice Certification Exams. * 6 Practice Exams * Time 90minutes * 85 Questions Each * 510 Questions.
Excel Practice Certification Exams. free download
PART 1: Excel Practice Certification Exams. * 6 Practice Exams * Time 90minutes * 85 Questions Each * 510 Questions.
The following are areas of subject comprised in these programmed Certification practice tests
1. Introduction to Excel spreadsheet
Understanding Workbooks and Worksheets
Moving around a Worksheet
Navigating with your keyboard, Navigating with your mouse
Using the Ribbon, Ribbon tabs, Contextual tabs, types of commands on the Ribbon, Accessing the Ribbon by using your keyboard, Using Shortcut Menus.
Customizing Your Quick Access Toolbar.
Working with Dialog Boxes, Navigating dialog boxes, tabbed dialog boxes.
Using Task Panes
Entering and Editing Worksheet Data .
2. Performing Basic Worksheet Operations.
3. Working with Excel Ranges and Tables.
4. Formatting Worksheets
5. Understanding Excel Files and Templates.
6. Printing Your Work
7. Customizing the Excel User Interface
8. Working with Formulas and Functions
9. Introducing Formulas and Functions.
10. Using Formulas for Common Mathematical Operations
11. Using Formulas to Manipulate Text
12. Using Formulas with Dates and Times.
13. Using Formulas for Conditional Analysis
14. Using Formulas for Matching and Lookups
15. Using Formulas for Financial Analysis
Using Formulas for Statistical Analysis
Using Formulas with Tables and Conditional Formatting.
Understanding and Using Array Formulas
Getting Started with Excel Charts
Using Advanced Charting Techniques
Creating Sparkline Graphics
Visualizing with Custom Number Formats and Shapes.
Importing and Cleaning Data
Using Data Validation
Creating and Using Worksheet Outlines
Linking and Consolidating Worksheets
Introducing PivotTables
Analyzing Data with PivotTables
