Difference between revisions of "Certification/3.0 Calc"
From Apache OpenOffice Wiki
m |
m (renumbering) |
||
| Line 38: | Line 38: | ||
| | | | ||
|| | || | ||
| − | ||3. | + | ||3.2 Printing with Calc |
|| | || | ||
|- | |- | ||
| Line 44: | Line 44: | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.2.1 Printing a spreadsheet |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.2.2 Selecting sheets to print |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.2.3 Adjusting the print range |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.2.4 Page breaks |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.2.5 Headers and footers |
|- | |- | ||
|- | |- | ||
| | | | ||
|| | || | ||
| − | || 3. | + | || 3.3 Formula and functions |
|| | || | ||
|- | |- | ||
| Line 75: | Line 75: | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.1 About formulas |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN) |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.3 Statistical functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.4 Time and date functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.5 Text functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.6 Math functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.7 Logical functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.8 Information functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.9 Advanced spreadsheet functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.3.10 Standard errors |
|- | |- | ||
| | | | ||
| Line 129: | Line 129: | ||
| | | | ||
|| | || | ||
| − | ||3. | + | ||3.4 Sorting data |
|| | || | ||
|- | |- | ||
| Line 135: | Line 135: | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.4.1 Using spreadsheet as database |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.4.2 Ascending or descending order |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
| − | || 3. | + | || 3.4.3 Advanced sorting options |
|- | |- | ||
| | | | ||
| Line 154: | Line 154: | ||
| | | | ||
|| | || | ||
| − | ||3. | + | ||3.54 Filtering data |
|| | || | ||
|- | |- | ||
Revision as of 01:46, 27 August 2008
2nd Draft
| Module | Chapter | Topic | Knowledge |
|---|---|---|---|
| OpenOffice.org - Calc | |||
| 3. Calc | |||
| 3.1 Styles | |||
| 3.2 Printing with Calc | |||
| 3.2.1 Printing a spreadsheet | |||
| 3.2.2 Selecting sheets to print | |||
| 3.2.3 Adjusting the print range | |||
| 3.2.4 Page breaks | |||
| 3.2.5 Headers and footers | |||
| 3.3 Formula and functions | |||
| 3.3.1 About formulas | |||
| 3.3.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN) | |||
| 3.3.3 Statistical functions | |||
| 3.3.4 Time and date functions | |||
| 3.3.5 Text functions | |||
| 3.3.6 Math functions | |||
| 3.3.7 Logical functions | |||
| 3.3.8 Information functions | |||
| 3.3.9 Advanced spreadsheet functions | |||
| 3.3.10 Standard errors | |||
| 3.4 Sorting data | |||
| 3.4.1 Using spreadsheet as database | |||
| 3.4.2 Ascending or descending order | |||
| 3.4.3 Advanced sorting options | |||
| 3.54 Filtering data | |||
| 3.4.1 Using autofilter | |||
| 3.4.2 Setting up manual filter | |||
| 3.4.3 Advanced filters | |||
| 3.4.4 Defining filters | |||
| 3.12 Creating charts | |||
| 3.12.1 Using the AutoFormat Chart dialog | |||
| 3.12.2 Chart types | |||
| 3.12.3 Appearance of a chart | |||
| 3.12.4 Modifying the data area of a chart | |||
| 3.12.5 Changing line colors | |||
| 3.12.6 Modifying axes scales | |||
| 3.13 Solver | |||
| 3.13.1 Using Solver | |||
| 3.13.2 Groups and goals | |||
| 3.14 Goal seek | |||
| 3.15 Scenarios | |||
| 3.16 Error Detective | |||
| 3.13. Linking data | |||
| 3.13.1 Why use multiple sheets? | |||
| 3.13.2 Referencing other sheets | |||
| 3.13.3 Referencing other Calc documents | |||
| 3.13.4 Referencing to external data sources | |||
| 3.13.5 Relative, mixed, absolute references | |||
| 3.17 Validity | |||
| 3.18 Subtotals | |||
| 3.19 Grouping and schema |
