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

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 13: Line 13:
 
|-
 
|-
 
|| 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'''.
  
 
|-
 
|-
Line 25: Line 25:
 
|-
 
|-
 
|| 00:23
 
|| 00:23
||* How to select items in rows, columns and '''sheets'''.
+
||* How to select items in '''rows, columns''' and '''sheets'''.
  
 
|-
 
|-
Line 33: Line 33:
 
|-
 
|-
 
|| 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.
  
 
|-
 
|-
Line 49: Line 49:
 
|-
 
|-
 
|| 01:08
 
|| 01:08
||Lets '''undo''' this.
+
||Let's '''undo''' this.
  
 
|-
 
|-
 
|| 01:11
 
|| 01:11
|| Now click on the cell corresponding to ''''A1'''' in the '''spreadsheet'''.
+
|| Now, click on the cell corresponding to 'A1' in the '''spreadsheet'''.
  
 
|-
 
|-
Line 61: Line 61:
 
|-
 
|-
 
|| 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''''.
  
 
|-
 
|-
Line 85: Line 85:
 
|-
 
|-
 
|| 02:04
 
|| 02:04
|| Now, under the '''Serial Number''' heading, denoted as '''SN''' in our 'personal finance tracker.ods' spreadsheet, we want the serial number of each item one below the other.
+
|| Now, under the '''Serial Number''' heading, denoted as "SN" in our "personal finance tracker.ods" spreadsheet, we want the serial number of each item one below the other.
  
 
|-
 
|-
 
|| 02:17
 
|| 02:17
||So, click on the cell corresponding to '''A2''' and enter numbers as '''1, 2, 3''' one below the other.
+
||So, click on the cell corresponding to '''A2''' and enter numbers as '''1, 2, 3''', one below the other.
  
 
|-
 
|-
Line 97: Line 97:
 
|-
 
|-
 
|| 02:42
 
|| 02:42
||You will see that the cells '''A5''' till '''A7''' gets populated with the subsequent serial numbers.
+
||You will see that the cells '''A5''' till '''A7''' get populated with the subsequent serial numbers.
  
 
|-
 
|-
Line 121: Line 121:
 
|-
 
|-
 
|| 03:27
 
|| 03:27
||The first tab is '''Numbers'''. Click on it, if not already selected.
+
||The first tab is '''Numbers'''. Click on it, if not already selected.
  
 
|-
 
|-
Line 137: Line 137:
 
|-
 
|-
 
|| 03:53
 
