Difference between revisions of "Certification/3.0 Calc"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (→‎Syllabus - Calc)
 
(13 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
+
−
||
+
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.1 Data types
+
|| 3.6.5 Changing line colors
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.2 Numbers and other data types
+
|| 3.6.6 Modifying axes scales
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.3 Fonts
+
||  
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.7 Solver
 
||
 
||
−
|| 1.8.4 Alignment
 
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||
+
||  
−
|| 1.8.5 Borders
+
|| 3.7.1 Using Solver
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||
+
||  
−
|| 1.8.6 Background
+
|| 3.7.2 Groups and goals
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.7 Cell and sheet protection
+
||  
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.8 Goal seek
 
||
 
||
−
|| 1.8.8 Defining an area
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.9 Scenarios
 
||
 
||
−
||
 
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 1.9 Styles
+
|| 3.10 Error Detective
 
||
 
||
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
||
 
||
 
||
−
||
 
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 1.10 Formula and functions
+
||3.11. Linking data
 
||  
 
||  
 
|-
 
|-
Line 299: Line 270:
 
||
 
||
 
||
 
||
−
|| 1.10.1 About formulas
+
|| 3.11.1 Why use multiple sheets?
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.1 About formulas
+
|| 3.11.2 Referencing other sheets
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.3 About functions
+
|| 3.11.3 Referencing other Calc documents
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.4 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
+
|| 3.11.4 Referencing to external data sources
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.5 Statistical functions
+
|| 3.11.5 Relative, mixed, absolute references
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||
 
−
|| 1.10.6 Time and date functions
 
−
|-
 
−
|
 
 
||
 
||
 
||
 
||
−
|| 1.10.6 Time and date functions
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.12 Validity
 
||
 
||
−
|| 1.10.7 Text functions
 
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||
 
−
|| 1.10.8 Math functions
 
−
|-
 
−
|
 
 
||
 
||
 
||
 
||
−
|| 1.10.9 Logical functions
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.13 Subtotals
 
||
 
||
−
|| 1.10.10 Information functions
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
||
 
||
 
||
−
|| 1.10.11 Advanced spreadsheet functions
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.14 Grouping and schema
 
||
 
||
−
|| 1.10.12 Standard errors
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
||
 
−
|-
 
−
|
 
−
||
 
−
||1.11 Sorting data
 
−
||
 
 
|-
 
|-
 +
[[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