Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Working-with-Cells/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
Line 4: Line 4:
  
 
|-
 
|-
|| 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 '''cell'''s and in between '''sheet'''s.
+
||How to navigate between '''cell'''s and in between '''sheet'''s.
  
 
|-
 
|-
|| 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 '''GNU/Linux''' as our '''operating system''' and '''LibreOffice Suite''' version '''3.3.4'''.
+
||We will be using '''GNU/Linux''' 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 '''cell'''s.
+
||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:10
+
||01:10
 
||Let's '''undo''' this.
 
||Let's '''undo''' this.
  
 
|-
 
|-
|| 01:12
+
||01:12
|| Now click on the '''cell''' corresponding to “A1” in the '''spreadsheet'''.
+
||Now click on the '''cell''' corresponding to “A1” in the '''spreadsheet'''.
  
 
|-
 
|-
|| 01:16
+
||01:16
 
||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.
  
 
|-  
 
|-  
|| 01:43
+
||01:43
 
||To enter a negative number, either type a minus sign in front of it or enclose it in parentheses.
 
||To enter a negative number, either type a minus sign in front of it or enclose it in parentheses.
 
   
 
   
 
|-
 
|-
|| 01:53
+
||01:53
 
||By default, numbers are right-aligned and negative numbers have a leading minus symbol.
 
||By default, numbers are right-aligned and negative numbers have a leading minus symbol.
  
 
|-
 
|-
|| 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:18
+
||02:18
 
||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:28
+
||02:28
|| 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:44
+
||02:44
 
||You will see that the cells “A5” till “A7” get 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:08
+
||03:08
|| Now, what if we want to precede the number with the Rupee symbol?
+
||Now, what if we want to precede the number with the Rupee symbol?
  
 
|-
 
|-
|| 03:12
+
||03:12
 
||Let's say, we want to enter “Rupees 800” for “Electricity bill”.  So, right-click on the cell 'C4' and click on '''“Format Cells”''' option.  
 
||Let's say, we want to enter “Rupees 800” for “Electricity bill”.  So, right-click on the cell 'C4' and click on '''“Format Cells”''' option.  
  
 
|-
 
|-
|| 03:24
+
||03:24
|| This will open the “Format Cells” dialog-box.
+
||This will open the “Format Cells” dialog-box.
  
 
|-
 
|-
|| 03:28
+
||03:28
 
||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:42
+
||03:42
|| Let's select '''Currency'''.
+
||Let's select '''Currency'''.
  
 
|-
 
|-
|| 03:45
+
||03:45
 
||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:54
+
||03:54
 
||Let's scroll up and select '''INR Rupees English India'''.  By default, '''Rupees 1234''' is selected in the drop-down below.   
 
||Let's scroll up and select '''INR Rupees English India'''.  By default, '''Rupees 1234''' is selected in the drop-down below.   
  
 
|-
 
|-
|| 04:05
+
||04:05
 
||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:11
+
||04:11
|| 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:06
+
||05:06
 
||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
 
||Let's click on '''OK'''.
 
||Let's click on '''OK'''.
  
 
|-
 
|-
 
||05:16
 
||05:16
|| Let's 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:27
+
||05:27
|| Now, let's 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:40
+
||05:40
 
||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 expenses 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 expenses 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.
  
 
|-
 
|-
|| 06:18
+
||06:18
 
||You can separate the date elements with a forward slash or a hyphen or use text such as 10 October 2011.
 
||You can separate the date elements with a forward slash or a hyphen or use text such as 10 October 2011.
  
 
|-
 
|-
|| 06:28
+
||06:28
 
||'''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:52
+
||06:52
 
||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. Click on '''OK'''.
 
||I will type '''DD, MM''' and '''YYYY'''.  Notice the change in the preview area. Click on '''OK'''.
  
 
|-
 
|-
 
||07:12
 
||07:12
|| For entering time in Calc, select the '''cell''' and type the time.
+
||For entering time in Calc, select the '''cell''' and type the time.
  
 
|-
 
|-
|| 07:18
+
||07:18
 
||You can separate time elements with colon such as 10 colon 43 colon 20.
 
||You can separate time elements with colon such as 10 colon 43 colon 20.
  
 
|-
 
|-
|| 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:44
+
||07:44
 
||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. Click on '''OK'''.
 
||Notice the change in the preview area. 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.
  
 
|-
 