|| 03:53
||Lets scroll up and select '''INR Rupees English India'''. By default, '''Rupee 1234''' is selected in the drop-down below.   
+
||Let's scroll up and select '''INR Rupees English India'''. By default, '''Rupee 1234''' is selected in the drop-down below.   
  
 
|-
 
|-
 
|| 04:04
 
|| 04:04
||You can see a preview of it in the small '''preview area''' on the right.
+
||You can see a preview of it, in the small '''preview area''' on the right.
  
 
|-
 
|-
Line 181: Line 181:
 
|-
 
|-
 
|| 05:26
 
|| 05:26
|| Now, let's select cells '''C5''' to '''C7'''.  Hold the '''Ctrl''' key and select '''cell G2''' also.  Notice all the selected cells are highlighted.
+
|| Now, let's select cells '''C5''' to '''C7'''.  Hold the '''Ctrl''' key and select '''cell G2''' also.  Notice, all the selected cells are highlighted.
  
 
|-
 
|-
Line 193: Line 193:
 
|-
 
|-
 
|| 05:51
 
|| 05:51
|| Now, we type the expense on all the other items one below the other as- '''Rupees 600''' for 'Phone bill', '''Rupees 300''' as 'Laundry' charges and '''Rupees 2000''' as other 'Miscellaneous' charges.
+
|| Now, we type the expense on all the other items, one below the other, as- '''Rupees 600''' for 'Phone bill', '''Rupees 300''' as 'Laundry' charges and '''Rupees 2000''' as other 'Miscellaneous' charges.
  
 
|-
 
|-
Line 217: Line 217:
 
|-
 
|-
 
|| 06:38
 
|| 06:38
||Choose '''Date''' under category and the desired format under '''Format'''.  I will choose '''12, 31, 1999'''.  Notice the display in the preview area.
+
||Choose '''Date''' under '''Category''' and the desired format under '''Format'''.  I will choose '''12, 31, 1999'''.  Notice the display in the preview area.
  
 
|-
 
|-
 
|| 06:51
 
|| 06:51
||Also, the '''Format code''' is displayed below as '''MM, DD''' and '''YYYY'''.  One can change the Format code as required.   
+
||Also, the '''Format code''' is displayed below as '''MM, DD''' and '''YYYY'''.  One can change the '''Format code''' as required.   
  
 
|-
 
|-
Line 245: Line 245:
 
|-
 
|-
 
|| 07:43
 
|| 07:43
||Also, the Format code is displayed below as '''HH:MM:SS'''. One can change the Format code as required.  I will type '''HH:MM'''.
+
||Also, the '''Format code''' is displayed below as '''HH:MM:SS'''. One can change the 'Format code' as required.  I will type '''HH:MM'''.
  
 
|-
 
|-
Line 302: Line 302:
 
|-
 
|-
 
|| 09:18
 
|| 09:18
||This changes the focus to the new cell.
+
||This changes the focus to the new '''cell'''.
 
   
 
   
 
|-
 
|-
Line 310: Line 310:
 
|-
 
|-
 
|| 09:28
 
|| 09:28
|| Another method of navigation between cells are - * '''Tab'''  to go to the next cell in a row,
+
|| Another method of navigation between cells is- * '''Tab'''  to go to the next cell in a row,
  
 
|-
 
|-
 
|| 09:35
 
|| 09:35
||''''Shift + Tab'''' to go to the previous cell in a row,
+
||'''Shift + Tab''' to go to the previous cell in a row,
  
 
|-
 
|-
Line 322: Line 322:
 
|-
 
|-
 
|| 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.
  
 
|-
 
|-
Line 374: Line 374:
 
|-
 
|-
 
|| 11:09
 
|| 11:09
||Now hold down the '''Shift''' key.
+
||Now, hold down the '''Shift''' key.
  
 
|-
 
|-
Line 394: Line 394:
 
|-
 
|-
 
|| 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.
  
 
|-
 
|-
Line 418: Line 418:
 
|-
 
|-
 
|| 12:12
 
|| 12:12
||Hold down the '''Control''' key and click on the '''sheet tab'''.
+
||Hold down the '''Control''' key and click on the '''sheet''' tab.
  
 
|-
 
|-
 
|| 12:16
 
|| 12:16
||The selected tabs will turn white and any actions that you perform will now affect all highlighted sheets.
+
||The selected tabs will turn white and any actions that you perform, will now affect all highlighted sheets.
  
 
|-  
 
|-  
 
|| 12:24
 
|| 12:24
|| This brings us to the end of the Spoken Tutorial on LibreOffice Calc.
+
|| This brings us to the end of the '''Spoken Tutorial''' on '''LibreOffice Calc'''.
  
 
|-
 
|-
Line 434: Line 434:
 
|-
 
|-
 
|| 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.
  
 
|-
 
|-
Line 454: Line 454:
 
|-
 
|-
 
|| 12:55
 
|| 12:55
||Open ''''Spreadsheet Practice.ods''''.
+
||Open "Spreadsheet Practice.ods".
  
 
|-
 
|-
 
|| 12:58
 
|| 12:58
||Under '''Serial Numbers''', type the serial number from 1 to 5 one below the other.
+
||Under '''Serial Numbers''', type the serial number from 1 to 5, one below the other.
  
 
|-
 
|-
Line 502: Line 502:
 
|-
 
|-
 
|| 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'''.
  
 
|-
 
|-
Line 518: Line 519:
 
|-
 
|-
 
|| 14:03
 
|| 14:03
||spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
+
||'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.
  
 
|-
 
|-

Revision as of 17:39, 5 January 2016

