Difference between revisions of "Certification/3.0 Calc"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (New page: == Syllabus - Calc == '''2nd Draft''' {| class="prettytable sortable" |- ! Module !| Chapter !| Topic !| Knowledge |- | || || || |- | OpenOffice.org - Calc || || || |- | || 1. Calc ||...)
 
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
 
+
{{DISPLAYTITLE: Syllabus on Calc}}
−
== Syllabus - Calc ==
+
  
 
'''2nd Draft'''
 
'''2nd Draft'''
Line 23: Line 22:
 
|-
 
|-
 
|
 
|
−
|| 1. Calc
+
|| 3. Calc
 
||
 
||
 
||  
 
||  
Line 29: Line 28:
 
|
 
|
 
||
 
||
−
|| 1.1 The Calc interface
+
|| 3.1 Styles
 +
||
 +
|-
 +
|
 +
||
 +
||
 +
||
 +
|-
 +
|
 +
||
 +
||3.2 Printing with Calc
 
||  
 
||  
 
|-
 
|-
Line 35: Line 44:
 
||
 
||
 
||
 
||
−
|| 1.1.1 Menus
+
|| 3.2.1 Printing a spreadsheet
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.2 Toolbars
+
|| 3.2.2 Selecting sheets to print
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.3 Formula bar
+
|| 3.2.3 Adjusting the print range
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.4 Individual cells
+
|| 3.2.4 Page breaks
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.5 Sheet tabs
+
|| 3.2.5 Headers and footers
 +
|-
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.3 Formula and functions
 +
||
 +
|-
 +
|
 
||
 
||
−
|| 1.1.6 Spreadsheets views
+
||
 +
|| 3.3.1 About formulas
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.7 Keyboard shortcuts
+
|| 3.3.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
||  
+
|| 3.3.3 Statistical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||1.2 Navigation within spreadsheets
+
||
−
||  
+
|| 3.3.4 Time and date functions
 +
|-
 +
|
 +
||
 +
||
 +
|| 3.3.5 Text functions
 +
|-
 +
|
 +
||
 +
||
 +
|| 3.3.6 Math functions
 +
|-
 +
|
 +
||
 +
||
 +
|| 3.3.7 Logical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2.1 Going to a particular cell
+
|| 3.3.8 Information functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2.2 Moving from cell to cell
+
|| 3.3.9 Advanced spreadsheet functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2.3 Moving from sheet to sheet
+
|| 3.3.10 Standard errors
 
|-
 
|-
 
|
 
|
Line 99: Line 129:
 
|
 
|
 
||
 
||
−
|| 1.3 Selecting items in a sheet or spreadsheet
+
||3.4 Sorting data
 
||  
 
||  
 
|-
 
|-
Line 105: Line 135:
 
||
 
||
 
||
 
||
−
|| 1.3.1 Selecting cells
+
|| 3.4.1 Using spreadsheet as database
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.2 Selecting columns and rows
+
|| 3.4.2 Ascending or descending order
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.3 Selecting sheets
+
|| 3.4.3 Advanced sorting options
 
|-
 
|-
 
|
 
|
Line 124: Line 154:
 
|
 
|
 
||
 
||
−
|| 1.4 Working with columns and rows
+
||3.5 Filtering data
 
||  
 
||  
 
|-
 
|-
Line 130: Line 160:
 
||
 
||
 
||
 
||
−
|| 1.4.1 Inserting columns and rows
+
|| 3.5.1 Using autofilter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.2 Deleting columns and rows
+
|| 3.5.2 Setting up manual filter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.3 Freezing columns and rows
+
|| 3.5.3 Advanced filters
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.4 Splitting windows
+
|| 3.5.4 Defining filters
 
|-
 
|-
 
|
 
|
Line 154: Line 184:
 
|
 
|
 
||
 
||
−
||1.5 Working with sheets
+
||3.6 Creating charts
 
||  
 
||  
 
|-
 
|-
Line 160: Line 190:
 
||
 
||
 
||
 
||
−
|| 1.5.1 Inserting new sheets
+
|| 3.6.1 Using the AutoFormat Chart dialog
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.2 Deleting sheets
+
|| 3.6.2 Chart types
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.3 Renaming sheets
+
|| 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
 
|-
 
|-
 
|
 
|
Line 179: Line 224:
 
|
 
|
 
||
 
||
 +
|| 3.7 Solver
 +
||
 +
|-
 +
|
 
||
 
||
 
||  
 
||  
 +
|| 3.7.1 Using Solver
 +
|-
 +
|
 +
||
 +
||
 +
|| 3.7.2 Groups and goals
 
|-
 
|-
 
|
 
|
Line 189: Line 244:
 
|
 
|
 
||
 
||
 +
|| 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
 +
||
 
|-
 
|-
 +
[[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