|-
|| 08:29
+
||08:29
 
||You see that the particular cell gets highlighted.
 
||You see that the particular cell gets highlighted.
  
 
|-
 
|-
|| 08:33
+
||08:33
|| 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:44
+
||08:44
 
||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”.
  
 
|-
 
|-
|| 08:58
+
||08:58
|| Next we will learn how to navigate between cells in a spreadsheet.
+
||Next we will learn how to navigate between cells in a spreadsheet.
  
 
|-
 
|-
|| 09:03
+
||09:03
 
||The first method of navigation between cells is by using the cursor.
 
||The first method of navigation between cells is by using the cursor.
  
 
|-
 
|-
 
||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:19
+
||09:19
 
||This changes the focus to the new cell.
 
||This changes the focus to the new cell.
 
   
 
   
 
|-
 
|-
|| 09:22
+
||09:22
 
||This method is most useful when the two cells are a large distance apart.
 
||This method is most useful when the two cells are a large distance apart.
  
 
|-
 
|-
|| 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 are - * '''"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:01
+
||10:01
 
||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.
  
 
|-
 
|-
|| 10:08
+
||10:08
|| You can also navigate between sheets using the cursor.   
+
||You can also navigate between sheets using the cursor.   
  
 
|-
 
|-
|| 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 scroll-bar at the bottom of the screen.
+
||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
+
||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:49
+
||10:49
 
||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.
 
||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:01
+
||11:01
|| 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.
  
 
|-
 
|-
|| 11:12
+
||11:12
 
||Click the last column or row in the group.
 
||Click the last column or row in the group.
  
 
|-
 
|-
|| 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:33
+
||11:33
|| 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:44
+
||11:44
 
||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 all highlighted sheets.
 
||Any actions that you perform will now affect all highlighted sheets.
  
 
|-
 
|-
|| 12:02
+
||12:02
|| 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:25
+
||12:25
|| 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.
  
 
|-
 
|-
|| 12:31
+
||12:31
 
||To summarize, we learned about:
 
||To summarize, we learned about:
  
 
|-
 
|-
|| 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.
  
 
|-
 
|-
|| 12:43
+
||12:43
||* How to navigate between cells and between sheets.
+
||How to navigate between cells and between sheets.
  
 
|-
 
|-
|| 12:48
+
||12:48
||* 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.
  
 
|-
 
|-
|| 13:06
+
||13:06
 
||Navigate between the cells using keys.
 
||Navigate between the cells using keys.
  
 
|-
 
|-
|| 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:25
+
||13:25
 
||It summarizes 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 DesiCrew Solutions Pvt.Ltd.
 
||This tutorial has been contributed by DesiCrew Solutions Pvt.Ltd.
  
 
|-
 
|-
|| 14:16
+
||14:16
 
||Thanks for joining.
 
||Thanks for joining.
  
 
|-
 
|-
 
|}
 
|}

Latest revision as of 10:26, 27 March 2017

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 GNU/Linux 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:10 Let's undo this.
01:12 Now click on the cell corresponding to “A1” in the spreadsheet.
01:16 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:18 So, click on the cell corresponding to “A2” and enter numbers as 1, 2, 3 one below the other.
02:28 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:44 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:08 Now, what if we want to precede the number with the Rupee symbol?
03:12 Let's say, we want to enter “Rupees 800” for “Electricity bill”. So, right-click on the cell 'C4' and click on “Format Cells” option.
03:24 This will open the “Format Cells” dialog-box.
03:28 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:42 Let's select Currency.
03:45 Now, under the Format option, click on the down-arrow. This will display the various currency symbols from across the world.
03:54 Let's scroll up and select INR Rupees English India. By default, Rupees 1234 is selected in the drop-down below.
04:05 You can see a preview of it in the small preview area on the right.
04:11 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:06 We will learn about the options in the 'Alignment' tab in another tutorial later.
05:11 Let's click on OK.
05:16 Let's type 800 and press Enter. You will notice that the number 800 is represented as Rupees 800 with 2 decimal places.
05:27 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:40 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 expenses 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:28 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:52 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 colon 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:44 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:33 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:44 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 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:19 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 are - * "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:01 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:49 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:01 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:33 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:44 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:02 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:25 This brings us to the end of the Spoken Tutorial on LibreOffice Calc.
12:31 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:48 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:06 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:25 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

PoojaMoolya, Sandhya.np14