Pratik kamble at 12:25, 26 October 2016

2016-10-26T12:25:54Z

Sandhya.np14 at 12:09, 5 January 2016

2016-01-05T12:09:30Z

Show changes

Sandhya.np14 at 08:07, 7 October 2015

2015-10-07T08:07:26Z

Show changes

Pratik kamble at 10:38, 9 February 2015

2015-02-09T10:38:46Z

Show changes

Pratik kamble at 09:47, 9 July 2014

2014-07-09T09:47:46Z

Minal: Created page with '{| border=1 || VISUAL CUE || NARRATION |- || 00:00 || Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells. |- || 00:06 || In this tutorial we will learn: …'

2012-12-27T10:36:11Z

Created page with '{| border=1 || VISUAL CUE || NARRATION |- || 00:00 || Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells. |- || 00:06 || In this tutorial we will learn: …'

New page

{| border=1
|| VISUAL CUE
|| NARRATION

|-
|| 00:00
|| Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells.

|-
|| 00:06
|| In this tutorial we will learn:

|-
|| 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
||Lets 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” 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:07
|| Now, what if we want 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
|| Lets 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
||Lets 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
||Lets click on OK.

|-
||05:15
|| Lets type 800 and press Enter. You will notice that the number 800 is represented as Rupees 800 with 2 decimal places.

|-
|| 05:26
|| Now, lets select cells C5 to C7. Hold the CTRL key and select cell G2 also. Notice all the selected cells are highlighted.

|-
|| 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 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: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 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

|-

|}

@@ Line 13: / Line 13: @@
 |-
 || 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
-||* How to use the '''Format Cells''' dialog-box.
+||How to use the '''Format Cells''' dialog-box.
 |-
 || 00:19
-||* How to navigate between '''cells''' and in between '''sheets'''.
+||How to navigate between '''cells''' and in between '''sheets'''.
 |-
 || 00:23
-||* How to select items in '''rows, columns''' and '''sheets'''.
+||How to select items in '''rows, columns''' and '''sheets'''.
 |-
@@ Line 249: / Line 249: @@
 |-
 || 07:57
-||Notice the change in the preview area.
+||Notice the change in the preview area.Click on '''OK'''.
 Click on '''OK'''.
 |-
@@ Line 434: / Line 433: @@
 |-
 || 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
-||* How to use the '''Format Cells''' dialog-box.
+||How to use the '''Format Cells''' dialog-box.
 |-
@@ Line 494: / Line 493: @@
 |-
 || 13:35
-||* Conducts workshops using spoken tutorials.
+||Conducts workshops using spoken tutorials.
 |-
 || 13:38
-||* Gives certificates for those who pass an online test.
+||Gives certificates for those who pass an online test.
 |-
 || 13:41
-||For more details, please write to:
+||For more details, please write to:'''contact at spoken hyphen tutorial dot org'''.
 '''contact at spoken hyphen tutorial dot org'''.
 |-

@@ Line 1: / Line 1: @@
 {| border=1
-|| VISUAL CUE
+|| '''Time'''
-|| NARRATION
+|| '''Narration'''
 |-

LibreOffice-Suite-Calc/C2/Working-with-Cells/English-timed - Revision history

Pratik kamble at 12:25, 26 October 2016

Sandhya.np14 at 12:09, 5 January 2016

Sandhya.np14 at 08:07, 7 October 2015

Pratik kamble at 10:38, 9 February 2015

Pratik kamble at 09:47, 9 July 2014

Minal: Created page with '{| border=1 || VISUAL CUE || NARRATION |- || 00:00 || Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells. |- || 00:06 || In this tutorial we will learn: …'