LibreOffice-Suite-Calc/C3/Advanced-Formatting-and-Protection/English-timed - Revision history

PoojaMoolya at 08:54, 23 March 2017

2017-03-23T08:54:36Z

PoojaMoolya at 07:45, 23 March 2017

2017-03-23T07:45:07Z

PoojaMoolya at 05:12, 10 March 2017

2017-03-10T05:12:24Z

Sandhya.np14 at 08:52, 9 January 2016

2016-01-09T08:52:59Z

Sandhya.np14 at 03:47, 9 January 2016

2016-01-09T03:47:30Z

Sandhya.np14 at 02:58, 9 January 2016

2016-01-09T02:58:29Z

Sandhya.np14 at 12:02, 9 October 2015

2015-10-09T12:02:45Z

Sandhya.np14 at 12:02, 9 October 2015

2015-10-09T12:02:06Z

Show changes

Sandhya.np14 at 09:10, 9 October 2015

2015-10-09T09:10:09Z

Show changes

Sandhya.np14 at 06:59, 9 October 2015

2015-10-09T06:59:35Z

@@ Line 415: / Line 415: @@
 |-
 ||08:37
-|| The “Validity” option validates data in the spreadsheet.
+||The “Validity” option validates data in the spreadsheet.
 |-

@@ Line 13: / Line 13: @@
 |-
 ||00:07
-||In this tutorial, we will learn how to:
+||In this tutorial, we will learn how to: '''Password protect''' a spreadsheet
-  '''Password protect''' a spreadsheet
-  Password protect a single '''sheet''' or a tab in a spreadsheet
+Password protect a single '''sheet''' or a tab in a spreadsheet, Define '''Ranges''' for a database
-  Define '''Ranges''' for a database
-   Use the '''Subtotal''' option and
+Use the '''Subtotal''' option and '''Validate''' cells.
-  '''Validate''' cells.
 |-
 ||00:25
 ||Here we are using:
    '''Ubuntu Linux''' version '''10.04''' and
-  '''LibreOffice Suite''' version '''3.3.4'''.
+'''Ubuntu Linux''' version '''10.04''' and '''LibreOffice Suite''' version '''3.3.4'''.
 |-
@@ Line 535: / Line 535: @@
 |-
 ||11:42
-||To summarize, we have learnt how to:
+||To summarize, we have learnt how to: '''Password protect''' a spread sheet
-  '''Password protect''' a spread sheet
-   Password protect a single sheet or tab in a spreadsheet file
+Password protect a single sheet or tab in a spreadsheet file
    How to define '''Ranges''' for database
-   How to use '''Subtotals''' and
+How to define '''Ranges''' for database
    How to '''validate''' cells.
 |-

@@ Line 14: / Line 14: @@
 ||00:07
 ||In this tutorial, we will learn how to:
-* '''Password protect''' a spreadsheet
+  '''Password protect''' a spreadsheet
-* Password protect a single '''sheet''' or a tab in a spreadsheet
+  Password protect a single '''sheet''' or a tab in a spreadsheet
-* Define '''Ranges''' for a database
+  Define '''Ranges''' for a database
-* Use the '''Subtotal''' option and
+  Use the '''Subtotal''' option and
-* '''Validate''' cells.
+  '''Validate''' cells.
 |-
 ||00:25
 ||Here we are using:
-* '''Ubuntu Linux''' version '''10.04''' and
+  '''Ubuntu Linux''' version '''10.04''' and
-* '''LibreOffice Suite''' version '''3.3.4'''.
+  '''LibreOffice Suite''' version '''3.3.4'''.
 |-
@@ Line 32: / Line 32: @@
 ||00:40
 ||First, let us learn to '''password protect''' this file.
 |-
 ||00:44
 ||This option ensures that only people who know the password can open this file.
 |-
 ||00:51
 ||From the '''Main menu''', click '''File''' and '''Save As'''.
 |-
 ||00:55
@@ Line 45: / Line 48: @@
 ||00:58
 ||Next, check the ''''Save with password'''' box.
 |-
 ||01:03
 ||Then click '''Save'''.
 |-
 ||01:06
 ||As we are using the '''Save As''' option, we can either save it as a different file or replace the same file.
 |-
 ||01:15
