Anonymous

Changes

From Karnataka Open Educational Resources
no edit summary
Line 1: Line 1: −
#A spreadsheet is a software application used for computations and data processing eg LibreOffice Calc, OpenOffice Calc  
+
#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
#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
+
#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
 
##Insert row/column (INSERT- ROW, INSERT -COLUMN)
 
##Insert row/column (INSERT- ROW, INSERT -COLUMN)
 
##Delete row/column (EDIT- DELETE CELLS-DELETE ROW/COLUMN)
 
##Delete row/column (EDIT- DELETE CELLS-DELETE ROW/COLUMN)
Line 8: Line 9:  
##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
 
##Basic column width, row height etc
 
##Basic column width, row height etc
 
##Freeze panes (column headings) WINDOW - FREEZE
 
##Freeze panes (column headings) WINDOW - FREEZE
3,690

edits