Oracle 1Z0-886 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | OpenOffice.org Calc Certified Expert Exam |
| Exam Number: | 1Z0-886 |
| Certificate Validity Period: | No expiration (retired exam) |
| Available Languages: | English |
| Real Exam Qty: | 50-70 |
| Exam Format: | Multiple Choice, Multiple Response |
| Passing Score: | 70% |
| Related Certifications: | OpenOffice.org Writer Certified Expert (1Z0-885) OpenOffice.org Impress Certified Expert (1Z0-887) |
| Exam Price: | USD $95-$125 |
| Exam Duration: | 90 minutes |
| Recommended Training: | Oracle OpenOffice Training Resources |
| Exam Registration: | Oracle University Pearson VUE |
| 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: 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 |
| Topic 2: Charts and Printing | 10% | - Create, modify, and format charts - Set page layout, headers, footers, and print options |
| Topic 3: Workbook and Worksheet Management | 20% | - Manage views, windows, and navigation - Insert, delete, rename, and format worksheets - Create, open, save, and manage workbooks |
| Topic 4: Data Entry and Formatting | 25% | - Enter and edit various data types - Apply cell, column, and row formatting - Use styles, themes, and conditional formatting |
| Topic 5: Data Analysis and Organization | 15% | - Create and format tables and ranges - Sort, filter, and validate data - Use subtotals, consolidation, and scenarios |

We're so confident of our products that we provide no hassle product exchange.


By Maureen


