Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Working-with-Cells/English-timed"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) |
PoojaMoolya (Talk | contribs) |
||
| Line 29: | Line 29: | ||
|- | |- | ||
|| 00:29 | || 00:29 | ||
| − | || We will be using | + | || We will be using GNU/Linux as our operating system and LibreOffice Suite version 3.3.4. |
|- | |- | ||
| Line 48: | Line 48: | ||
|- | |- | ||
| − | || 01: | + | || 01:10 |
||Lets undo this. | ||Lets undo this. | ||
|- | |- | ||
| − | || 01: | + | || 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: | + | || 01:16 |
||You see that the selected cell gets highlighted. | ||You see that the selected cell gets highlighted. | ||
| Line 88: | Line 88: | ||
|- | |- | ||
| − | || 02: | + | || 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: | + | || 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: | + | || 02:44 |
||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” gets populated with the subsequent serial numbers. | ||
| Line 108: | Line 108: | ||
|- | |- | ||
| − | || 03: | + | || 03:08 |
|| Now, what if we want precede the number with the Rupee symbol? | || Now, what if we want precede the number with the Rupee symbol? | ||
|- | |- | ||
| − | || 03: | + | || 03:12 |
||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: | + | || 03:24 |
|| This will open the “Format Cells” dialog box. | || This will open the “Format Cells” dialog box. | ||
|- | |- | ||
| − | || 03: | + | || 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. | ||
| Line 128: | Line 128: | ||
|- | |- | ||
| − | || 03: | + | || 03:42 |
|| Lets select Currency. | || Lets select Currency. | ||
|- | |- | ||
| − | || 03: | + | || 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: | + | || 03:54 |
||Lets scroll up and select INR Rupees English India. By default, Rupee 1234 is selected in the drop-down below. | ||Lets scroll up and select INR Rupees English India. By default, Rupee 1234 is selected in the drop-down below. | ||
|- | |- | ||
| − | || 04: | + | || 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: | + | || 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. | ||
| Line 168: | Line 168: | ||
|- | |- | ||
| − | || 05: | + | || 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. | ||
| Line 176: | Line 176: | ||
|- | |- | ||
| − | ||05: | + | ||05:16 |
|| Lets type 800 and press Enter. You will notice that the number 800 is represented as Rupees 800 with 2 decimal places. | || Lets type 800 and press Enter. You will notice that the number 800 is represented as Rupees 800 with 2 decimal places. | ||
|- | |- | ||
| − | || 05: | + | || 05:27 |
|| Now, lets select cells C5 to C7. Hold the CTRL key and select cell G2 also. Notice all the selected cells are highlighted. | || Now, lets select cells C5 to C7. Hold the CTRL key and select cell G2 also. Notice all the selected cells are highlighted. | ||
|- | |- | ||
| − | || 05: | + | || 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. | ||
| Line 208: | Line 208: | ||
|- | |- | ||
| − | || 06: | + | || 06:28 |
||Calc recognizes a variety of date formats. | ||Calc recognizes a variety of date formats. | ||
| Line 220: | Line 220: | ||
|- | |- | ||
| − | || 06: | + | || 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. | ||
| Line 245: | Line 245: | ||
|- | |- | ||
| − | || 07: | + | || 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. | ||
| Line 274: | Line 274: | ||
|- | |- | ||
| − | || 08: | + | || 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. | ||
| Line 282: | Line 282: | ||
|- | |- | ||
| − | || 08: | + | || 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” . | ||
| Line 299: | Line 299: | ||
|- | |- | ||
||09:09 | ||09:09 | ||
| − | || To move the focus using the cursor, simply move the cursor to the cell where you want | + | || 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: | + | || 09:19 |
||This changes the focus to the new cell. | ||This changes the focus to the new cell. | ||
| Line 334: | Line 334: | ||
|- | |- | ||
| − | || 10: | + | || 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. | ||
| Line 367: | Line 367: | ||
|- | |- | ||
| − | || 10: | + | || 10:49 |
||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: | + | || 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. | ||
| Line 392: | Line 392: | ||
|- | |- | ||
| − | || 11: | + | || 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. | ||
| Line 400: | Line 400: | ||
|- | |- | ||
| − | || 11: | + | || 11:44 |
||Hold down the “Shift” key and click on the sheet tab. | ||Hold down the “Shift” key and click on the sheet tab. | ||
| Line 409: | Line 409: | ||
|- | |- | ||
|| 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: | + | || 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. | ||
| Line 429: | Line 428: | ||
|- | |- | ||
| − | || 12: | + | || 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: | + | || 12:31 |
||To summarize, we learned about: | ||To summarize, we learned about: | ||
| Line 449: | Line 448: | ||
|- | |- | ||
| − | || 12: | + | || 12:48 |
||How to select items in rows, columns and sheets. | ||How to select items in rows, columns and sheets. | ||
| Line 465: | Line 464: | ||
|- | |- | ||
| − | || 13: | + | || 13:06 |
||Navigate between the cells using keys. | ||Navigate between the cells using keys. | ||
| Line 485: | Line 484: | ||
|- | |- | ||
| − | || 13: | + | || 13:25 |
||*It summarises the Spoken Tutorial project | ||*It summarises the Spoken Tutorial project | ||
Revision as of 10:20, 19 January 2015
| 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 | Lets 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” gets 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 precede the number with the Rupee symbol? |
| 03:12 | Lets say, we want to enter “Rupees 800” for “Electricity bill”. So, right-click on 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 | Lets 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 | Lets scroll up and select INR Rupees English India. By default, Rupee 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 | Lets click on OK. |
| 05:16 | Lets type 800 and press Enter. You will notice that the number 800 is represented as Rupees 800 with 2 decimal places. |
| 05:27 | Now, lets 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 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: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 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: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 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: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 summarises 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 ...............................(Name of the translator and narrator)
And this is -----------------------(name of the recorder) from --------------------------(name of the place)signing off. Thanks for watching. |
| 14:16 | *Thanks for joining |
