Difference between revisions of "Certification/3.0 Calc"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (→‎Syllabus - Calc)
m (→‎Syllabus - Calc)
Line 370: Line 370:
 
||1.11 Sorting data
 
||1.11 Sorting data
 
||  
 
||  
 +
|-
 +
|
 +
||
 +
||
 +
||1.11.1 Using spreadsheet as database
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.11.2 Ascending or descending order
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.11.3 Advanced sorting options
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.11.4 Defining filters
 +
|-
 +
|
 +
||
 +
||
 +
||
 +
|-
 +
|
 +
||
 +
||1.12 Creating charts
 +
||
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.12.1 Using the AutoFormat Chart dialog
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.12.2 Chart types
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.12.3 Appearance of a chart
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.12.4 Modifying the data area of a chart
 +
|-
 +
|
 +
||
 +
||
 +
|| 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
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.13.4 Referencing to external data sources
 
|-
 
|-

Revision as of 12:08, 13 May 2008

Syllabus - Calc

2nd Draft

Module Chapter Topic Knowledge
OpenOffice.org - Calc
1. Calc
1.1 The Calc interface
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
1.2 Navigation within spreadsheets
1.2.1 Going to a particular cell
1.2.2 Moving from cell to cell
1.2.3 Moving from sheet to sheet
1.3 Selecting items in a sheet or spreadsheet
1.3.1 Selecting cells
1.3.2 Selecting columns and rows
1.3.3 Selecting sheets
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
1.4.4 Splitting windows
1.5 Working with sheets
1.5.1 Inserting new sheets
1.5.2 Deleting sheets
1.5.3 Renaming sheets
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
1.7 Editing data
1.7.1 Removing text
1.7.2 Removing text and formatting
1.7.3 Editing part of a cell
1.8 Formatting data and cells
1.8.1 Data types
1.8.2 Numbers and other data types
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
1.9 Styles
1.10 Formula and functions
1.10.1 About formulas
1.10.1 About formulas
1.10.3 About functions
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
1.11.1 Using spreadsheet as database
1.11.2 Ascending or descending order
1.11.3 Advanced sorting options
1.11.4 Defining filters
1.12 Creating charts
1.12.1 Using the AutoFormat Chart dialog
1.12.2 Chart types
1.12.3 Appearance of a chart
1.12.4 Modifying the data area of a chart
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
1.13.4 Referencing to external data sources
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Certification/3.0_Calc&oldid=77075"
Personal tools