Time Narration
00:00 Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells.
00:06 In this tutorial, we will learn:
00:08 * How to enter numbers, text, numbers as text, date and time in a spreadsheet.
00:16 * How to use the Format Cells dialog-box.
00:19 * How to navigate between cells and in between sheets.
00:23 * How to select items in rows, columns and sheets.
00:29 We will be using Ubuntu 10.04 as our operating system and LibreOffice Suite version 3.3.4.
00:39 So, let us first learn how to enter data in the cells.
00:43 We shall open our "personal finance tracker.ods" file.
00:49 You can type any text in a particular cell by simply clicking on the cell and then typing the text, using the keyboard.
00:59 The text is left-aligned, by default. One can change the alignment by clicking any one of the alignment tabs on the Formatting Bar.
01:08 Let's undo this.
01:11 Now, click on the cell corresponding to 'A1' in the spreadsheet.
01:15 You see that the selected cell gets highlighted.
01:20 Here we have already typed the column headings.
01:24 Under the heading Items, we shall type the names of a few items one below the other as- 'Salary', 'House rent', 'Electricity bill', 'Phone bill', 'Laundry' and 'Miscellaneous'.
01:38 In order to enter numbers in the cell, click on the cell and type in the numbers.
01:43 To enter a negative number, either type a minus sign in front of it or enclose it in parentheses.
01:53 By default, numbers are right-aligned and negative numbers have a leading minus symbol.
02:01 Let us undo the changes.
02:04 Now, under the Serial Number heading, denoted as "SN" in our "personal finance tracker.ods" spreadsheet, we want the serial number of each item one below the other.
02:17 So, click on the cell corresponding to A2 and enter numbers as 1, 2, 3, one below the other.
02:27 In order to auto-fill the serial numbers, click on the cell A4. A little black box is visible at the bottom-right corner of the cell. Drag it till cell A7 and release the mouse button.
02:42 You will see that the cells A5 till A7 get populated with the subsequent serial numbers.
02:51 After entering the serial number of the items, we will now enter the cost of each item under the heading Cost.
02:59 So, we click on the cell referenced as C3 and type the expense for House rent as Rupees 6000.
03:07 Now, what if we want to precede the number with the Rupee symbol?
03:11 Lets say, we want to enter Rupees 800 for Electricity bill. So, right-click on cell C4 and click on Format Cells option.
03:23 This will open the Format Cells dialog-box.
03:27 The first tab is Numbers. Click on it, if not already selected.
03:32 Various categories can be seen under Category such as Number, Percent, Currency, Date, Time and many more.
03:41 Let's select Currency.
03:44 Now, under the Format option, click on the down-arrow. This will display the various currency symbols from across the world.
03:53 Let's scroll up and select INR Rupees English India. By default, Rupee 1234 is selected in the drop-down below.
04:04 You can see a preview of it, in the small preview area on the right.
04:10 Under Options, we have the option to add the number of Decimal places and the number of Leading zeroes that we want.
04:20 Notice that as we increase the number of zeroes, the selection under Format has changed to Rupees 1,234 decimal zero zero, indicating 2 decimal places.
04:35 Notice the change is displayed in the preview area.
04:40 Click on Thousands separator to add the comma separator for each thousand. Once again, notice the change in the preview area.
04:50 One can also change the font style by clicking on the Font tab. It has various options for Font, Typeface and Size.
05:00 Explore Font Effects and the other tabs to learn more about them.
05:05 We will learn about the options in the Alignment tab in another tutorial later.
05:11 Let's click on OK.
05:15 Let's type 800 and press Enter. You will notice that the number 800 is represented as 'Rupees 800' with 2 decimal places.
05:26 Now, let's select cells C5 to C7. Hold the Ctrl key and select cell G2 also. Notice, all the selected cells are highlighted.
05:39 Right-click on any of the highlighted cells and select Format Cells.
05:46 Choose the same options as before. Click on OK.
05:51 Now, we type the expense on all the other items, one below the other, as- Rupees 600 for 'Phone bill', Rupees 300 as 'Laundry' charges and Rupees 2000 as other 'Miscellaneous' charges.
06:06 Under the heading Accounts, we type the salary for the month as Rupees 30000.
06:13 For entering date in Calc, select the cell and type the date.
06:18 You can separate the date elements with a forward slash or a hyphen or use text such as 10 October 2011.
06:27 Calc recognizes a variety of date formats.
06:32 Alternately, one can right-click on the cell and choose Format Cells option.
06:38 Choose Date under Category and the desired format under Format. I will choose 12, 31, 1999. Notice the display in the preview area.
06:51 Also, the Format code is displayed below as MM, DD and YYYY. One can change the Format code as required.
07:02 I will type DD, MM and YYYY. Notice the change in the preview area. Click on OK.
07:12 For entering time in Calc, select the cell and type the time.
07:18 You can separate time elements with colons such as 10 colon 43 colon 20.
07:24 Alternately, one can right-click on the cell and choose Format Cells option.
07:31 Choose Time under category and the desired format under Format. I will choose 13, 37, 46. Notice the display in the preview area.
07:43 Also, the Format code is displayed below as HH:MM:SS. One can change the 'Format code' as required. I will type HH:MM.
07:57 Notice the change in the preview area.

Click on OK.

