Difference between revisions of "Certification/3.0 Calc"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(7 intermediate revisions by 3 users not shown)
Line 35: Line 35:
 
||
 
||
 
||  
 
||  
 +
|-
 
|
 
|
 
||
 
||
−
||3.14 Printing with Calc
+
||3.2 Printing with Calc
 
||  
 
||  
 
|-
 
|-
Line 43: Line 44:
 
||
 
||
 
||
 
||
−
|| 3.14.1 Printing a spreadsheet
+
|| 3.2.1 Printing a spreadsheet
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.14.2 Selecting sheets to print
+
|| 3.2.2 Selecting sheets to print
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.14.3 Adjusting the print range
+
|| 3.2.3 Adjusting the print range
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.14.4 Page breaks
+
|| 3.2.4 Page breaks
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.14.5 Headers and footers
+
|| 3.2.5 Headers and footers
 
|-
 
|-
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 3.2 Formula and functions
+
|| 3.3 Formula and functions
 
||  
 
||  
 
|-
 
|-
Line 74: Line 75:
 
||
 
||
 
||
 
||
−
|| 3.2.1 About formulas
+
|| 3.3.1 About formulas
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
+
|| 3.3.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.3 Statistical functions
+
|| 3.3.3 Statistical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.4 Time and date functions
+
|| 3.3.4 Time and date functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.5 Time and date functions
+
|| 3.3.5 Text functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.5 Text functions
+
|| 3.3.6 Math functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.6 Math functions
+
|| 3.3.7 Logical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.7 Logical functions
+
|| 3.3.8 Information functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.8 Information functions
+
|| 3.3.9 Advanced spreadsheet functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.9 Advanced spreadsheet functions
+
|| 3.3.10 Standard errors
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.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
 
|-
 
|-
 
|
 
|
Line 133: Line 154:
 
|
 
|
 
||
 
||
−
||3.3 Sorting data
+
||3.5 Filtering data
 
||  
 
||  
 
|-
 
|-
Line 139: Line 160:
 
||
 
||
 
||
 
||
−
|| 3.3.1 Using spreadsheet as database
+
|| 3.5.1 Using autofilter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.3.2 Ascending or descending order
+
|| 3.5.2 Setting up manual filter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.3.3 Advanced sorting options
+
|| 3.5.3 Advanced filters
 +
|-
 +
|
 +
||
 +
||
 +
|| 3.5.4 Defining filters
 
|-
 
|-
 
|
 
|
Line 158: Line 184:
 
|
 
|
 
||
 
||
−
||3.4 Filtering data
+
||3.6 Creating charts
 
||  
 
||  
 
|-
 
|-
Line 164: Line 190:
 
||
 
||
 
||
 
||
−
|| 3.4.1 Using autofilter
+
|| 3.6.1 Using the AutoFormat Chart dialog
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.4.2 Setting up manual filter
+
|| 3.6.2 Chart types
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.4.3 Advanced filters
+
|| 3.6.3 Appearance of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.4.4 Defining filters
+
|| 3.6.4 Modifying the data area of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||3.12 Creating charts
+
||
−
||  
+
|| 3.6.5 Changing line colors
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.12.1 Using the AutoFormat Chart dialog
+
|| 3.6.6 Modifying axes scales
 
|-
 
|-
 
|
 
|
Line 198: Line 224:
 
|
 
|
 
||
 
||
−
|| 3.13 Solver
+
|| 3.7 Solver
 
||
 
||
 
|-
 
|-
Line 204: Line 230:
 
||
 
||
 
||  
 
||  
−
|| 3.13.1 Using Solver
+
|| 3.7.1 Using Solver
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||  
 
||  
−
|| 3.13.2 Groups and goals
+
|| 3.7.2 Groups and goals
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.12.2 Chart types
+
||  
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.8 Goal seek
 
||
 
||
−
|| 3.12.3 Appearance of a chart
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.9 Scenarios
 
||
 
||
−
|| 3.12.4 Modifying the data area of a chart
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.10 Error Detective
 
||
 
||
−
|| 3.12.5 Changing line colors
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
||
 
||
 
||
−
|| 3.12.6 Modifying axes scales
 
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||
+
||3.11. Linking data
 
||  
 
||  
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||  
+
||
−
|| 3.13.1 Using Solver
+
|| 3.11.1 Why use multiple sheets?
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
||  
+
|| 3.11.2 Referencing other sheets
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 3.14 Goal seek
 
 
||
 
||
 +
|| 3.11.3 Referencing other Calc documents
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 3.15 Escenarios
 
 
||
 
||
 +
|| 3.11.4 Referencing to external data sources
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 3.16 Error Detective
 
 
||
 
||
 +
|| 3.11.5 Relative, mixed, absolute references
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||3.13. Linking data
+
||
−
||  
+
||
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.12 Validity
 
||
 
||
−
|| 3.13.1 Why use multiple sheets?
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.13.2 Referencing other sheets
+
||
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.13 Subtotals
 
||
 
||
−
|| 3.13.3 Referencing other Calc documents
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
||
 
||
 
||
−
|| 3.13.4 Referencing to external data sources
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.14 Grouping and schema
 
||
 
||
−
|| 3.13.5 Relative, mixed, absolute references
+
|-
 +
[[Category:Certification]]

Latest revision as of 09:17, 25 November 2009


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.5 Filtering data
3.5.1 Using autofilter
3.5.2 Setting up manual filter
3.5.3 Advanced filters
3.5.4 Defining filters
3.6 Creating charts
3.6.1 Using the AutoFormat Chart dialog
3.6.2 Chart types
3.6.3 Appearance of a chart
3.6.4 Modifying the data area of a chart
3.6.5 Changing line colors
3.6.6 Modifying axes scales
3.7 Solver
3.7.1 Using Solver
3.7.2 Groups and goals
3.8 Goal seek
3.9 Scenarios
3.10 Error Detective
3.11. Linking data
3.11.1 Why use multiple sheets?
3.11.2 Referencing other sheets
3.11.3 Referencing other Calc documents
3.11.4 Referencing to external data sources
3.11.5 Relative, mixed, absolute references
3.12 Validity
3.13 Subtotals
3.14 Grouping and schema
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Certification/3.0_Calc&oldid=149565"
Personal tools