||* Introduction to basics of Formula

||* Sorting by Columns

||* Basics of Filtering Data.

|| Here we are using '''Ubuntu Linux''' version '''10.04''' as our operating system and  '''LibreOffice Suite''' version '''3.3.4'''.

||Formulas are equations that use numbers and variables to get a result.

||01:02

|| We shall give one more heading as “SUM TOTAL” just under “Miscellaneous”.

||And we shall click on the '''cell A8''' and give the serial number as “7”.

|| Now let's click on cell number “C8” where we want to display the total of the costs.

|| In order to add all the costs, we’ll type “is equal to SUM” and within braces the range of columns to be added, that is, ”C3 colon C7”.

|| 01:44

||Now press '''Enter''' on the keyboard.

||You see that all the items under '''“Cost”''' get added.

|| Now let's learn how to subtract in '''Calc'''.

|| If we want to subtract the cost of “House Rent” and “ Electricity Bill”, and display it in the cell referenced as A9, simply click on the A9 cell first.

|| Now in this cell, type “is equal to” and within braces the respective cell references, that is, “C3 minus C4”.

||Press the “Enter” key on the keyboard.

|| We see that the cost in the two cell references get subtracted and the result is displayed in cell number A9.

||Lets undo the changes.

|| Another basic operation in a spreadsheet is finding the “Average” of numbers.

|| Lets give the heading as “Average” just below the “SUM TOTAL” cell.

||Here we want to display the average of the total cost.   

|| So lets click on the “C9” cell.

||Now we type “is equal to” Average and Cost within braces.

|| Press the “Enter” key on the keyboard.

||You see that the average of the “Cost” column gets displayed in the cell.

||Lets undo the changes.

||Let us now learn how to “Sort” data in a Calc spreadsheet.  

||In Calc, you can sort the data using upto three criteria, which are then applied one after another.

|| Lets say, we want to sort the data under the heading “Costs” in the ascending order.   

||So first, we highlight the cells to be sorted by clicking on the cell “Cost”.

|| Now holding down the left mouse button, drag it along the column till the end of the cell which says “2000”.

|| Now click on the “Data” option in the menu bar and then click on “Sort”.

||Next Select “Current Selection”

|| You see that a dialog box appears with tabs as “Sort criteria” and “Options”.

|| In the “Sort criteria” tab, select “Cost” in the “Sort by” field.

||In order to sort the “Cost” in ascending order, click on the “Ascending” option just next to it.

|| Now click on the “OK” button.

|| Similarly, to sort in the descending order, click on “Descending” and then click on the “OK” button.

||Let us Undo the changes

|| Multiple columns can be sorted by first selecting all the columns and then applying the sort options.

|| Lets say, we want to sort the serial numbers as well as the cost.   

||So first select these columns as we did earlier.

|| Now click on the “Data” option in the menu bar and then click on “Sort”.

|| In the dialog box which appears, first select “Cost” in the “Sort by” field.

||Then select “SN” in the “Then by” field.

|| Click on “ Descending” in both the options near them and then click on the “OK” button.

||Lets Undo the changes

|| Now lets learn how to filter data in LibreOffice Calc.

||A filter is a list of conditions that each entry has to meet in order to be displayed.

|| In order to apply a filter in the spreadsheet, lets click on the cell named “Item”.

||Now click on the “Data” option in the menu bar and then click on “Filter”.

|| Click on the “AutoFilter” option in the pop up menu.

||Click on the down arrow on the cell named “Item”.

|| Now suppose if you want to display only the data related to “Electricity Bill”.

||So click on the “Electricity Bill” option.

|| In order to view all the data, again click on the downward arrow on the cell named ”Item” and click on “All”.

|| Apart from “AutoFilter”, there are two more filter options namely “Standard Filter” and “Advanced Filter” which we will learn about in the later stages of this series.

|| This brings us to the end of the Spoken Tutorial on LibreOffice Calc:

||Introduction to basics of Formula

||Sorting by Columns

||Basics of Filtering Data

||*Watch the video available at the following link

||*It summarises the Spoken Tutorial project

||*If you do not have good bandwidth, you can download and watch it

||The Spoken Tutorial Project Team

||*Conducts workshops using spoken tutorials

||*Gives certificates for those who pass an online test

||*For more details, please write to contact@spoken-tutorial.org

||*Spoken Tutorial Project is a part of the Talk to a Teacher project

||*It is supported by the National Mission on Education through ICT, MHRD, Government of India

||*More information on this Mission is available at

||*http:spoken-tutorial.org slash NMEICT hyphen Intro

||This tutorial has been contributed by ...............................(Name of the translator and narrator)

 

And this is -----------------------(name of the recorder) from --------------------------(name of the place)signing off. Thanks for watching.