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 ||...)
 
m (→‎Syllabus - Calc)
Line 1: Line 1:
−
 
 
== Syllabus - Calc ==
 
== Syllabus - Calc ==
  
Line 176: Line 175:
 
||
 
||
 
||  
 
||  
 +
|-
 +
|
 +
||
 +
|| 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
 
|-
 
|-
 
|
 
|
Line 181: Line 205:
 
||
 
||
 
||  
 
||  
 +
|-
 +
|
 +
||
 +
||1.7 Editing data
 +
||
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.7.1 Removing text
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.7.2 Removing text and formatting
 +
|-
 +
|
 +
||
 +
||
 +
|| 1.7.3 Editing part of a cell
 
|-
 
|-
 
|
 
|
Line 189: Line 233:
 
|
 
|
 
||
 
||
 +
||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
 
||  
 
||  
 
|-
 
|-

Revision as of 12:01, 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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Certification/3.0_Calc&oldid=77074"
Personal tools