@@ Line 62: / Line 68: @@
 ||01:20
 ||Then enter a '''password'''
 |-
 ||01:23
@@ Line 97: / Line 104: @@
 ||01:59
 ||The file opens.
 |-
 ||02:01
@@ Line 147: / Line 155: @@
 |-
 ||03:07
-||Click '''OK'''.
+||Click '''OK'''.Now, let’s try to select and modify data in a '''cell'''.
-−
-|-
-||03:08
-||Now, let’s try to select and modify data in a '''cell'''.
 |-
@@ Line 184: / Line 188: @@
 ||03:38
 ||Now, let’s un-protect the sheet.
 |-
 ||03:41
 ||This is simple.
 |-
 ||03:43
@@ Line 214: / Line 220: @@
 ||04:12
 ||Each row in this '''database range''' corresponds to a database '''record''' and
 |-
 ||04:17
 ||each '''cell''' in a row corresponds to a database '''field'''.
 |-
 ||04:22
@@ Line 336: / Line 344: @@
 ||07:11
 ||This groups the data by '''Serial Number'''.
 |-
 ||07:15
@@ Line 527: / Line 536: @@
 ||11:42
 ||To summarize, we have learnt how to:
-* '''Password protect''' a spread sheet
+  '''Password protect''' a spread sheet
-* Password protect a single sheet or tab in a spreadsheet file
+  Password protect a single sheet or tab in a spreadsheet file
-* How to define '''Ranges''' for database
+  How to define '''Ranges''' for database
-* How to use '''Subtotals''' and
+  How to use '''Subtotals''' and
-* How to '''validate''' cells.
+  How to '''validate''' cells.
 |-
@@ Line 540: / Line 549: @@
 ||12:04
 ||It summarizes the '''Spoken Tutorial''' project.
 |-
 ||12:07
@@ Line 550: / Line 560: @@
 |-
 ||12:13
-||* Conducts workshops using spoken tutorials.
+||Conducts workshops using spoken tutorials.
 |-
 ||12:17
-||* Gives certificates for those who pass an online test.
+||Gives certificates for those who pass an online test.
 |-

@@ Line 382: / Line 382: @@
 |-
 ||08:11
-||We get the detailed view of the '''sheet''' along with the grand total of the data under “Costs”.
+||We get the detailed view of the '''sheet''' along with the '''grand total''' of the data under “Costs”.
 |-
@@ Line 390: / Line 390: @@
 |-
 ||08:21
-||A dialog-box with message '''Save''' or '''Discard''' changes appears.
+||A dialog-box with the message '''Save''' or '''Discard changes''' appears.
 |-
@@ Line 414: / Line 414: @@
 |-
 ||08:49
-||For example, in “Personal-Finance-Tracker.ods”, we can specify the mode of payment for the items bought using '''Validation'''.
+||For example- in “Personal-Finance-Tracker.ods”, we can specify the mode of payment for the items bought, using '''Validation'''.
 |-
@@ Line 426: / Line 426: @@
 |-
 ||09:12
-||Below the heading “M-O-P”, the cells can be used to display the mode of payments, for the data entries, under the heading “Items”.
+||Below the heading “M-O-P”, the cells can be used to display the mode of payments for the data entries under the heading “Items”.
 |-
@@ Line 527: / Line 527: @@
 ||11:42
 ||To summarize, we have learnt how to:
-* Password protect a spread sheet
+* '''Password protect''' a spread sheet
 * Password protect a single sheet or tab in a spreadsheet file
-* How to define Ranges for database
+* How to define '''Ranges''' for database
-* How to use Subtotals and
+* How to use '''Subtotals''' and
-* How to validate cells.
+* How to '''validate''' cells.
 |-
@@ Line 539: / Line 539: @@
 |-
 ||12:04
-||It summarizes the Spoken Tutorial project.
+||It summarizes the '''Spoken Tutorial''' project.
 |-
 ||12:07
@@ Line 575: / Line 575: @@
 |-
 ||12:42
