We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z0-886 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | OpenOffice.org Calc Certified Expert Exam |
| Exam Number: | 1Z0-886 |
| Exam Format: | Multiple Choice, Multiple Response |
| Passing Score: | 70% |
| Real Exam Qty: | 50-70 |
| Certificate Validity Period: | No expiration (retired exam) |
| Available Languages: | English |
| Exam Duration: | 90 minutes |
| Related Certifications: | OpenOffice.org Writer Certified Expert (1Z0-885) OpenOffice.org Impress Certified Expert (1Z0-887) |
| Exam Price: | USD $95-$125 |
| Recommended Training: | Oracle OpenOffice Training Resources |
| Exam Registration: | Pearson VUE Oracle University |
| Exam Way: | In-person test center (formerly Pearson VUE), exam retired and no longer available |
| Pre Condition: | No official prerequisites; practical experience with OpenOffice.org Calc recommended |
| Official Syllabus URL: | https://education.oracle.com/ |
Oracle 1Z0-886 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Data Entry and Formatting | 25% | - Apply cell, column, and row formatting - Enter and edit various data types - Use styles, themes, and conditional formatting |
| Topic 2: Data Analysis and Organization | 15% | - Use subtotals, consolidation, and scenarios - Sort, filter, and validate data - Create and format tables and ranges |
| Topic 3: Charts and Printing | 10% | - Create, modify, and format charts - Set page layout, headers, footers, and print options |
| Topic 4: Workbook and Worksheet Management | 20% | - Insert, delete, rename, and format worksheets - Manage views, windows, and navigation - Create, open, save, and manage workbooks |
| Topic 5: Formulas and Functions | 30% | - Create and edit formulas and references - Use mathematical, statistical, logical, and text functions - Work with date/time, lookup, and financial functions |
By Sandra
