Difference between revisions of "Certification/3.0 Calc"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (→‎Syllabus - Calc)
 
(12 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
== Syllabus - Calc ==
+
{{DISPLAYTITLE: Syllabus on Calc}}
  
 
'''2nd Draft'''
 
'''2nd Draft'''
Line 22: Line 22:
 
|-
 
|-
 
|
 
|
−
|| 1. Calc
+
|| 3. Calc
 
||
 
||
 
||  
 
||  
Line 28: Line 28:
 
|
 
|
 
||
 
||
−
|| 1.1 The Calc interface
+
|| 3.1 Styles
−
||
+
−
|-
+
−
|
+
−
||
+
 
||
 
||
−
|| 1.1.1 Menus
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.2 Toolbars
+
||  
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||
+
||3.2 Printing with Calc
−
|| 1.1.3 Formula bar
+
||  
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.4 Individual cells
+
|| 3.2.1 Printing a spreadsheet
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.5 Sheet tabs
+
|| 3.2.2 Selecting sheets to print
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.6 Spreadsheets views
+
|| 3.2.3 Adjusting the print range
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.7 Keyboard shortcuts
+
|| 3.2.4 Page breaks
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
||  
+
|| 3.2.5 Headers and footers
 +
|-
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||1.2 Navigation within spreadsheets
+
|| 3.3 Formula and functions
 
||  
 
||  
 
|-
 
|-
Line 79: Line 75:
 
||
 
||
 
||
 
||
−
|| 1.2.1 Going to a particular cell
+
|| 3.3.1 About formulas
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2.2 Moving from cell to cell
+
|| 3.3.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2.3 Moving from sheet to sheet
+
|| 3.3.3 Statistical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
||  
+
|| 3.3.4 Time and date functions
−
|-
+
−
|
+
−
||
+
−
|| 1.3 Selecting items in a sheet or spreadsheet
+
−
||
+
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.1 Selecting cells
+
|| 3.3.5 Text functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.2 Selecting columns and rows
+
|| 3.3.6 Math functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.3 Selecting sheets
+
|| 3.3.7 Logical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
||  
+
|| 3.3.8 Information functions
−
|-
+
−
|
+
−
||
+
−
|| 1.4 Working with columns and rows
+
−
||
+
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 1.4.1 Inserting columns and rows
+
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 1.4.2 Deleting columns and rows
+
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.3 Freezing columns and rows
+
|| 3.3.9 Advanced spreadsheet functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.4 Splitting windows
+
|| 3.3.10 Standard errors
 
|-
 
|-
 
|
 
|
Line 153: Line 129:
 
|
 
|
 
||
 
||
−
||1.5 Working with sheets
+
||3.4 Sorting data
 
||  
 
||  
 
|-
 
|-
Line 159: Line 135:
 
||
 
||
 
||
 
||
−
|| 1.5.1 Inserting new sheets
+
|| 3.4.1 Using spreadsheet as database
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.2 Deleting sheets
+
|| 3.4.2 Ascending or descending order
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.3 Renaming sheets
+
|| 3.4.3 Advanced sorting options
 
|-
 
|-
 
|
 
|
Line 178: Line 154:
 
|
 
|
 
||
 
||
−
|| 1.6 Entering data
+
||3.5 Filtering data
 
||  
 
||  
 
|-
 
|-
Line 184: Line 160:
 
||
 
||
 
||
 
||
−
|| 1.6.1 Entering numbers
+
|| 3.5.1 Using autofilter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.6.2 Entering text
+
|| 3.5.2 Setting up manual filter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.6.3 Entering numbers as text
+
|| 3.5.3 Advanced filters
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.6.4 Entering dates and times
+
|| 3.5.4 Defining filters
 
|-
 
|-
 
|
 
|
Line 208: Line 184:
 
|
 
|
 
||
 
||
−
||1.7 Editing data
+
||3.6 Creating charts
 
||  
 
||  
 
|-
 
|-
Line 214: Line 190:
 
||
 
||
 
||
 
||
−
|| 1.7.1 Removing text
+
|| 3.6.1 Using the AutoFormat Chart dialog
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.7.2 Removing text and formatting
+
|| 3.6.2 Chart types
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.7.3 Editing part of a cell
+
|| 3.6.3 Appearance of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
||  
+
|| 3.6.4 Modifying the data area of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||1.8 Formatting data and cells
 
−
||
 
−
|-
 
−
|
 
 
||
 
||
−
||
+
|| 3.6.5 Changing line colors
−
|| 1.8.1 Data types
+
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.2 Numbers and other data types
+
|| 3.6.6 Modifying axes scales
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 1.8.3 Fonts
+
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 1.8.4 Alignment
+
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 1.8.5 Borders
+
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 1.8.6 Background
+
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 1.8.7 Cell and sheet protection
+
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 1.8.8 Defining an area
+
 
|-
 
|-
 
|
 
|
Line 283: Line 224:
 
|
 
|
 
||
 
||
−
|| 1.9 Styles
+
|| 3.7 Solver
 
||
 
||
 
|-
 
|-
 
|
 
|
−
||
 
 
||
 
||
 
||  
 
||  
 +
|| 3.7.1 Using Solver
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 1.10 Formula and functions
 
 
||  
 
||  
 +
|| 3.7.2 Groups and goals
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.1 About formulas
+
||  
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.8 Goal seek
 
||
 
||
−
|| 1.10.1 About formulas
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.9 Scenarios
 
||
 
||
−
|| 1.10.3 About functions
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.10 Error Detective
 
||
 
||
−
|| 1.10.4 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
||
 
||
 
||
−
|| 1.10.5 Statistical functions
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.10.6 Time and date functions
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.10.6 Time and date functions
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.10.7 Text functions
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.10.8 Math functions
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.10.9 Logical functions
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.10.10 Information functions
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.10.11 Advanced spreadsheet functions
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.10.12 Standard errors
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
||
 
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||1.11 Sorting data
+
||3.11. Linking data
 
||  
 
||  
 
|-
 
|-
Line 374: Line 270:
 
||
 
||
 
||
 
||
−
||1.11.1 Using spreadsheet as database
+
|| 3.11.1 Why use multiple sheets?
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.11.2 Ascending or descending order
+
|| 3.11.2 Referencing other sheets
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.11.3 Advanced sorting options
+
|| 3.11.3 Referencing other Calc documents
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.11.4 Defining filters
+
|| 3.11.4 Referencing to external data sources
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
||  
+
|| 3.11.5 Relative, mixed, absolute references
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||1.12 Creating charts
 
−
||
 
−
|-
 
−
|
 
 
||
 
||
 
||
 
||
−
|| 1.12.1 Using the AutoFormat Chart dialog
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.12 Validity
 
||
 
||
−
|| 1.12.2 Chart types
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.12.3 Appearance of a chart
 
−
|-
 
−
|
 
 
||
 
||
−
||
 
−
|| 1.12.4 Modifying the data area of a chart
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.13 Subtotals
 
||
 
||
−
|| 1.12.5 Changing line colors
 
 
|-
 
|-
 
|
 
|
−
||
 
−
||
 
−
|| 1.12.6 Modifying axes scales
 
−
|-
 
−
|
 
−
||
 
 
||
 
||
 
||  
 
||  
−
|-
 
−
|
 
−
||
 
−
||1.13. Linking data
 
−
||
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.13.1 Why use multiple sheets?
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
|| 1.13.2 Referencing other sheets
 
−
|-
 
−
|
 
−
||
 
 
||
 
||
−
|| 1.13.3 Referencing other Calc documents
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.14 Grouping and schema
 
||
 
||
−
|| 1.13.4 Referencing to external data sources
 
 
|-
 
|-
 +
[[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