Line 1: |
Line 1: |
| + | __FORCETOC__ |
| + | =Introduction= |
| #A spreadsheet is a software application used for computations and data processing eg LibreOffice Calc, OpenOffice Calc. It is a very powerful and versatile software which is a 'number editor' like LibreOffice Writer is a 'text editor'. In addition spreadsheet can also do many text related functions also | | #A spreadsheet is a software application used for computations and data processing eg LibreOffice Calc, OpenOffice Calc. It is a very powerful and versatile software which is a 'number editor' like LibreOffice Writer is a 'text editor'. In addition spreadsheet can also do many text related functions also |
| #A spreadsheet is made of rows and columns which are referred to by numbers and alphabets | | #A spreadsheet is made of rows and columns which are referred to by numbers and alphabets |
| #A cell is a combination of a row and a column which is referred to by alphabet+number eg A1, N100. You can visualise a spreadsheet as a table, with rows and columnns. Data can be entered into a spreadsheet in this tabular manner, with each record entered in one row and each element entered in one column for each row/record. Thus student register can be entered in a spreadsheet, with one student record per row and all data elements relating to the student, entered in different columns, such as name, class, mother tongue, sex, religion etc | | #A cell is a combination of a row and a column which is referred to by alphabet+number eg A1, N100. You can visualise a spreadsheet as a table, with rows and columnns. Data can be entered into a spreadsheet in this tabular manner, with each record entered in one row and each element entered in one column for each row/record. Thus student register can be entered in a spreadsheet, with one student record per row and all data elements relating to the student, entered in different columns, such as name, class, mother tongue, sex, religion etc |
− | #Basic features
| + | =Basic features= |
| #Edit features | | #Edit features |
| ##Insert row/column (INSERT- ROW, INSERT -COLUMN) | | ##Insert row/column (INSERT- ROW, INSERT -COLUMN) |
Line 9: |
Line 11: |
| ##Show row/column (FORMAT -ROW/COLUMN -SHOW) | | ##Show row/column (FORMAT -ROW/COLUMN -SHOW) |
| ##Others - multiple sheets (One_cluster, one_block, Mix), workbook, naming book and sheet, | | ##Others - multiple sheets (One_cluster, one_block, Mix), workbook, naming book and sheet, |
− | #Format features
| + | =Format features= |
| ##Basic column width, row height etc | | ##Basic column width, row height etc |
| ##Freeze panes (column headings) WINDOW - FREEZE | | ##Freeze panes (column headings) WINDOW - FREEZE |