Changes

##If column headings are not seen, use TAB <Options> and tick <Range contains column labels>

##If column headings are not seen, use TAB <Options> and tick <Range contains column labels>

##Use Edit- select All (or control A) to select sheet before DATA-SORT

##Use Edit- select All (or control A) to select sheet before DATA-SORT

##e.g. sort DISE data by DISTRICTNAME-BLOCKNAME-CLUSTERCD or RURAL-GIRLSTOILET

##e.g. sort DISE data by DISTRICTNAME-BLOCKNAME-CLUSTERCD or RURAL-GIRLSTOILET or sort School Admission Register data by Sex, Mother tongue

#FILTER  

#FILTER  

##Used to filter some rows based on selection  

##Used to filter some rows based on selection  

##Do DATA-FILTER-AUTO FILTER to create a filter (you can see Arrow sign on each column)

##Do DATA-FILTER-AUTO FILTER to create a filter (you can see Arrow sign on each column)

##Click on the arrow on any column to select filter

##Click on the arrow on any column to select filter

#FORMULA

#FORMULA

##Addition, (total boys, total girls in HPS  =AE2+AG2+AI2+AK2)

##Addition, (total boys, total girls in HPS  =AE2+AG2+AI2+AK2)

##Use formula for other cases – subtraction, multiplication, division, percentages

##Use formula for other cases – subtraction, multiplication, division, percentages

##Use formula to connect across work sheets and across work books

##Use formula to connect across work sheets and across work books

##If then conditional formula (calculate student grades from marks, [http://43.254.42.216/KOER/en/images/e/e9/Using_spreadsheet_to_compute_grades.ods download student grade computation.ods]

##If then conditional formula (calculate student grades from marks, [http://43.254.42.216/KOER/en/images/e/e9/Using_spreadsheet_to_compute_grades.ods download student grade computation.ods]. Use CCE Register to calculate student grades from marks)

##Can use statistical functions – average, product, Frequency, Countif etc

##Can use statistical functions – average, product, Frequency, Countif etc

#Other features

#Other features