-||spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
+||'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.
 |-

@@ Line 303: / Line 303: @@
 |-
 ||06:21
-||Let’s press the '''CTRL+Z''' keys to '''undo''' the sort and get the original data.
+||Let’s press the '''CTRL+Z''' keys to '''undo''' the '''sort''' and get the original data.
 |-

@@ Line 14: / Line 14: @@
 ||00:07
 ||In this tutorial, we will learn how to:
-* Password protect a spreadsheet
+* '''Password protect''' a spreadsheet
-* Password protect a single sheet or a tab in a spreadsheet
+* Password protect a single '''sheet''' or a tab in a spreadsheet
-* Define Ranges for a database
+* Define '''Ranges''' for a database
-* Use the Subtotal option and
+* Use the '''Subtotal''' option and
-* Validate cells.
+* '''Validate''' cells.
 |-
 ||00:25
@@ Line 31: / Line 31: @@
 |-
 ||00:40
-||First let us learn to '''password protect''' this file.
+||First, let us learn to '''password protect''' this file.
 |-
 ||00:44
@@ Line 61: / Line 61: @@
 |-
 ||01:20
-||Then enter a password
+||Then enter a '''password'''
 |-
 ||01:23
-||and re-enter the password in '''confirm box''' also and click '''OK'''.
+||and re-enter the password in '''Confirm box''' also and click '''OK'''.
 |-
 ||01:30
-||Then close the "Personal-Finance-Tracker.ods".
+||Then, close the "Personal-Finance-Tracker.ods".
 |-
@@ Line 92: / Line 92: @@
 |-
 ||01:56
-||Now type the correct password.
+||Now, type the correct password.
 |-
@@ Line 119: / Line 119: @@
 |-
 ||02:23
-||Let us close and open this file.
+||Let us '''close''' and '''open''' this file.
 |-
@@ Line 127: / Line 127: @@
 |-
 ||02:31
-||Let’s learn how to password protect the individual sheets from this file.
+||Let’s learn how to '''password protect''' the individual sheets from this file.
 |-
 ||02:37
-||From the Menu bar, click on '''Tools, Protect Document''' and '''Sheet'''.
+||From the menu bar, click on '''Tools > Protect Document''' and '''Sheet'''.
 |-
@@ Line 143: / Line 143: @@
 |-
 ||02:56
-||Now, in the '''“Password”''' field, let’s enter “abc”, in the lower case, and re-enter the password in the '''“Confirm”''' field.
+||Now, in the '''“Password”''' field, let’s enter “abc”, in the lower case and re-enter the password in the '''“Confirm”''' field.
 |-
@@ Line 155: / Line 155: @@
 |-
 ||03:15
-||We are not able to select any '''cell'''!
+||We are not able to select any cell!
 |-
@@ Line 189: / Line 189: @@
 |-
 ||03:43
-||From the Menu bar, click on '''“Tools”, “Protect Document”''' and '''“Sheet”'''.
+||From the Menu bar, click on '''“Tools” > “Protect Document”''' and '''“Sheet”'''.
 |-
 ||03:49
-||A dialog-box, that requests for the password, appears.
+||A dialog-box that requests for the password, appears.
 |-
@@ Line 219: / Line 219: @@
 |-
 ||04:22
-||You can sort, group, search, and perform calculations on the range as you would in any database.
+||You can '''sort''', group, search and perform calculations on the range as you would in any database.
 |-
 ||04:30
-||Let’s define a database in “Personal-Finance-Tracker.ods” and sort the data.
+||Let’s define a database in “Personal-Finance-Tracker.ods” and '''sort''' the data.
 |-

@@ Line 9: / Line 9: @@
 |-
 ||00:00
-||Welcome to the Spoken Tutorial on Advanced Formatting and Protection in LibreOffice Calc.
+||Welcome to the '''Spoken Tutorial''' on '''Advanced Formatting and Protection''' in '''LibreOffice Calc'''.
 |-
 ||00:07
-||In this tutorial we will learn how to:
+||In this tutorial, we will learn how to:
 Password protect a spreadsheet
 Password protect a single sheet or a tab in a spreadsheet.