Certification/3.0 Calc

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