Difference between revisions of "Certification/3.0 Calc"

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