Difference between revisions of "Certification/3.0 Calc"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(5 intermediate revisions by 3 users not shown)
Line 38: Line 38:
 
|
 
|
 
||
 
||
−
||3.14 Printing with Calc
+
||3.2 Printing with Calc
 
||  
 
||  
 
|-
 
|-
Line 44: 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 75: 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
+
 
|-
 
|-
 
|
 
|
Line 134: Line 129:
 
|
 
|
 
||
 
||
−
||3.3 Sorting data
+
||3.4 Sorting data
 
||  
 
||  
 
|-
 
|-
Line 140: Line 135:
 
||
 
||
 
||
 
||
−
|| 3.3.1 Using spreadsheet as database
+
|| 3.4.1 Using spreadsheet as database
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.3.2 Ascending or descending order
+
|| 3.4.2 Ascending or descending order
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.3.3 Advanced sorting options
+
|| 3.4.3 Advanced sorting options
 
|-
 
|-
 
|
 
|
Line 159: Line 154:
 
|
 
|
 
||
 
||
−
||3.4 Filtering data
+
||3.5 Filtering data
 
||  
 
||  
 
|-
 
|-
Line 165: Line 160:
 
||
 
||
 
||
 
||
−
|| 3.4.1 Using autofilter
+
|| 3.5.1 Using autofilter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.4.2 Setting up manual filter
+
|| 3.5.2 Setting up manual filter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.4.3 Advanced filters
+
|| 3.5.3 Advanced filters
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.4.4 Defining filters
+
|| 3.5.4 Defining filters
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||3.12 Creating charts
+
||
 +
||
 +
|-
 +
|
 +
||
 +
||3.6 Creating charts
 
||  
 
||  
 
|-
 
|-
Line 190: Line 190:
 
||
 
||
 
||
 
||
−
|| 3.12.1 Using the AutoFormat Chart dialog
+
|| 3.6.1 Using the AutoFormat Chart dialog
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.12.2 Chart types
+
|| 3.6.2 Chart types
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.12.3 Appearance of a chart
+
|| 3.6.3 Appearance of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.12.4 Modifying the data area of a chart
+
|| 3.6.4 Modifying the data area of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.12.5 Changing line colors
+
|| 3.6.5 Changing line colors
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.12.6 Modifying axes scales
+
|| 3.6.6 Modifying axes scales
 
|-
 
|-
 
|
 
|
Line 224: Line 224:
 
|
 
|
 
||
 
||
−
|| 3.13 Solver
+
|| 3.7 Solver
 
||
 
||
 
|-
 
|-
Line 230: Line 230:
 
||
 
||
 
||  
 
||  
−
|| 3.13.1 Using Solver
+
|| 3.7.1 Using Solver
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||  
 
||  
−
|| 3.13.2 Groups and goals
+
|| 3.7.2 Groups and goals
 
|-
 
|-
 
|
 
|
Line 244: Line 244:
 
|
 
|
 
||
 
||
−
|| 3.14 Goal seek
+
|| 3.8 Goal seek
 
||
 
||
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 3.15 Escenarios
+
|| 3.9 Scenarios
 
||
 
||
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 3.16 Error Detective
+
|| 3.10 Error Detective
 
||
 
||
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||3.13. Linking data
 
 
||  
 
||  
 +
||
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
||3.11. Linking data
 +
||
 +
|-
 +
|
 
||
 
||
−
|| 3.13.1 Why use multiple sheets?
+
||
 +
|| 3.11.1 Why use multiple sheets?
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.13.2 Referencing other sheets
+
|| 3.11.2 Referencing other sheets
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.13.3 Referencing other Calc documents
+
|| 3.11.3 Referencing other Calc documents
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.13.4 Referencing to external data sources
+
|| 3.11.4 Referencing to external data sources
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.13.5 Relative, mixed, absolute references
+
|| 3.11.5 Relative, mixed, absolute references
 +
|-
 +
|
 +
||
 +
||
 +
||
 +
|-
 +
|
 +
||
 +
|| 3.12 Validity
 +
||
 +
|-
 +
|
 +
||
 +
||
 +
||
 +
|-
 +
|
 +
||
 +
|| 3.13 Subtotals
 +
||
 +
|-
 +
|
 +
||
 +
||
 +
||
 +
|-
 +
|
 +
||
 +
|| 3.14 Grouping and schema
 +
||
 +
|-
 +
[[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