Difference between revisions of "LibreOffice-Suite-Calc/C2/Working-with-Cells/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with '{| border=1 || VISUAL CUE || NARRATION |- || 00:00 || Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells. |- || 00:06 || In this tutorial we will learn: …')
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{| border=1
 
{| border=1
|| VISUAL CUE
+
|| '''Time'''
|| NARRATION
+
|| '''Narration'''
  
 
|-
 
|-
 
|| 00:00
 
|| 00:00
|| Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells.
+
|| Welcome to the '''Spoken tutorial''' on '''LibreOffice Calc – Working with Cells'''.
  
 
|-
 
|-
 
|| 00:06
 
|| 00:06
|| In this tutorial we will learn:
+
|| In this tutorial, we will learn:
  
 
|-
 
|-
 
|| 00:08
 
|| 00:08
||How to enter numbers, text, numbers as text, date and time in a spreadsheet.
+
||How to enter numbers, text, numbers as text, date and time in a '''spreadsheet'''.
  
 
|-
 
|-
 
|| 00:16
 
|| 00:16
||How to use the Format Cells dialog box.
+
||How to use the '''Format Cells''' dialog-box.
  
 
|-
 
|-
 
|| 00:19
 
|| 00:19
||How to navigate between cells and in between sheets.
+
||How to navigate between '''cells''' and in between '''sheets'''.
  
 
|-
 
|-
 
|| 00:23
 
|| 00:23
||How to select items in rows, columns and sheets.
+
||How to select items in '''rows, columns''' and '''sheets'''.
  
 
|-
 
|-
 
|| 00:29
 
|| 00:29
|| We will be using Ubuntu 10.04 as our operating system and LibreOffice Suite version 3.3.4.
+
|| We will be using '''Ubuntu 10.04''' as our '''operating system''' and '''LibreOffice Suite''' version '''3.3.4'''.
  
 
|-
 
|-
 
|| 00:39
 
|| 00:39
|| So let us first learn how to enter data in the cells.
+
|| So, let us first learn how to enter '''data''' in the '''cell'''s.
  
 
|-
 
|-
 
|| 00:43
 
|| 00:43
||We shall open our “personal finance tracker.ods” file.
+
||We shall open our "personal finance tracker.ods" file.
  
 
|-
 
|-
 
|| 00:49
 
|| 00:49
|| You can type any text in a particular cell by simply clicking on the cell and then typing the text using the keyboard.
+
|| You can type any text in a particular '''cell''' by simply clicking on the cell and then typing the '''text''', using the keyboard.
  
 
|-
 
|-
 
|| 00:59
 
|| 00:59
||The text is left-aligned by default. One can change the alignment by clicking any one of the alignment tabs on the Formatting Bar.
+
||The text is left-aligned, by default. One can change the alignment by clicking any one of the '''alignment''' tabs on the '''Formatting Bar'''.
  
 
|-
 
|-
 
|| 01:08
 
|| 01:08
||Lets undo this.
+
||Let's '''undo''' this.
  
 
|-
 
|-
 
|| 01:11
 
|| 01:11
|| Now click on the cell corresponding to “A1” in the spreadsheet.
+
|| Now, click on the cell corresponding to 'A1' in the '''spreadsheet'''.
  
 
|-
 
|-
 
|| 01:15
 
|| 01:15
||You see that the selected cell gets highlighted.
+
||You see that the selected '''cell''' gets highlighted.
  
 
|-
 
|-
 
|| 01:20
 
|| 01:20
|| Here we have already typed the column headings.
+
|| Here we have already typed the '''column''' headings.
  
 
|-
 
|-
 
|| 01:24
 
|| 01:24
|| Under the heading, “Items” we shall type the names of a few items one below the other as  “Salary”, “House rent”, “Electricity bill”, “Phone bill”, “Laundry” and “Miscellaneous”.
+
|| Under the heading '''Items''', we shall type the names of a few items one below the other as- ''''Salary', 'House rent', 'Electricity bill', 'Phone bill', 'Laundry'''' and ''''Miscellaneous''''.
  
 
|-
 
|-
 
|| 01:38
 
|| 01:38
|| In order to enter numbers in the cell, click on the cell and type in the numbers.
+
|| In order to enter numbers in the cell, click on the '''cell''' and type in the numbers.
  
 
|-  
 
|-  
Line 81: Line 81:
 
|-
 
|-
 
|| 02:01
 
|| 02:01
||Let us undo the changes.
+
||Let us '''undo''' the changes.
  
 
|-
 
|-
 
|| 02:04
 
|| 02:04
|| Now under the Serial Number heading, denoted as “SN” in our “personal finance tracker.ods” spreadsheet, we want the serial number of each item one below the other.
+
|| Now, under the '''Serial Number''' heading, denoted as "SN" in our "personal finance tracker.ods" spreadsheet, we want the serial number of each item one below the other.
  
 
|-
 
|-
 
|| 02:17
 
|| 02:17
||So click on the cell corresponding to “A2” and enter numbers as 1,2,3 one below the other.
+
||So, click on the cell corresponding to '''A2''' and enter numbers as '''1, 2, 3''', one below the other.
  
 
|-
 
|-
 
|| 02:27
 
|| 02:27
|| In order to auto-fill the serial numbers, click on the cell “A4”.  A little black box is visible at the bottom-right corner of the cell.  Drag it till cell “A7” and release the mouse button.
+
|| In order to '''auto-fill''' the serial numbers, click on the cell '''A4'''.  A little black box is visible at the bottom-right corner of the cell.  Drag it till cell '''A7''' and release the '''mouse button'''.
  
 
|-
 
|-
 
|| 02:42
 
|| 02:42
||You will see that the cells “A5” till “A7” gets populated with the subsequent serial numbers.
+
||You will see that the cells '''A5''' till '''A7''' get populated with the subsequent serial numbers.
  
 
|-
 
|-
 
|| 02:51
 
|| 02:51
|| After entering the serial number of the items, we will now enter the cost of each item under the heading “Cost”.
+
|| After entering the serial number of the items, we will now enter the cost of each item under the heading '''Cost'''.
 
   
 
   
 
|-
 
|-
 
|| 02:59  
 
|| 02:59  
||So we click on the cell referenced as “C3” and type the expense for “House rent” as “Rupees 6000”.
+
||So, we click on the cell referenced as '''C3''' and type the expense for '''House rent''' as '''Rupees 6000'''.
  
 
|-
 
|-
 
|| 03:07
 
|| 03:07
|| Now, what if we want precede the number with the Rupee symbol?
+
|| Now, what if we want to precede the number with the Rupee symbol?
  
 
|-
 
|-
 
|| 03:11
 
|| 03:11
||Lets say, we want to enter “Rupees 800” for “Electricity bill”.  So, right-click on cell C4 and click on “Format Cells” option.  
+
||Lets say, we want to enter '''Rupees 800''' for '''Electricity bill'''.  So, right-click on cell '''C4''' and click on '''Format Cells''' option.  
  
 
|-
 
|-
 
|| 03:23
 
|| 03:23
|| This will open the “Format Cells” dialog box.
+
|| This will open the '''Format Cells''' dialog-box.
  
 
|-
 
|-
 
|| 03:27
 
|| 03:27
||The first tab is “Numbers”. Click on it if not already selected.
+
||The first tab is '''Numbers'''. Click on it, if not already selected.
  
 
|-
 
|-
 
|| 03:32
 
|| 03:32
||Various categories can be seen under “Category” such as Number, Percent, Currency, Date, Time and many more.
+
||Various categories can be seen under '''Category''' such as '''Number, Percent, Currency, Date, Time''' and many more.
  
 
|-
 
|-
 
|| 03:41
 
|| 03:41
|| Lets select Currency.
+
|| Let's select '''Currency'''.
  
 
|-
 
|-
 
|| 03:44
 
|| 03:44
||Now under the Format option, click on the down arrow.  This will display the various currency symbols from across the world.
+
||Now, under the '''Format''' option, click on the down-arrow.  This will display the various currency symbols from across the world.
  
 
|-
 
|-
 
|| 03:53
 
|| 03:53
||Lets scroll up and select INR Rupees English India. By default, Rupee 1234 is selected in the drop-down below.   
+
||Let's scroll up and select '''INR Rupees English India'''. By default, '''Rupee 1234''' is selected in the drop-down below.   
  
 
|-
 
|-
 
|| 04:04
 
|| 04:04
||You can see a preview of it in the small preview area on the right.
+
||You can see a preview of it, in the small '''preview area''' on the right.
  
 
|-
 
|-
 
|| 04:10
 
|| 04:10
|| Under Options, we have the option to add the number of Decimal places and the number of Leading zeroes that we want.
+
|| Under '''Options''', we have the option to add the number of '''Decimal places''' and the number of '''Leading zeroes''' that we want.
  
 
|-
 
|-
 
|| 04:20
 
|| 04:20
||Notice that as we increase the number of zeroes, the selection under Format has changed to Rupees 1,234 decimal zero zero indicating 2 decimal places.  
+
||Notice that as we increase the number of zeroes, the selection under Format has changed to Rupees '''1,234''' decimal zero zero, indicating 2 decimal places.  
  
 
|-
 
|-
 
|| 04:35
 
|| 04:35
|| Notice the change is displayed in the preview area.
+
|| Notice the change is displayed in the '''preview area'''.
  
 
|-
 
|-
 
|| 04:40
 
|| 04:40
|| Click on Thousands separator to add the “comma” separator for each thousand. Once again, notice the change in the preview area.   
+
|| Click on '''Thousands separator''' to add the '''comma''' separator for each thousand. Once again, notice the change in the preview area.   
  
 
|-
 
|-
 
|| 04:50
 
|| 04:50
|| One can also change the font style by clicking on the Font tab.  It has various options for Font, Typeface and Size.
+
|| One can also change the '''font style''' by clicking on the '''Font''' tab.  It has various options for '''Font, Typeface''' and '''Size'''.
  
 
|-
 
|-
 
|| 05:00
 
|| 05:00
|| Explore Font Effects and the other tabs to learn more about them.
+
|| Explore '''Font Effects''' and the other tabs to learn more about them.
  
 
|-
 
|-
 
|| 05:05
 
|| 05:05
||We will learn about the options in the Alignment tab in another tutorial later.
+
||We will learn about the options in the '''Alignment''' tab in another tutorial later.
  
 
|-
 
|-
 
|| 05:11
 
|| 05:11
||Lets click on OK.
+
||Let's click on '''OK'''.
  
 
|-
 
|-
 
||05:15
 
||05:15
|| Lets type 800 and press Enter.  You will notice that the number 800 is represented as Rupees 800 with 2 decimal places.
+
|| Let's type '''800''' and press '''Enter'''.  You will notice that the number 800 is represented as 'Rupees 800' with 2 decimal places.
  
 
|-
 
|-
 
|| 05:26
 
|| 05:26
|| Now, lets select cells C5 to C7.  Hold the CTRL key and select cell G2 also.  Notice all the selected cells are highlighted.
+
|| Now, let's select cells '''C5''' to '''C7'''.  Hold the '''Ctrl''' key and select '''cell G2''' also.  Notice, all the selected cells are highlighted.
  
 
|-
 
|-
 
|| 05:39
 
|| 05:39
||Right-click on any of the highlighted cells and select Format Cells.  
+
||Right-click on any of the highlighted cells and select '''Format Cells'''.  
  
 
|-
 
|-
 
|| 05:46
 
|| 05:46
||Choose the same options as before.Click on OK.
+
||Choose the same options as before. Click on '''OK'''.
  
 
|-
 
|-
 
|| 05:51
 
|| 05:51
|| Now, we type the expense on all the other items one below the other as “Rupees 600” for “Phone bill”, ”Rupees 300” as “Laundry” charges and “Rupees 2000” as other “Miscellaneous” charges.
+
|| Now, we type the expense on all the other items, one below the other, as- '''Rupees 600''' for 'Phone bill', '''Rupees 300''' as 'Laundry' charges and '''Rupees 2000''' as other 'Miscellaneous' charges.
  
 
|-
 
|-
 
|| 06:06
 
|| 06:06
|| Under the heading “Accounts” we type the salary for the month as “Rupees 30000”.
+
|| Under the heading '''Accounts''', we type the salary for the month as '''Rupees 30000'''.
  
 
|-
 
|-
 
|| 06:13
 
|| 06:13
|| For entering date in Calc, select the cell and type the date.
+
|| For entering date in Calc, select the '''cell''' and type the date.
  
 
|-
 
|-
Line 209: Line 209:
 
|-
 
|-
 
|| 06:27
 
|| 06:27
||Calc recognizes a variety of date formats.
+
||'''Calc''' recognizes a variety of date formats.
  
 
|-
 
|-
 
|| 06:32
 
|| 06:32
|| Alternately, one can right-click on the cell and choose “Format Cells” option.   
+
|| Alternately, one can right-click on the cell and choose '''Format Cells''' option.   
  
 
|-
 
|-
 
|| 06:38
 
|| 06:38
||Choose “Date” under category and the desired format under “Format”.  I will choose 12, 31, 1999.  Notice the display in the preview area.
+
||Choose '''Date''' under '''Category''' and the desired format under '''Format'''.  I will choose '''12, 31, 1999'''.  Notice the display in the preview area.
  
 
|-
 
|-
 
|| 06:51
 
|| 06:51
||Also, the Format code is displayed below as MM, DD and YYYY.  One can change the Format code as required.   
+
||Also, the '''Format code''' is displayed below as '''MM, DD''' and '''YYYY'''.  One can change the '''Format code''' as required.   
  
 
|-
 
|-
 
|| 07:02
 
|| 07:02
||I will type DD, MM and YYYY.  Notice the change in the preview area.
+
||I will type '''DD, MM''' and '''YYYY'''.  Notice the change in the preview area. Click on '''OK'''.
Click on OK.
+
  
 
|-
 
|-
Line 238: Line 237:
 
|-
 
|-
 
|| 07:24
 
|| 07:24
|| Alternately, one can right-click on the cell and choose “Format Cells” option.   
+
|| Alternately, one can right-click on the cell and choose '''Format Cells''' option.   
  
 
|-
 
|-
 
|| 07:31
 
|| 07:31
||Choose “Time” under category and the desired format under “Format”.  I will choose 13, 37, 46.  Notice the display in the preview area.
+
||Choose '''Time''' under category and the desired format under '''Format'''.  I will choose '''13, 37, 46'''.  Notice the display in the preview area.
  
 
|-
 
|-
 
|| 07:43
 
|| 07:43
||Also, the Format code is displayed below as HH:MM:SS. One can change the Format code as required.  I will type HH:MM.
+
||Also, the '''Format code''' is displayed below as '''HH:MM:SS'''. One can change the 'Format code' as required.  I will type '''HH:MM'''.
  
 
|-
 
|-
 
|| 07:57
 
|| 07:57
||Notice the change in the preview area.
+
||Notice the change in the preview area.Click on '''OK'''.
Click on OK.
+
  
 
|-
 
|-
 
|| 08:03
 
|| 08:03
||Let us undo the changes.
+
||Let us '''undo''' the changes.
  
 
|-
 
|-
 
|| 08:06
 
|| 08:06
|| After learning how to write text, numbers and dates in Calc, we will now learn how to navigate within a spreadsheet from cell to cell and from sheet to sheet.   
+
|| After learning how to write text, numbers and dates in Calc, we will now learn how to navigate within a spreadsheet from '''cell''' to cell and from sheet to '''sheet'''.   
  
 
|-
 
|-
 
|| 08:17
 
|| 08:17
||So we will first see how we can navigate from cell to cell within a spreadsheet.
+
||So, we will first see how we can navigate from cell to cell within a spreadsheet.
  
 
|-
 
|-
 
|| 08:23
 
|| 08:23
|| You can simply access a particular cell by clicking on it with the cursor.
+
|| You can simply access a particular '''cell''' by clicking on it with the cursor.
  
 
|-
 
|-
Line 275: Line 273:
 
|-
 
|-
 
|| 08:32
 
|| 08:32
|| Another method of accessing a particular cell is by using a cell reference.
+
|| Another method of accessing a particular cell is by using a '''cell reference'''.
  
 
|-
 
|-
 
|| 08:38
 
|| 08:38
||Click on the little black down arrow just to the right of the “Name Box”.
+
||Click on the little black down arrow just to the right of the '''Name Box'''.
  
 
|-
 
|-
 
|| 08:43
 
|| 08:43
||Now type the cell reference of the cell you want to go to and press “Enter” .
+
||Now, type the cell reference of the cell you want to go to and press '''Enter''' .
  
 
|-
 
|-
 
|| 08:49
 
|| 08:49
||You can even click into the “Name box”, delete the existing cell reference and type in the cell reference you want and press “Enter”.
+
||You can even click into the '''Name box''', delete the existing '''cell reference''' and type in the cell reference you want and press '''Enter'''.
  
 
|-
 
|-
Line 299: Line 297:
 
|-
 
|-
 
||09:09
 
||09:09
|| To move the focus using the cursor, simply move the cursor to the cell where you want|the focus to be and click the left mouse button.
+
|| To move the focus using the cursor, simply move the cursor to the cell where you want the focus to be and click the left '''mouse''' button.
  
 
|-
 
|-
 
|| 09:18
 
|| 09:18
||This changes the focus to the new cell.
+
||This changes the focus to the new '''cell'''.
 
   
 
   
 
|-
 
|-
Line 311: Line 309:
 
|-
 
|-
 
|| 09:28
 
|| 09:28
|| Another method of navigation between cells are - * “Tab” to go to the next cell in a row,
+
|| Another method of navigation between cells is- * '''Tab''' to go to the next cell in a row,
  
 
|-
 
|-
 
|| 09:35
 
|| 09:35
||”Shift + Tab” to go to the previous cell in a row,
+
||'''Shift + Tab''' to go to the previous cell in a row,
  
 
|-
 
|-
 
|| 09:39
 
|| 09:39
||“Enter” to go to the next cell in a column,
+
||'''Enter''' to go to the next cell in a column,
  
 
|-
 
|-
 
|| 09:42
 
|| 09:42
||“Shift + Enter” to go to the previous cell in a  column.
+
||'''Shift + Enter''' to go to the previous cell in a  column.
  
 
|-
 
|-
 
|| 09:46
 
|| 09:46
|| Next we will learn how to navigate between different spreadsheets in Calc using the keyboard.
+
|| Next, we will learn how to navigate between different spreadsheets in Calc using the keyboard.
  
 
|-
 
|-
 
|| 09:53
 
|| 09:53
|| For accessing the sheet to the right of the active sheet, press the “Control” plus “Page Down” keys simultaneously.
+
|| For accessing the sheet to the right of the active sheet, press the '''Control''' plus '''Page Down''' keys simultaneously.
  
 
|-
 
|-
 
|| 10:00
 
|| 10:00
||In order to access the sheet to the left of the current sheet,  press the “Control” plus “Page Up” keys simultaneously.
+
||In order to access the sheet to the left of the current sheet,  press the '''Control''' plus '''Page Up''' keys simultaneously.
  
 
|-
 
|-
Line 343: Line 341:
 
|-
 
|-
 
|| 10:13
 
|| 10:13
||Detailed information on this is available in the tutorial “Working with Sheets”.
+
||Detailed information on this is available in the tutorial ''''Working with Sheets''''.
  
 
|-
 
|-
 
|| 10:19
 
|| 10:19
|| If you have a number of sheets, then some of the sheet tabs may be hidden behind the horizontal
+
|| If you have a number of sheets then some of the sheet tabs may be hidden behind the horizontal scroll-bar at the bottom of the screen.
scroll bar at the bottom of the screen.
+
  
 
|-
 
|-
 
|| 10:28
 
|| 10:28
||If this is the case, then the four buttons at the bottom-left of the sheet tabs can move the tabs into view.
+
||If this is the case then the four buttons at the bottom-left of the sheet tabs can move the tabs into view.
  
 
|-
 
|-
 
|| 10:36
 
|| 10:36
||Let us undo the changes.
+
||Let us '''undo''' the changes.
  
 
|-
 
|-
 
||10:39
 
||10:39
|| For selecting a range of contiguous cells with the cursor, first click in a cell.
+
|| For selecting a range of contiguous cells with the cursor, first click in a '''cell'''.
  
 
|-
 
|-
 
|| 10:45
 
|| 10:45
||Now press and hold down the left mouse button.
+
||Now press and hold down the left '''mouse''' button.
  
 
|-
 
|-
 
|| 10:48
 
|| 10:48
||Move the cursor around the screen and once the desired block of cells is highlighted, release the left mouse button.
+
||Move the cursor around the screen and once the desired block of cells is highlighted, release the left '''mouse button'''. You see that the selected cells are highlighted.
You see that the selected cells are highlighted.
+
  
 
|-
 
|-
 
|| 11:00
 
|| 11:00
|| In order to select multiple columns or rows that are contiguous click on the first column or row in the group.
+
|| In order to select multiple columns or rows that are contiguous, click on the first column or row in the group.
  
 
|-
 
|-
 
|| 11:09
 
|| 11:09
||Now hold down the “Shift” key.
+
||Now, hold down the '''Shift''' key.
  
 
|-
 
|-
Line 385: Line 381:
 
|-
 
|-
 
|| 11:15
 
|| 11:15
||To select multiple columns or rows that are not contiguous click on the first column or row in the group.
+
||To select multiple columns or rows that are not contiguous, click on the first column or row in the group.
  
 
|-
 
|-
 
|| 11:23
 
|| 11:23
||Hold down the “Control” key and click on all of the subsequent columns or rows while holding down the “Control” key.
+
||Hold down the '''Control''' key and click on all of the subsequent columns or rows while holding down the '''Control''' key.
  
 
|-
 
|-
 
|| 11:31
 
|| 11:31
|| For selecting multiple contiguous sheets, click on the sheet tab for the first desired sheet.
+
|| For selecting multiple contiguous sheets, click on the '''sheet''' tab for the first desired sheet.
  
 
|-
 
|-
 
|| 11:39
 
|| 11:39
||Now move the cursor over the sheet tab for the last desired sheet.
+
||Now, move the cursor over the sheet tab for the last desired sheet.
  
 
|-
 
|-
 
|| 11:43
 
|| 11:43
||Hold down the “Shift” key and click on the sheet tab.
+
||Hold down the '''Shift''' key and click on the sheet tab.
  
 
|-
 
|-
 
|| 11:48
 
|| 11:48
||All the tabs between these two sheets will turn white, which indicates that they are all selected.
+
||All the tabs between these two sheets will turn white which indicates that they are all selected.
  
 
|-
 
|-
 
|| 11:56
 
|| 11:56
||Any actions that you perform will now affect
+
||Any actions that you perform will now affect all highlighted sheets.
all highlighted sheets.
+
  
 
|-
 
|-
 
|| 12:01
 
|| 12:01
|| For selecting multiple non- contiguous sheets, Click on the sheet tab for the first sheet.
+
|| For selecting multiple non- contiguous sheets, click on the sheet tab for the first sheet.
  
 
|-
 
|-
 
|| 12:08
 
|| 12:08
||Now move the cursor over the third sheet tab.
+
||Now, move the cursor over the third sheet tab.
  
 
|-
 
|-
 
|| 12:12
 
|| 12:12
||Hold down the “Control” key and click on the sheet tab.
+
||Hold down the '''Control''' key and click on the '''sheet''' tab.
  
 
|-
 
|-
 
|| 12:16
 
|| 12:16
||The selected tabs will turn white and any actions that you perform will now affect all highlighted sheets.
+
||The selected tabs will turn white and any actions that you perform, will now affect all highlighted sheets.
  
 
|-  
 
|-  
 
|| 12:24
 
|| 12:24
|| This brings us to the end of the Spoken Tutorial on LibreOffice Calc.
+
|| This brings us to the end of the '''Spoken Tutorial''' on '''LibreOffice Calc'''.
  
 
|-
 
|-
Line 438: Line 433:
 
|-
 
|-
 
|| 12:33
 
|| 12:33
||How to enter numbers, text , numbers as text, date and time in Calc.
+
||How to enter numbers, text , numbers as text, date and time in Calc.
  
 
|-
 
|-
 
|| 12:40
 
|| 12:40
||How to use the Format Cells dialog box.
+
||How to use the '''Format Cells''' dialog-box.
  
 
|-
 
|-
Line 450: Line 445:
 
|-
 
|-
 
|| 12:47
 
|| 12:47
||How to select items in rows, columns and sheets.
+
||How to select items in rows, columns and '''sheets'''.
  
 
|-
 
|-
 
|| 12:52
 
|| 12:52
|| COMPREHENSIVE ASSIGNMENT
+
|| COMPREHENSIVE ASSIGNMENT-
  
 
|-
 
|-
 
|| 12:55
 
|| 12:55
||Open “Spreadsheet Practice.ods”
+
||Open "Spreadsheet Practice.ods".
  
 
|-
 
|-
 
|| 12:58
 
|| 12:58
||Under “Serial Numbers” type the serial number from 1 to 5 one below the other.
+
||Under '''Serial Numbers''', type the serial number from 1 to 5, one below the other.
  
 
|-
 
|-
Line 470: Line 465:
 
|-
 
|-
 
|| 13:09
 
|| 13:09
||Select all the items under serial number.
+
||Select all the items under '''Serial Number'''.
  
 
|-
 
|-
 
|| 13:13
 
|| 13:13
||Add a column for Date and Time.
+
||Add a column for '''Date''' and '''Time'''.
  
 
|-
 
|-
 
|| 13:16
 
|| 13:16
||Enter some values in them using the Format Cells dialog box options.
+
||Enter some values in them using the '''Format Cells''' dialog-box options.
  
 
|-
 
|-
 
|| 13:21
 
|| 13:21
||*Watch the video available at the following link
+
||Watch the video available at the following link.
  
 
|-
 
|-
 
|| 13:24
 
|| 13:24
||*It summarises the Spoken Tutorial project
+
||It summarizes the Spoken Tutorial project.
  
 
|-
 
|-
 
|| 13:27
 
|| 13:27
||*If you do not have good bandwidth, you can download and watch it
+
||If you do not have good bandwidth, you can download and watch it.
  
 
|-
 
|-
 
|| 13:32
 
|| 13:32
||The Spoken Tutorial Project Team
+
||The Spoken Tutorial project team:
  
 
|-
 
|-
 
|| 13:35
 
|| 13:35
||*Conducts workshops using spoken tutorials
+
||Conducts workshops using spoken tutorials.
  
 
|-
 
|-
 
|| 13:38
 
|| 13:38
||*Gives certificates for those who pass an online test
+
||Gives certificates for those who pass an online test.
  
 
|-
 
|-
 
|| 13:41
 
|| 13:41
||*For more details, please write to contact at spoken hyphen tutorial dot org
+
||For more details, please write to:'''contact at spoken hyphen tutorial dot org'''.
  
 
|-
 
|-
 
|| 13:48
 
|| 13:48
||*Spoken Tutorial Project is a part of the Talk to a Teacher project
+
||'''Spoken Tutorial''' project is a part of the '''Talk to a Teacher''' project.
  
 
|-
 
|-
 
|| 13:52
 
|| 13:52
||*It is supported by the National Mission on Education through ICT, MHRD, Government of India
+
||It is supported by the National Mission on Education through ICT, MHRD, Government of India.
  
 
|-
 
|-
 
|| 14:00
 
|| 14:00
||*More information on this Mission is available at
+
||More information on this mission is available at:
  
 
|-
 
|-
 
|| 14:03
 
|| 14:03
||*spoken hyphen tutorial dot org slash NMEICT hyphen Intro
+
||'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.
  
 
|-
 
|-
 
|| 14:11
 
|| 14:11
||*This tutorial has been contributed by ...............................(Name of the translator and narrator)
+
||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.  
 
+
And this is -----------------------(name of the recorder) from --------------------------(name of the place)signing off. Thanks for watching. 
+
  
 
|-
 
|-
 
|| 14:16
 
|| 14:16
||*Thanks for joining
+
||Thanks for joining.
  
 
|-
 
|-
  
 
|}
 
|}

Latest revision as of 17:55, 26 October 2016

Time Narration
00:00 Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells.
00:06 In this tutorial, we will learn:
00:08 How to enter numbers, text, numbers as text, date and time in a spreadsheet.
00:16 How to use the Format Cells dialog-box.
00:19 How to navigate between cells and in between sheets.
00:23 How to select items in rows, columns and sheets.
00:29 We will be using Ubuntu 10.04 as our operating system and LibreOffice Suite version 3.3.4.
00:39 So, let us first learn how to enter data in the cells.
00:43 We shall open our "personal finance tracker.ods" file.
00:49 You can type any text in a particular cell by simply clicking on the cell and then typing the text, using the keyboard.
00:59 The text is left-aligned, by default. One can change the alignment by clicking any one of the alignment tabs on the Formatting Bar.
01:08 Let's undo this.
01:11 Now, click on the cell corresponding to 'A1' in the spreadsheet.
01:15 You see that the selected cell gets highlighted.
01:20 Here we have already typed the column headings.
01:24 Under the heading Items, we shall type the names of a few items one below the other as- 'Salary', 'House rent', 'Electricity bill', 'Phone bill', 'Laundry' and 'Miscellaneous'.
01:38 In order to enter numbers in the cell, click on the cell and type in the numbers.
01:43 To enter a negative number, either type a minus sign in front of it or enclose it in parentheses.
01:53 By default, numbers are right-aligned and negative numbers have a leading minus symbol.
02:01 Let us undo the changes.
02:04 Now, under the Serial Number heading, denoted as "SN" in our "personal finance tracker.ods" spreadsheet, we want the serial number of each item one below the other.
02:17 So, click on the cell corresponding to A2 and enter numbers as 1, 2, 3, one below the other.
02:27 In order to auto-fill the serial numbers, click on the cell A4. A little black box is visible at the bottom-right corner of the cell. Drag it till cell A7 and release the mouse button.
02:42 You will see that the cells A5 till A7 get populated with the subsequent serial numbers.
02:51 After entering the serial number of the items, we will now enter the cost of each item under the heading Cost.
02:59 So, we click on the cell referenced as C3 and type the expense for House rent as Rupees 6000.
03:07 Now, what if we want to precede the number with the Rupee symbol?
03:11 Lets say, we want to enter Rupees 800 for Electricity bill. So, right-click on cell C4 and click on Format Cells option.
03:23 This will open the Format Cells dialog-box.
03:27 The first tab is Numbers. Click on it, if not already selected.
03:32 Various categories can be seen under Category such as Number, Percent, Currency, Date, Time and many more.
03:41 Let's select Currency.
03:44 Now, under the Format option, click on the down-arrow. This will display the various currency symbols from across the world.
03:53 Let's scroll up and select INR Rupees English India. By default, Rupee 1234 is selected in the drop-down below.
04:04 You can see a preview of it, in the small preview area on the right.
04:10 Under Options, we have the option to add the number of Decimal places and the number of Leading zeroes that we want.
04:20 Notice that as we increase the number of zeroes, the selection under Format has changed to Rupees 1,234 decimal zero zero, indicating 2 decimal places.
04:35 Notice the change is displayed in the preview area.
04:40 Click on Thousands separator to add the comma separator for each thousand. Once again, notice the change in the preview area.
04:50 One can also change the font style by clicking on the Font tab. It has various options for Font, Typeface and Size.
05:00 Explore Font Effects and the other tabs to learn more about them.
05:05 We will learn about the options in the Alignment tab in another tutorial later.
05:11 Let's click on OK.
05:15 Let's type 800 and press Enter. You will notice that the number 800 is represented as 'Rupees 800' with 2 decimal places.
05:26 Now, let's select cells C5 to C7. Hold the Ctrl key and select cell G2 also. Notice, all the selected cells are highlighted.
05:39 Right-click on any of the highlighted cells and select Format Cells.
05:46 Choose the same options as before. Click on OK.
05:51 Now, we type the expense on all the other items, one below the other, as- Rupees 600 for 'Phone bill', Rupees 300 as 'Laundry' charges and Rupees 2000 as other 'Miscellaneous' charges.
06:06 Under the heading Accounts, we type the salary for the month as Rupees 30000.
06:13 For entering date in Calc, select the cell and type the date.
06:18 You can separate the date elements with a forward slash or a hyphen or use text such as 10 October 2011.
06:27 Calc recognizes a variety of date formats.
06:32 Alternately, one can right-click on the cell and choose Format Cells option.
06:38 Choose Date under Category and the desired format under Format. I will choose 12, 31, 1999. Notice the display in the preview area.
06:51 Also, the Format code is displayed below as MM, DD and YYYY. One can change the Format code as required.
07:02 I will type DD, MM and YYYY. Notice the change in the preview area. Click on OK.
07:12 For entering time in Calc, select the cell and type the time.
07:18 You can separate time elements with colons such as 10 colon 43 colon 20.
07:24 Alternately, one can right-click on the cell and choose Format Cells option.
07:31 Choose Time under category and the desired format under Format. I will choose 13, 37, 46. Notice the display in the preview area.
07:43 Also, the Format code is displayed below as HH:MM:SS. One can change the 'Format code' as required. I will type HH:MM.
07:57 Notice the change in the preview area.Click on OK.
08:03 Let us undo the changes.
08:06 After learning how to write text, numbers and dates in Calc, we will now learn how to navigate within a spreadsheet from cell to cell and from sheet to sheet.
08:17 So, we will first see how we can navigate from cell to cell within a spreadsheet.
08:23 You can simply access a particular cell by clicking on it with the cursor.
08:29 You see that the particular cell gets highlighted.
08:32 Another method of accessing a particular cell is by using a cell reference.
08:38 Click on the little black down arrow just to the right of the Name Box.
08:43 Now, type the cell reference of the cell you want to go to and press Enter .
08:49 You can even click into the Name box, delete the existing cell reference and type in the cell reference you want and press Enter.
08:58 Next we will learn about how to navigate between cells in a spreadsheet.
09:03 The first method of navigation between cells is by using the cursor.
09:09 To move the focus using the cursor, simply move the cursor to the cell where you want the focus to be and click the left mouse button.
09:18 This changes the focus to the new cell.
09:22 This method is most useful when the two cells are a large distance apart.
09:28 Another method of navigation between cells is- * Tab to go to the next cell in a row,
09:35 Shift + Tab to go to the previous cell in a row,
09:39 Enter to go to the next cell in a column,
09:42 Shift + Enter to go to the previous cell in a column.
09:46 Next, we will learn how to navigate between different spreadsheets in Calc using the keyboard.
09:53 For accessing the sheet to the right of the active sheet, press the Control plus Page Down keys simultaneously.
10:00 In order to access the sheet to the left of the current sheet, press the Control plus Page Up keys simultaneously.
10:08 You can also navigate between sheets using the cursor.
10:13 Detailed information on this is available in the tutorial 'Working with Sheets'.
10:19 If you have a number of sheets then some of the sheet tabs may be hidden behind the horizontal scroll-bar at the bottom of the screen.
10:28 If this is the case then the four buttons at the bottom-left of the sheet tabs can move the tabs into view.
10:36 Let us undo the changes.
10:39 For selecting a range of contiguous cells with the cursor, first click in a cell.
10:45 Now press and hold down the left mouse button.
10:48 Move the cursor around the screen and once the desired block of cells is highlighted, release the left mouse button. You see that the selected cells are highlighted.
11:00 In order to select multiple columns or rows that are contiguous, click on the first column or row in the group.
11:09 Now, hold down the Shift key.
11:12 Click the last column or row in the group.
11:15 To select multiple columns or rows that are not contiguous, click on the first column or row in the group.
11:23 Hold down the Control key and click on all of the subsequent columns or rows while holding down the Control key.
11:31 For selecting multiple contiguous sheets, click on the sheet tab for the first desired sheet.
11:39 Now, move the cursor over the sheet tab for the last desired sheet.
11:43 Hold down the Shift key and click on the sheet tab.
11:48 All the tabs between these two sheets will turn white which indicates that they are all selected.
11:56 Any actions that you perform will now affect all highlighted sheets.
12:01 For selecting multiple non- contiguous sheets, click on the sheet tab for the first sheet.
12:08 Now, move the cursor over the third sheet tab.
12:12 Hold down the Control key and click on the sheet tab.
12:16 The selected tabs will turn white and any actions that you perform, will now affect all highlighted sheets.
12:24 This brings us to the end of the Spoken Tutorial on LibreOffice Calc.
12:30 To summarize, we learned about:
12:33 How to enter numbers, text , numbers as text, date and time in Calc.
12:40 How to use the Format Cells dialog-box.
12:43 How to navigate between cells and between sheets.
12:47 How to select items in rows, columns and sheets.
12:52 COMPREHENSIVE ASSIGNMENT-
12:55 Open "Spreadsheet Practice.ods".
12:58 Under Serial Numbers, type the serial number from 1 to 5, one below the other.
13:04 Navigate between the cells using keys.
13:09 Select all the items under Serial Number.
13:13 Add a column for Date and Time.
13:16 Enter some values in them using the Format Cells dialog-box options.
13:21 Watch the video available at the following link.
13:24 It summarizes the Spoken Tutorial project.
13:27 If you do not have good bandwidth, you can download and watch it.
13:32 The Spoken Tutorial project team:
13:35 Conducts workshops using spoken tutorials.
13:38 Gives certificates for those who pass an online test.
13:41 For more details, please write to:contact at spoken hyphen tutorial dot org.
13:48 Spoken Tutorial project is a part of the Talk to a Teacher project.
13:52 It is supported by the National Mission on Education through ICT, MHRD, Government of India.
14:00 More information on this mission is available at:
14:03 spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
14:11 This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.
14:16 Thanks for joining.

Contributors and Content Editors

Minal, Pratik kamble, Sandhya.np14