Difference between revisions of "Certification/3.0 Calc"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (changed chap # from 1 to 3, rh.)
Line 22: Line 22:
 
|-
 
|-
 
|
 
|
−
|| 1. Calc
+
|| 3. Calc
 
||
 
||
 
||  
 
||  
Line 28: Line 28:
 
|
 
|
 
||
 
||
−
|| 1.1 The Calc interface
+
|| 3.1 The Calc interface
 
||  
 
||  
 
|-
 
|-
Line 34: Line 34:
 
||
 
||
 
||
 
||
−
|| 1.1.1 Menus
+
|| 3.1.1 Menus
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.2 Toolbars
+
|| 3.1.2 Toolbars
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.3 Formula bar
+
|| 3.1.3 Formula bar
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.4 Individual cells
+
|| 3.1.4 Individual cells
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.5 Sheet tabs
+
|| 3.1.5 Sheet tabs
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.6 Spreadsheets views
+
|| 3.1.6 Spreadsheets views
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.1.7 Keyboard shortcuts
+
|| 3.1.7 Keyboard shortcuts
 
|-
 
|-
 
|
 
|
Line 73: Line 73:
 
|
 
|
 
||
 
||
−
||1.2 Navigation within spreadsheets
+
||3.2 Navigation within spreadsheets
 
||  
 
||  
 
|-
 
|-
Line 79: Line 79:
 
||
 
||
 
||
 
||
−
|| 1.2.1 Going to a particular cell
+
|| 3.2.1 Going to a particular cell
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2.2 Moving from cell to cell
+
|| 3.2.2 Moving from cell to cell
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2.3 Moving from sheet to sheet
+
|| 3.2.3 Moving from sheet to sheet
 
|-
 
|-
 
|
 
|
Line 98: Line 98:
 
|
 
|
 
||
 
||
−
|| 1.3 Selecting items in a sheet or spreadsheet
+
|| 3.3 Selecting items in a sheet or spreadsheet
 
||  
 
||  
 
|-
 
|-
Line 104: Line 104:
 
||
 
||
 
||
 
||
−
|| 1.3.1 Selecting cells
+
|| 3.3.1 Selecting cells
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.2 Selecting columns and rows
+
|| 3.3.2 Selecting columns and rows
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.3 Selecting sheets
+
|| 3.3.3 Selecting sheets
 
|-
 
|-
 
|
 
|
Line 123: Line 123:
 
|
 
|
 
||
 
||
−
|| 1.4 Working with columns and rows
+
|| 3.4 Working with columns and rows
 
||  
 
||  
 
|-
 
|-
Line 129: Line 129:
 
||
 
||
 
||
 
||
−
|| 1.4.1 Inserting columns and rows
+
|| 3.4.1 Inserting columns and rows
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.2 Deleting columns and rows
+
|| 3.4.2 Deleting columns and rows
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.3 Freezing columns and rows
+
|| 3.4.3 Freezing columns and rows
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.4 Splitting windows
+
|| 3.4.4 Splitting windows
 
|-
 
|-
 
|
 
|
Line 153: Line 153:
 
|
 
|
 
||
 
||
−
||1.5 Working with sheets
+
||3.5 Working with sheets
 
||  
 
||  
 
|-
 
|-
Line 159: Line 159:
 
||
 
||
 
||
 
||
−
|| 1.5.1 Inserting new sheets
+
|| 3.5.1 Inserting new sheets
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.2 Deleting sheets
+
|| 3.5.2 Deleting sheets
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.3 Renaming sheets
+
|| 3.5.3 Renaming sheets
 
|-
 
|-
 
|
 
|
Line 178: Line 178:
 
|
 
|
 
||
 
||
−
|| 1.6 Entering data
+
|| 3.6 Entering data
 
||  
 
||  
 
|-
 
|-
Line 184: Line 184:
 
||
 
||
 
||
 
||
−
|| 1.6.1 Entering numbers
+
|| 3.6.1 Entering numbers
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.6.2 Entering text
+
|| 3.6.2 Entering text
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.6.3 Entering numbers as text
+
|| 3.6.3 Entering numbers as text
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.6.4 Entering dates and times
+
|| 3.6.4 Entering dates and times
 
|-
 
|-
 
|
 
|
Line 208: Line 208:
 
|
 
|
 
||
 
||
−
||1.7 Editing data
+
||3.7 Editing data
 
||  
 
||  
 
|-
 
|-
Line 214: Line 214:
 
||
 
||
 
||
 
||
−
|| 1.7.1 Removing text
+
|| 3.7.1 Removing text
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.7.2 Removing text and formatting
+
|| 3.7.2 Removing text and formatting
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.7.3 Editing part of a cell
+
|| 3.7.3 Editing part of a cell
 
|-
 
|-
 
|
 
|
Line 233: Line 233:
 
|
 
|
 
||
 
||
−
||1.8 Formatting data and cells
+
||3.8 Formatting data and cells
 
||  
 
||  
 
|-
 
|-
Line 239: Line 239:
 
||
 
||
 
||
 
||
−
|| 1.8.1 Data types
+
|| 3.8.1 Data types
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.2 Numbers and other data types
+
|| 3.8.2 Numbers and other data types
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.3 Fonts
+
|| 3.8.3 Fonts
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.4 Alignment
+
|| 3.8.4 Alignment
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.5 Borders
+
|| 3.8.5 Borders
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.6 Background
+
|| 3.8.6 Background
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.7 Cell and sheet protection
+
|| 3.8.7 Cell and sheet protection
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.8.8 Defining an area
+
|| 3.8.8 Defining an area
 
|-
 
|-
 
|
 
|
Line 283: Line 283:
 
|
 
|
 
||
 
||
−
|| 1.9 Styles
+
|| 3.9 Styles
 
||
 
||
 
|-
 
|-
Line 293: Line 293:
 
|
 
|
 
||
 
||
−
|| 1.10 Formula and functions
+
|| 3.10 Formula and functions
 
||  
 
||  
 
|-
 
|-
Line 299: Line 299:
 
||
 
||
 
||
 
||
−
|| 1.10.1 About formulas
+
|| 3.10.1 About formulas
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
+
|| 3.10.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.3 Statistical functions
+
|| 3.10.3 Statistical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.4 Time and date functions
+
|| 3.10.4 Time and date functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.5 Time and date functions
+
|| 3.10.5 Time and date functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.5 Text functions
+
|| 3.10.5 Text functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.6 Math functions
+
|| 3.10.6 Math functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.7 Logical functions
+
|| 3.10.7 Logical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.8 Information functions
+
|| 3.10.8 Information functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.9 Advanced spreadsheet functions
+
|| 3.10.9 Advanced spreadsheet functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.10.10 Standard errors
+
|| 3.10.10 Standard errors
 
|-
 
|-
 
|
 
|
Line 358: Line 358:
 
|
 
|
 
||
 
||
−
||1.11 Sorting data
+
||3.11 Sorting data
 
||  
 
||  
 
|-
 
|-
Line 364: Line 364:
 
||
 
||
 
||
 
||
−
||1.11.1 Using spreadsheet as database
+
|| 3.11.1 Using spreadsheet as database
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.11.2 Ascending or descending order
+
|| 3.11.2 Ascending or descending order
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.11.3 Advanced sorting options
+
|| 3.11.3 Advanced sorting options
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.11.4 Defining filters
+
|| 3.11.4 Defining filters
 
|-
 
|-
 
|
 
|
Line 388: Line 388:
 
|
 
|
 
||
 
||
−
||1.12 Creating charts
+
||3.12 Creating charts
 
||  
 
||  
 
|-
 
|-
Line 394: Line 394:
 
||
 
||
 
||
 
||
−
|| 1.12.1 Using the AutoFormat Chart dialog
+
|| 3.12.1 Using the AutoFormat Chart dialog
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.12.2 Chart types
+
|| 3.12.2 Chart types
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.12.3 Appearance of a chart
+
|| 3.12.3 Appearance of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.12.4 Modifying the data area of a chart
+
|| 3.12.4 Modifying the data area of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.12.5 Changing line colors
+
|| 3.12.5 Changing line colors
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.12.6 Modifying axes scales
+
|| 3.12.6 Modifying axes scales
 
|-
 
|-
 
|
 
|
Line 428: Line 428:
 
|
 
|
 
||
 
||
−
||1.13. Linking data
+
||3.13. Linking data
 
||  
 
||  
 
|-
 
|-
Line 434: Line 434:
 
||
 
||
 
||
 
||
−
|| 1.13.1 Why use multiple sheets?
+
|| 3.13.1 Why use multiple sheets?
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.13.2 Referencing other sheets
+
|| 3.13.2 Referencing other sheets
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.13.3 Referencing other Calc documents
+
|| 3.13.3 Referencing other Calc documents
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.13.4 Referencing to external data sources
+
|| 3.13.4 Referencing to external data sources
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.13.5 Relative, mixed, absolute references
+
|| 3.13.5 Relative, mixed, absolute references
 
|-
 
|-
 
|
 
|
Line 463: Line 463:
 
|
 
|
 
||
 
||
−
||1.14 Printing with Calc
+
||3.14 Printing with Calc
 
||  
 
||  
 
|-
 
|-
Line 469: Line 469:
 
||
 
||
 
||
 
||
−
|| 1.14.1 Printing a spreadsheet
+
|| 3.14.1 Printing a spreadsheet
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.14.2 Selecting sheets to print
+
|| 3.14.2 Selecting sheets to print
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.14.3 Adjusting the print range
+
|| 3.14.3 Adjusting the print range
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.14.4 Page breaks
+
|| 3.14.4 Page breaks
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.14.5 Headers and footers
+
|| 3.14.5 Headers and footers
 
|-
 
|-

Revision as of 01:45, 19 August 2008


2nd Draft

Module Chapter Topic Knowledge
OpenOffice.org - Calc
3. Calc
3.1 The Calc interface
3.1.1 Menus
3.1.2 Toolbars
3.1.3 Formula bar
3.1.4 Individual cells
3.1.5 Sheet tabs
3.1.6 Spreadsheets views
3.1.7 Keyboard shortcuts
3.2 Navigation within spreadsheets
3.2.1 Going to a particular cell
3.2.2 Moving from cell to cell
3.2.3 Moving from sheet to sheet
3.3 Selecting items in a sheet or spreadsheet
3.3.1 Selecting cells
3.3.2 Selecting columns and rows
3.3.3 Selecting sheets
3.4 Working with columns and rows
3.4.1 Inserting columns and rows
3.4.2 Deleting columns and rows
3.4.3 Freezing columns and rows
3.4.4 Splitting windows
3.5 Working with sheets
3.5.1 Inserting new sheets
3.5.2 Deleting sheets
3.5.3 Renaming sheets
3.6 Entering data
3.6.1 Entering numbers
3.6.2 Entering text
3.6.3 Entering numbers as text
3.6.4 Entering dates and times
3.7 Editing data
3.7.1 Removing text
3.7.2 Removing text and formatting
3.7.3 Editing part of a cell
3.8 Formatting data and cells
3.8.1 Data types
3.8.2 Numbers and other data types
3.8.3 Fonts
3.8.4 Alignment
3.8.5 Borders
3.8.6 Background
3.8.7 Cell and sheet protection
3.8.8 Defining an area
3.9 Styles
3.10 Formula and functions
3.10.1 About formulas
3.10.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
3.10.3 Statistical functions
3.10.4 Time and date functions
3.10.5 Time and date functions
3.10.5 Text functions
3.10.6 Math functions
3.10.7 Logical functions
3.10.8 Information functions
3.10.9 Advanced spreadsheet functions
3.10.10 Standard errors
3.11 Sorting data
3.11.1 Using spreadsheet as database
3.11.2 Ascending or descending order
3.11.3 Advanced sorting options
3.11.4 Defining filters
3.12 Creating charts
3.12.1 Using the AutoFormat Chart dialog
3.12.2 Chart types
3.12.3 Appearance of a chart
3.12.4 Modifying the data area of a chart
3.12.5 Changing line colors
3.12.6 Modifying axes scales
3.13. Linking data
3.13.1 Why use multiple sheets?
3.13.2 Referencing other sheets
3.13.3 Referencing other Calc documents
3.13.4 Referencing to external data sources
3.13.5 Relative, mixed, absolute references
3.14 Printing with Calc
3.14.1 Printing a spreadsheet
3.14.2 Selecting sheets to print
3.14.3 Adjusting the print range
3.14.4 Page breaks
3.14.5 Headers and footers
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Certification/3.0_Calc&oldid=90015"
Personal tools