08:03 Let us undo the changes.
08:06 After learning how to write text, numbers and dates in Calc, we will now learn how to navigate within a spreadsheet from cell to cell and from sheet to sheet.
08:17 So, we will first see how we can navigate from cell to cell within a spreadsheet.
08:23 You can simply access a particular cell by clicking on it with the cursor.
08:29 You see that the particular cell gets highlighted.
08:32 Another method of accessing a particular cell is by using a cell reference.
08:38 Click on the little black down arrow just to the right of the Name Box.
08:43 Now, type the cell reference of the cell you want to go to and press Enter .
08:49 You can even click into the Name box, delete the existing cell reference and type in the cell reference you want and press Enter.
08:58 Next we will learn about how to navigate between cells in a spreadsheet.
09:03 The first method of navigation between cells is by using the cursor.
09:09 To move the focus using the cursor, simply move the cursor to the cell where you want the focus to be and click the left mouse button.
09:18 This changes the focus to the new cell.
09:22 This method is most useful when the two cells are a large distance apart.
09:28 Another method of navigation between cells is- * Tab to go to the next cell in a row,
09:35 Shift + Tab to go to the previous cell in a row,
09:39 Enter to go to the next cell in a column,
09:42 Shift + Enter to go to the previous cell in a column.
09:46 Next, we will learn how to navigate between different spreadsheets in Calc using the keyboard.
09:53 For accessing the sheet to the right of the active sheet, press the Control plus Page Down keys simultaneously.
10:00 In order to access the sheet to the left of the current sheet, press the Control plus Page Up keys simultaneously.
10:08 You can also navigate between sheets using the cursor.
10:13 Detailed information on this is available in the tutorial 'Working with Sheets'.
10:19 If you have a number of sheets then some of the sheet tabs may be hidden behind the horizontal scroll-bar at the bottom of the screen.
10:28 If this is the case then the four buttons at the bottom-left of the sheet tabs can move the tabs into view.
10:36 Let us undo the changes.
10:39 For selecting a range of contiguous cells with the cursor, first click in a cell.
10:45 Now press and hold down the left mouse button.
10:48 Move the cursor around the screen and once the desired block of cells is highlighted, release the left mouse button. You see that the selected cells are highlighted.
11:00 In order to select multiple columns or rows that are contiguous, click on the first column or row in the group.
11:09 Now, hold down the Shift key.
11:12 Click the last column or row in the group.
11:15 To select multiple columns or rows that are not contiguous, click on the first column or row in the group.
11:23 Hold down the Control key and click on all of the subsequent columns or rows while holding down the Control key.
11:31 For selecting multiple contiguous sheets, click on the sheet tab for the first desired sheet.
11:39 Now, move the cursor over the sheet tab for the last desired sheet.
11:43 Hold down the Shift key and click on the sheet tab.
11:48 All the tabs between these two sheets will turn white which indicates that they are all selected.
11:56 Any actions that you perform will now affect all highlighted sheets.
12:01 For selecting multiple non- contiguous sheets, click on the sheet tab for the first sheet.
12:08 Now, move the cursor over the third sheet tab.
12:12 Hold down the Control key and click on the sheet tab.
12:16 The selected tabs will turn white and any actions that you perform, will now affect all highlighted sheets.
12:24 This brings us to the end of the Spoken Tutorial on LibreOffice Calc.
12:30 To summarize, we learned about:
12:33 * How to enter numbers, text , numbers as text, date and time in Calc.
12:40 * How to use the Format Cells dialog-box.
12:43 How to navigate between cells and between sheets.
12:47 How to select items in rows, columns and sheets.
12:52 COMPREHENSIVE ASSIGNMENT-
12:55 Open "Spreadsheet Practice.ods".
12:58 Under Serial Numbers, type the serial number from 1 to 5, one below the other.
13:04 Navigate between the cells using keys.
13:09 Select all the items under Serial Number.
13:13 Add a column for Date and Time.
13:16 Enter some values in them using the Format Cells dialog-box options.
13:21 Watch the video available at the following link.
13:24 It summarizes the Spoken Tutorial project.
13:27 If you do not have good bandwidth, you can download and watch it.
13:32 The Spoken Tutorial project team:
13:35 * Conducts workshops using spoken tutorials.
13:38 * Gives certificates for those who pass an online test.
13:41 For more details, please write to:

contact at spoken hyphen tutorial dot org.

13:48 Spoken Tutorial project is a part of the Talk to a Teacher project.
13:52 It is supported by the National Mission on Education through ICT, MHRD, Government of India.
14:00 More information on this mission is available at:
14:03 spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
14:11 This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.
14:16 Thanks for joining.

Contributors and Content Editors

Minal, Pratik kamble, Sandhya.np14