Difference between revisions of "Certification/3.0 Calc"
From Apache OpenOffice Wiki
m (changed chap # from 1 to 3, rh.) |
|||
Line 28: | Line 28: | ||
| | | | ||
|| | || | ||
− | || 3.1 | + | || 3.1 Styles |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
|| | || | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| | | | ||
Line 70: | Line 35: | ||
|| | || | ||
|| | || | ||
− | |||
| | | | ||
|| | || | ||
− | ||3. | + | ||3.14 Printing with Calc |
|| | || | ||
|- | |- | ||
Line 79: | Line 43: | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.14.1 Printing a spreadsheet |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.14.2 Selecting sheets to print |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.14.3 Adjusting the print range |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || | + | || 3.14.4 Page breaks |
|- | |- | ||
| | | | ||
|| | || | ||
− | |||
− | |||
− | |||
− | |||
|| | || | ||
− | + | || 3.14.5 Headers and footers | |
− | || 3. | + | |
|- | |- | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| | | | ||
|| | || | ||
− | || 3. | + | || 3.2 Formula and functions |
|| | || | ||
|- | |- | ||
Line 129: | Line 74: | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.2.1 About formulas |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.2.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN) |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.2.3 Statistical functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.2.4 Time and date functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || | + | || 3.2.5 Time and date functions |
|- | |- | ||
| | | | ||
|| | || | ||
− | |||
− | |||
− | |||
− | |||
|| | || | ||
− | + | || 3.2.5 Text functions | |
− | || 3. | + | |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3 | + | || 3.2.6 Math functions |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.2.7 Logical functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3 | + | || 3.2.8 Information functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.2.9 Advanced spreadsheet functions |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.2.10 Standard errors |
|- | |- | ||
| | | | ||
Line 208: | Line 133: | ||
| | | | ||
|| | || | ||
− | ||3. | + | ||3.3 Sorting data |
|| | || | ||
|- | |- | ||
Line 214: | Line 139: | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.3.1 Using spreadsheet as database |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.3.2 Ascending or descending order |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.3.3 Advanced sorting options |
|- | |- | ||
| | | | ||
Line 233: | Line 158: | ||
| | | | ||
|| | || | ||
− | ||3. | + | ||3.4 Filtering data |
|| | || | ||
|- | |- | ||
Line 239: | Line 164: | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.4.1 Using autofilter |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.4.2 Setting up manual filter |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.4.3 Advanced filters |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.4.4 Defining filters |
|- | |- | ||
| | | | ||
|| | || | ||
− | || | + | ||3.12 Creating charts |
− | || | + | || |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.12.1 Using the AutoFormat Chart dialog |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
|- | |- | ||
| | | | ||
Line 283: | Line 198: | ||
| | | | ||
|| | || | ||
− | || 3. | + | || 3.13 Solver |
|| | || | ||
|- | |- | ||
| | | | ||
− | |||
|| | || | ||
|| | || | ||
+ | || 3.13.1 Using Solver | ||
|- | |- | ||
| | | | ||
|| | || | ||
− | |||
|| | || | ||
+ | || 3.13.2 Groups and goals | ||
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.12.2 Chart types |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.12.3 Appearance of a chart |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.12.4 Modifying the data area of a chart |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.12.5 Changing line colors |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 3. | + | || 3.12.6 Modifying axes scales |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
|- | |- | ||
| | | | ||
Line 358: | Line 243: | ||
| | | | ||
|| | || | ||
− | |||
|| | || | ||
− | + | || 3.13.1 Using Solver | |
− | + | ||
− | + | ||
− | + | ||
− | || 3. | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
|- | |- | ||
| | | | ||
Line 388: | Line 253: | ||
| | | | ||
|| | || | ||
− | ||3. | + | || 3.14 Goal seek |
− | + | ||
− | + | ||
− | + | ||
|| | || | ||
− | |||
− | |||
|- | |- | ||
| | | | ||
|| | || | ||
+ | || 3.15 Escenarios | ||
|| | || | ||
− | |||
|- | |- | ||
| | | | ||
|| | || | ||
+ | || 3.16 Error Detective | ||
|| | || | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| | | | ||
Line 455: | Line 295: | ||
|| | || | ||
|| 3.13.5 Relative, mixed, absolute references | || 3.13.5 Relative, mixed, absolute references | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 01:20, 22 August 2008
2nd Draft
Module | Chapter | Topic | Knowledge | ||||
---|---|---|---|---|---|---|---|
OpenOffice.org - Calc | |||||||
3. Calc | |||||||
3.1 Styles | |||||||
3.14 Printing with Calc | |||||||
3.14.1 Printing a spreadsheet | |||||||
3.14.2 Selecting sheets to print | |||||||
3.14.3 Adjusting the print range | |||||||
3.14.4 Page breaks | |||||||
3.14.5 Headers and footers | |||||||
3.2 Formula and functions | |||||||
3.2.1 About formulas | |||||||
3.2.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN) | |||||||
3.2.3 Statistical functions | |||||||
3.2.4 Time and date functions | |||||||
3.2.5 Time and date functions | |||||||
3.2.5 Text functions | |||||||
3.2.6 Math functions | |||||||
3.2.7 Logical functions | |||||||
3.2.8 Information functions | |||||||
3.2.9 Advanced spreadsheet functions | |||||||
3.2.10 Standard errors | |||||||
3.3 Sorting data | |||||||
3.3.1 Using spreadsheet as database | |||||||
3.3.2 Ascending or descending order | |||||||
3.3.3 Advanced sorting options | |||||||
3.4 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.13 Solver | |||||||
3.13.1 Using Solver | |||||||
3.13.2 Groups and goals | |||||||
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.1 Using Solver | |||||||
3.14 Goal seek | |||||||
3.15 Escenarios | |||||||
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 |