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 28: Line 28:
 
|
 
|
 
||
 
||
−
|| 3.1 The Calc interface
+
|| 3.1 Styles
−
||
+
−
|-
+
−
|
+
−
||
+
 
||
 
||
−
|| 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
 
 
|-
 
|-
 
|
 
|
Line 70: Line 35:
 
||
 
||
 
||  
 
||  
−
|-
 
 
|
 
|
 
||
 
||
−
||3.2 Navigation within spreadsheets
+
||3.14 Printing with Calc
 
||  
 
||  
 
|-
 
|-
Line 79: Line 43:
 
||
 
||
 
||
 
||
−
|| 3.2.1 Going to a particular cell
+
|| 3.14.1 Printing a spreadsheet
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.2 Moving from cell to cell
+
|| 3.14.2 Selecting sheets to print
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.2.3 Moving from sheet to sheet
+
|| 3.14.3 Adjusting the print range
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
||  
+
|| 3.14.4 Page breaks
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 3.3 Selecting items in a sheet or spreadsheet
 
−
||
 
−
|-
 
−
|
 
 
||
 
||
−
||
+
|| 3.14.5 Headers and footers
−
|| 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.2 Formula and functions
 
||  
 
||  
 
|-
 
|-
Line 129: Line 74:
 
||
 
||
 
||
 
||
−
|| 3.4.1 Inserting columns and rows
+
|| 3.2.1 About formulas
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.4.2 Deleting columns and rows
+
|| 3.2.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.4.3 Freezing columns and rows
+
|| 3.2.3 Statistical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.4.4 Splitting windows
+
|| 3.2.4 Time and date functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
||  
+
|| 3.2.5 Time and date functions
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||3.5 Working with sheets
 
−
||
 
−
|-
 
−
|
 
 
||
 
||
−
||
+
|| 3.2.5 Text functions
−
|| 3.5.1 Inserting new sheets
+
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.5.2 Deleting sheets
+
|| 3.2.6 Math functions
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 3.5.3 Renaming sheets
+
−
|-
+
−
|
+
−
||
+
−
||
+
−
||
+
−
|-
+
−
|
+
−
||
+
−
|| 3.6 Entering data
+
−
||
+
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.6.1 Entering numbers
+
|| 3.2.7 Logical functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.6.2 Entering text
+
|| 3.2.8 Information functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.6.3 Entering numbers as text
+
|| 3.2.9 Advanced spreadsheet functions
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.6.4 Entering dates and times
+
|| 3.2.10 Standard errors
 
|-
 
|-
 
|
 
|
Line 208: Line 133:
 
|
 
|
 
||
 
||
−
||3.7 Editing data
+
||3.3 Sorting data
 
||  
 
||  
 
|-
 
|-
Line 214: Line 139:
 
||
 
||
 
||
 
||
−
|| 3.7.1 Removing text
+
|| 3.3.1 Using spreadsheet as database
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.7.2 Removing text and formatting
+
|| 3.3.2 Ascending or descending order
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.7.3 Editing part of a cell
+
|| 3.3.3 Advanced sorting options
 
|-
 
|-
 
|
 
|
Line 233: Line 158:
 
|
 
|
 
||
 
||
−
||3.8 Formatting data and cells
+
||3.4 Filtering data
 
||  
 
||  
 
|-
 
|-
Line 239: Line 164:
 
||
 
||
 
||
 
||
−
|| 3.8.1 Data types
+
|| 3.4.1 Using autofilter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.8.2 Numbers and other data types
+
|| 3.4.2 Setting up manual filter
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.8.3 Fonts
+
|| 3.4.3 Advanced filters
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.8.4 Alignment
+
|| 3.4.4 Defining filters
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||
+
||3.12 Creating charts
−
|| 3.8.5 Borders
+
||  
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.8.6 Background
+
|| 3.12.1 Using the AutoFormat Chart dialog
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 3.8.7 Cell and sheet protection
+
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 3.8.8 Defining an area
+
 
|-
 
|-
 
|
 
|
Line 283: Line 198:
 
|
 
|
 
||
 
||
−
|| 3.9 Styles
+
|| 3.13 Solver
 
||
 
||
 
|-
 
|-
 
|
 
|
−
||
 
 
||
 
||
 
||  
 
||  
 +
|| 3.13.1 Using Solver
 
|-
 
|-
 
|
 
|
 
||
 
||
−
|| 3.10 Formula and functions
 
 
||  
 
||  
 +
|| 3.13.2 Groups and goals
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.10.1 About formulas
+
|| 3.12.2 Chart types
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.10.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
+
|| 3.12.3 Appearance of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.10.3 Statistical functions
+
|| 3.12.4 Modifying the data area of a chart
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.10.4 Time and date functions
+
|| 3.12.5 Changing line colors
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 3.10.5 Time and date functions
+
|| 3.12.6 Modifying axes scales
−
|-
+
−
|
+
−
||
+
−
||
+
−
|| 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
+
 
|-
 
|-
 
|
 
|
Line 358: Line 243:
 
|
 
|
 
||
 
||
−
||3.11 Sorting data
 
 
||  
 
||  
−
|-
+
|| 3.13.1 Using Solver
−
|
+
−
||
+
−
||
+
−
|| 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
+
 
|-
 
|-
 
|
 
|
Line 388: Line 253:
 
|
 
|
 
||
 
||
−
||3.12 Creating charts
+
|| 3.14 Goal seek
−
||
+
−
|-
+
−
|
+
 
||
 
||
−
||
 
−
|| 3.12.1 Using the AutoFormat Chart dialog
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.15 Escenarios
 
||
 
||
−
|| 3.12.2 Chart types
 
 
|-
 
|-
 
|
 
|
 
||
 
||
 +
|| 3.16 Error Detective
 
||
 
||
−
|| 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
 
−
|-
 
−
|
 
−
||
 
−
||
 
−
||
 
 
|-
 
|-
 
|
 
|
Line 455: Line 295:
 
||
 
||
 
|| 3.13.5 Relative, mixed, absolute references
 
|| 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
 
−
|-
 

Revision as of 01:20, 22 August 2008


2nd Draft

Module Chapter Topic Knowledge
OpenOffice.org - Calc
3. Calc
3.1 Styles
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
3.2 Formula and functions
3.2.1 About formulas
3.2.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
3.2.3 Statistical functions
3.2.4 Time and date functions
3.2.5 Time and date functions
3.2.5 Text functions
3.2.6 Math functions
3.2.7 Logical functions
3.2.8 Information functions
3.2.9 Advanced spreadsheet functions
3.2.10 Standard errors
3.3 Sorting data
3.3.1 Using spreadsheet as database
3.3.2 Ascending or descending order
3.3.3 Advanced sorting options
3.4 Filtering data
3.4.1 Using autofilter
3.4.2 Setting up manual filter
3.4.3 Advanced filters
3.4.4 Defining filters
3.12 Creating charts
3.12.1 Using the AutoFormat Chart dialog
3.13 Solver
3.13.1 Using Solver
3.13.2 Groups and goals
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.1 Using Solver
3.14 Goal seek
3.15 Escenarios
3.16 Error Detective
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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Certification/3.0_Calc&oldid=90464"
Personal tools