LibreOffice-Calc-on-BOSS-Linux/C2/Working-with-Cells/English-timed - Revision history

PoojaMoolya at 04:56, 27 March 2017

2017-03-27T04:56:11Z

Show changes

Sandhya.np14 at 08:07, 7 October 2015

2015-10-07T08:07:35Z

Sandhya.np14 at 17:51, 4 September 2015

2015-09-04T17:51:47Z

Sandhya.np14 at 17:03, 4 September 2015

2015-09-04T17:03:46Z

Sandhya.np14 at 02:55, 17 August 2015

2015-08-17T02:55:43Z

Show changes

PoojaMoolya at 04:50, 19 January 2015

2015-01-19T04:50:42Z

Show changes

PoojaMoolya at 04:49, 19 January 2015

2015-01-19T04:49:31Z

Show changes

PoojaMoolya: Created page with "{| border=1 || '''Time''' || '''Narration''' |- || 00:00 || Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells. |- || 00:06 || In this tutorial we wil..."

2014-12-31T05:22:22Z

Created page with "{| border=1 || '''Time''' || '''Narration''' |- || 00:00 || Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells. |- || 00:06 || In this tutorial we wil..."

New page

{| border=1
|| '''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

|-

|}

@@ Line 41: / Line 41: @@
 |-
 || 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
-||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'''.
 |-
@@ Line 65: / Line 65: @@
 |-
 || 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
-|| 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.
 |-
@@ Line 109: / Line 109: @@
 |-
 || 03:08
-|| Now, what if we want precede the number with the Rupee symbol?
+|| Now, what if we want to precede the number with the Rupee symbol?
 |-
@@ Line 117: / Line 117: @@
 |-
 || 03:24
-|| This will open the “Format Cells” dialog box.
+|| This will open the “Format Cells” dialog-box.
 |-
@@ Line 133: / Line 133: @@
 |-
 || 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.
 |-
@@ Line 145: / Line 145: @@
 |-
 || 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
-||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.
 |-
@@ Line 177: / Line 177: @@
 |-
 ||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.
 |-
@@ Line 193: / Line 193: @@
 |-
 || 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.
 |-
@@ Line 209: / Line 209: @@
 |-
 || 06:28
-||Calc recognizes a variety of date formats.
+||'''Calc''' recognizes a variety of date formats.
 |-
@@ Line 345: / Line 345: @@
 |-
 || 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
-||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.
 |-
@@ Line 381: / Line 381: @@
 |-
 || 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.
 |-
@@ Line 389: / Line 389: @@
 |-
 || 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 417: / Line 417: @@
 |-
 || 12:12
-||Hold down the '''Control''' key and click on the sheet tab.
+||Hold down the '''Control''' key and click on the '''sheet tab'''.
 |-
@@ Line 469: / Line 469: @@
 |-
 || 13:13
-||Add a column for Date and Time.
+||Add a column for '''Date''' and '''Time'''.
 |-
 || 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.
 |-

@@ Line 241: / Line 241: @@
 |-
 || 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'''.
 |-
@@ 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'''.
 |-
 || 08:03
-||Let us undo the changes.
+||Let us '''undo''' the changes.
 |-
@@ Line 286: / Line 285: @@
 |-
 || 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
-|| Next we will learn about how to navigate between cells in a spreadsheet.
+|| Next we will learn how to navigate between cells in a spreadsheet.
 |-
@@ Line 310: / Line 309: @@
 |-
 || 09:28
-|| Another method of navigation between cells are - * “Tab”  to go to the next cell in a row,
+|| Another method of navigation between cells are - * '''"Tab"''' to go to the next cell in a row,
 |-
 || 09:35
-||* ”Shift + Tab” to go to the previous cell in a row,
+||* '''”Shift + Tab”''' to go to the previous cell in a row,
 |-
 || 09:39
-||* “Enter”  to go to the next cell in a column,
+||* '''“Enter”'''  to go to the next cell in a column,
 |-
 || 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 334: / Line 333: @@
 |-
 || 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 342: / Line 341: @@
 |-
 || 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”'''.
 |-
@@ Line 354: / Line 353: @@
 |-
 || 10:36
-||Let us undo the changes.
+||Let us '''undo''' the changes.
 |-
@@ Line 374: / Line 373: @@
 |-
 || 11:09
-||Now hold down the “Shift” key.
+||Now hold down the '''Shift''' key.
 |-
@@ Line 386: / Line 385: @@
 |-
 || 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.
 |-
@@ Line 398: / Line 397: @@
 |-
 || 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
-||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.
 |-
@@ Line 410: / Line 409: @@
 |-
 || 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
-||Now move the cursor over the third sheet tab.
+||Now, move the cursor over the third sheet tab.
 |-
 || 12:12
-||Hold down the “Control” key and click on the sheet tab.
+||Hold down the '''Control''' key and click on the sheet tab.
 |-
@@ Line 438: / Line 437: @@
 |-
 || 12:40
-||* How to use the Format Cells dialog box.
+||* How to use the '''Format Cells''' dialog box.
 |-
@@ Line 466: / Line 465: @@
 |-
 || 13:09
-||Select all the items under serial number.
+||Select all the items under '''serial number'''.
 |-
@@ Line 474: / Line 473: @@
 |-
 || 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.
 |-
@@ Line 482: / Line 481: @@
 |-
 || 13:25
-||It summarizes the Spoken Tutorial project
+||It summarizes the Spoken Tutorial project.
 |-
@@ Line 490: / Line 489: @@
 |-
 || 13:32
-||The Spoken Tutorial Project Team:
+||The Spoken Tutorial Project team:
 |-
 || 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 contact at spoken hyphen tutorial dot org.
+||For more details, please write to: contact at spoken hyphen tutorial dot org.
 |-
@@ Line 522: / Line 521: @@
 |-
 || 14:11
-||This tutorial has been contributed by ...............................(Name of the translator and narrator).
+||This tutorial has been contributed by DesiCrew Solutions Pvt.Ltd.
-−
-And this is -----------------------(name of the recorder) from --------------------------(name of the place) signing off. Thanks for watching.
 |-
@@ Line 531: / Line 528: @@
 |-
 |}

@@ Line 17: / Line 17: @@
 |-
 || 00:16
-||* How to use the 'Format Cells' dialog box.
+||* How to use the '''Format Cells''' dialog box.
 |-
@@ Line 49: / Line 49: @@
 |-
 || 01:10
-||Let's undo this.
+||Let's '''undo''' this.
 |-
@@ Line 69: / Line 69: @@
 |-
 || 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.
 |-
@@ Line 81: / Line 81: @@
 |-
 || 02:01
-||Let us undo the changes.
+||Let us '''undo''' the changes.
 |-
@@ Line 89: / Line 89: @@
 |-
 || 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
-|| 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.
 |-
@@ Line 113: / Line 113: @@
 |-
 || 03:12
-||Let's say, we want to enter “Rupees 800” for “Electricity bill”.  So, right-click on 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.
 |-
@@ Line 125: / Line 125: @@
 |-
 || 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.
 |-
@@ Line 137: / Line 137: @@
 |-
 || 03:54
-||Let's 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, '''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.
+||You can see a '''preview''' of it in the small '''preview area''' on the right.
 |-
@@ Line 149: / Line 149: @@
 |-
 || 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.
 |-
@@ Line 161: / Line 161: @@
 |-
 || 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'''.
 |-
@@ Line 169: / Line 169: @@
 |-
 || 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 201: / Line 201: @@
 |-
 || 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.
 |-
@@ Line 217: / Line 217: @@
 |-
 || 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'''.
 |-
@@ Line 233: / Line 233: @@
 |-
 || 07:18
-||You can separate time elements with colons such as 10 colon 43 colon 20.
+||You can separate time elements with colon such as 10 colon 43 colon 20.
 |-
@@ Line 241: / Line 241: @@
 |-
 || 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.
 |-