Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Working-with-Cells/English-timed"
From Script | Spoken-Tutorial
Sandhya.np14 (Talk | contribs) |
PoojaMoolya (Talk | contribs) |
||
| 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. |
|- | |- | ||
| − | || 00:16 | + | ||00:16 |
| − | || | + | ||How to use the '''Format Cells''' dialog box. |
|- | |- | ||
| − | || 00:19 | + | ||00:19 |
| − | || | + | ||How to navigate between '''cell'''s and in between '''sheet'''s. |
|- | |- | ||
| − | || 00:23 | + | ||00:23 |
| − | || | + | ||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, | |
|- | |- | ||
| − | || 09:35 | + | ||09:35 |
| − | || | + | ||'''”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, |
|- | |- | ||
| − | || 09:42 | + | ||09:42 |
| − | || | + | ||'''“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. |
|- | |- | ||
| − | || 12:40 | + | ||12:40 |
| − | || | + | ||How to use the '''Format Cells''' dialog box. |
|- | |- | ||
| − | || 12:43 | + | ||12:43 |
| − | || | + | ||How to navigate between cells and between sheets. |
|- | |- | ||
| − | || 12:48 | + | ||12:48 |
| − | || | + | ||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. |
|- | |- | ||
| − | || 13:38 | + | ||13:38 |
| − | || | + | ||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. |
