LibreOffice-Suite-Calc/C3/Formulas-and-Functions/English-timed - Revision history

PoojaMoolya at 09:14, 23 March 2017

2017-03-23T09:14:54Z

Pratik kamble at 09:55, 26 October 2016

2016-10-26T09:55:54Z

Pratik kamble at 09:51, 26 October 2016

2016-10-26T09:51:52Z

Sandhya.np14 at 17:10, 9 January 2016

2016-01-09T17:10:35Z

Sandhya.np14 at 13:01, 9 January 2016

2016-01-09T13:01:46Z

Sandhya.np14 at 12:51, 9 October 2015

2015-10-09T12:51:02Z

Sandhya.np14 at 12:49, 9 October 2015

2015-10-09T12:49:24Z

Show changes

Pratik kamble at 10:10, 9 July 2014

2014-07-09T10:10:28Z

Pratik kamble at 10:10, 9 July 2014

2014-07-09T10:10:03Z

Show changes

Pratik kamble at 10:07, 9 July 2014

2014-07-09T10:07:33Z

@@ Line 362: / Line 362: @@
 ||08:34
 ||To find the median value, replace the term “MIN” with “MEDIAN”
 |-
 ||08:40

@@ Line 13: / Line 13: @@
 |-
 ||00:07
-||In this tutorial, we will learn about: '''Conditional Operator''' '''If..Or statement''''''Basic statistic   functions''' '''Rounding off numbers'''.
+||In this tutorial, we will learn about: '''Conditional Operator''' '''If..Or statement''' '''Basic statistic   functions''' '''Rounding off numbers'''.
 |-

@@ Line 13: / Line 13: @@
 |-
 ||00:07
-||In this tutorial, we will learn about:
+||In this tutorial, we will learn about: '''Conditional Operator''' '''If..Or statement''''''Basic statistic   functions''' '''Rounding off numbers'''.
-* '''Conditional Operator'''
-* '''If..Or statement'''
-* '''Basic statistic functions'''
-* '''Rounding off numbers'''.
 |-
 ||00:19
-||Here, we are using:
+||Here, we are using '''Ubuntu Linux''' version '''10.04''' as our '''operating system''' and '''LibreOffice Suite''' version '''3.3.4'''.
-* '''Ubuntu Linux''' version '''10.04''' as our '''operating system''' and
-* '''LibreOffice Suite''' version '''3.3.4'''.
 |-
@@ Line 47: / Line 41: @@
 |-
 ||01:01
-||Let’s open “Personal-Finance-Tracker.ods”.
+||Let’s open “'''Personal-Finance-Tracker.ods'''”.
 |-
 ||01:05
-||Here, under the heading “Cost”, we have listed the prices of several items.
+||Here, under the heading “'''Cost'''”, we have listed the prices of several items.
 |-
@@ Line 59: / Line 53: @@
 |-
 ||01:17
-||Let’s click on the '''cell''' referenced as “B10” and type “Condition Result” inside it.
+||Let’s click on the '''cell''' referenced as “B10” and type “'''Condition Result'''” inside it.
 |-
 ||01:24
-||Now, click on the '''cell''' referenced as “C10”.
+||Now, click on the '''cell''' referenced as “'''C10'''”.
 |-
@@ Line 75: / Line 69: @@
 |-
 ||01:38
-||The cost for the “Electricity Bill” is rupees 800.
+||The cost for the “'''Electricity Bill'''” is rupees 800.
 |-
 ||01:43
-||The cost of “House Rent” is more than that of “Electricity Bill”.
+||The cost of “'''House Rent'''” is more than that of “'''Electricity Bill'''”.
 |-
@@ Line 95: / Line 89: @@
 |-
 ||02:09
-||Since the value in cell 'C3' is greater than the value in cell 'C4', the result we get is '''“TRUE”'''.
+||Since the value in cell '''C3''' is greater than the value in cell 'C4', the result we get is '''“TRUE”'''.
 |-
@@ Line 107: / Line 101: @@
 |-
 ||02:28
-||The result we get is '''“FALSE”'''.
+||The result we get is '''FALSE'''.
 |-
@@ Line 127: / Line 121: @@
 |-
 ||02:55
-||Let’s click on the cell referenced as “C10” and type:
+||Let’s click on the cell referenced as '''“C10”''' and type:
 |-
@@ Line 139: / Line 133: @@
 |-
 ||03:25
-||or else “Negative” will be displayed.
+||or else “'''Negative'''” will be displayed.
 |-
@@ Line 163: / Line 157: @@
 |-
 ||04:04
-||The result which is displayed now is '''“Negative”'''.
+||The result which is displayed now is '''Negative'''.
 |-
@@ Line 195: / Line 189: @@
 |-
 ||04:43
-||Basic arithmetic functions include:
+||Basic arithmetic functions include:'''SUM''' for addition,'''PRODUCT''' for multiplication,'''QUOTIENT''' for division and many more which we have already learnt in the earlier tutorials.
-* '''SUM''' for addition,
-* '''PRODUCT''' for multiplication,
-* '''QUOTIENT''' for division and many more which we have already learnt in the earlier tutorials.
 |-
@@ Line 214: / Line 205: @@
 |-
 |05:19
-||Click on the cell “A4” and type “SUM”.
+||Click on the cell '''A4''' and type '''SUM'''.
 |-
 ||05:23
-||Click on the cell “B4”.
+||Click on the cell '''B4'''.
 |-
@@ Line 242: / Line 233: @@
 |-
 ||05:47
-||Click on “B4” again.
+||Click on '''B4''' again.
 |-
@@ Line 314: / Line 305: @@
 |-
 ||07:09
-||Statistical functions are useful for analysis of data in spreadsheets.
+||Statistical functions are useful for analysis of data in spreadsheets.For example-functions like '''COUNT, MIN, MAX, MEDIAN, MODE''' and many more are statistical in nature.
 For example-functions like '''COUNT, MIN, MAX, MEDIAN, MODE''' and many more are statistical in nature.
 |-
@@ Line 398: / Line 388: @@
 |-
 ||09:09
-||We shall change:
+||We shall change:“6000” to “6000.34”“600” to “600.4”, ”300” to “300.3”.
-−
-“6000” to “6000.34”
-−
-“600” to “600.4”, ”300” to “300.3”.
 |-
@@ Line 486: / Line 472: @@
 |-
 ||11:43
-||To summarize, we learned about:
+||To summarize, we learned about: '''Conditional Operator''' '''If..Or statement''' Basic '''statistic functions''' '''Rounding off''' numbers.
-−
-* '''Conditional Operator'''
-−
-* '''If..Or statement'''
-−
-* Basic '''statistic functions'''
-−
-* '''Rounding off''' numbers.
 |-
@@ Line 514: / Line 492: @@
 |-
 ||12:08
-||* Conducts workshops using spoken tutorials.
+||Conducts workshops using spoken tutorials.
 |-
 ||12:11
-||* Gives certificates for those who pass an online test.
+||Gives certificates for those who pass an online test.
 |-
 ||12:15
-||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 543: / Line 520: @@
 |-
 ||12:45
-||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.
+||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd. Thanks for joining.
 Thanks for joining.

@@ Line 175: / Line 175: @@
 |-
 ||04:22
-||Again, let’s decrease the value in cell '''C4''' to “800”.
+||Again, let’s decrease the value in cell '''C4''' to “800”
 |-
 ||04:26
-||And press the '''Enter''' key.
+||and press the '''Enter''' key.
 |-
@@ Line 226: / Line 226: @@
 |-
 ||05:30
-||Type '''is equal to “SUM”''' and within the braces '''B1 comma B2 comma B3'''.
+||Type: '''is equal to “SUM”''' and within the braces '''B1 comma B2 comma B3'''.
 |-
@@ Line 258: / Line 258: @@
 |-
 ||06:03
-||Now, let’s click on the cell “A5” and type “PRODUCT”.
+||Now, let’s click on the cell “A5” and type: “PRODUCT”.
 |-
@@ Line 266: / Line 266: @@
 |-
 ||06:10
-||Here, type '''is equal to “PRODUCT”''' and within the braces, '''B1 colon B3'''.
+||Here, type: '''is equal to “PRODUCT”''' and within the braces, '''B1 colon B3'''.
 |-
@@ Line 274: / Line 274: @@
 |-
 ||06:20
-||Notice the result shows “7,50,000”.
+||Notice, the result shows “7,50,000”.
 |-
@@ Line 282: / Line 282: @@
 |-
 ||06:29
-||Click on the cell referenced “A6” and type “QUOTIENT”.
+||Click on the cell referenced “A6” and type: “QUOTIENT”.
 |-
@@ Line 347: / Line 347: @@
 |-
 ||08:00
-||In the cell “C10”, let’s type '''is equal to MAX''' and within braces '''C3 colon C7'''.
+||In the cell “C10”, let’s type: '''is equal to MAX''' and within braces '''C3 colon C7'''.
 |-
 ||08:10
-||Now press the '''Enter''' key.
+||Now, press the '''Enter''' key.
 |-
@@ Line 359: / Line 359: @@
 |-
 ||08:20
-||Now, let’s replace the term “MAX” in the statement with “MIN”.
+||Now, let’s replace the term “MAX” in the statement with “MIN”
 |-
 ||08:25
-||And press the '''Enter''' key.
+||and press the '''Enter''' key.
 |-
@@ Line 371: / Line 371: @@
 |-
 ||08:34
-||To find the median value, replace the term “MIN” with “MEDIAN”.
+||To find the median value, replace the term “MIN” with “MEDIAN”
-−
 |-
 ||08:40
-||And press the '''Enter''' key.
+||and press the '''Enter''' key.
 |-
@@ Line 415: / Line 414: @@
 |-
 ||09:39
-||In the cell '''C11''', let’s type '''is equal to SUM''' and within braces '''C3 colon C7'''.
+||In the cell '''C11''', let’s type: '''is equal to SUM''' and within braces '''C3 colon C7'''.
 |-
@@ Line 447: / Line 446: @@
 |-
 ||10:29
-||You see that the result is now “9701” which is “9701.04” rounded off to the nearest whole number.
+||You see that the result is now “9701” which is “9701.04”, rounded off to the nearest whole number.
 |-
@@ Line 455: / Line 454: @@
 |-
 ||10:52
-||Let’s click on the '''cell''' with the result and '''edit''' the term “ROUND” to “ROUNDUP”.
+||Let’s click on the cell with the result and '''edit''' the term “ROUND” to “ROUNDUP”.
 |-
@@ Line 483: / Line 482: @@
 |-
 ||11:37
-||This brings us to the end of this Spoken Tutorial on LibreOffice Calc.
+||This brings us to the end of this '''Spoken Tutorial''' on '''LibreOffice Calc'''.
 |-
@@ Line 489: / Line 488: @@
 ||To summarize, we learned about:
-* Conditional Operator
+* '''Conditional Operator'''
-* If..Or statement
+* '''If..Or statement'''
-* Basic statistic functions
+* Basic '''statistic functions'''
-* Rounding off numbers.
+* '''Rounding off''' numbers.
 |-
@@ Line 511: / Line 510: @@
 |-
 ||12:06
-||The Spoken Tutorial Project team:
+||The Spoken Tutorial project team:
 |-
@@ Line 524: / Line 523: @@
 ||12:15
 ||For more details, please write to:
-contact at spoken hyphen tutorial dot org.
+'''contact at spoken hyphen tutorial dot org'''.
 |-
@@ Line 540: / Line 539: @@
 |-
 ||12:37
-||spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
+||'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.
 |-

@@ Line 9: / Line 9: @@
 |-
 ||00:00
-||Welcome to the '''Spoken Tutorial''' on '''Formulas and Functions in LibreOffice Calc'''.
+||Welcome to the '''Spoken Tutorial''' on '''Formulas and Functions''' in '''LibreOffice Calc'''.
 |-
@@ Line 17: / Line 17: @@
 * '''If..Or statement'''
 * '''Basic statistic functions'''
-* '''Rounding off numbers'''
+* '''Rounding off numbers'''.
 |-
@@ Line 39: / Line 39: @@
 |-
 ||00:51
-||Conditional Operators:
+||Conditional Operators: check for the condition applied on the data by the user
 check for the condition applied on the data by the user
 |-
@@ Line 72: / Line 71: @@
 |-
 ||01:33
-||Note that the cost of “House Rent” is rupees 6,000.
+||Note that the cost of the “House Rent” is rupees 6,000.
 |-
@@ Line 92: / Line 91: @@
 |-
 ||01:57
-||In this cell, type the first condition as '''is equal to C3 greater than C4 ''' and press the '''Enter''' key.
+||In this cell, type the first condition as: '''is equal to C3 greater than C4 ''' and press the '''Enter''' key.
 |-
 ||02:09
-||Since the value in '''cell 'C3'''' is greater than the value in cell '''C4''', the result we get is '''“TRUE”'''.
+||Since the value in cell 'C3' is greater than the value in cell 'C4', the result we get is '''“TRUE”'''.
 |-
 ||02:18
-||Now, let us change this conditional statement to '''is equal to C3 less than C4'''.
+||Now, let us change this conditional statement to: '''is equal to C3 less than C4'''.
 |-
@@ Line 128: / Line 127: @@
 |-
 ||02:55
-||Let’s click on the '''cell''' referenced as “C10” and type:
+||Let’s click on the cell referenced as “C10” and type:
 |-
@@ Line 144: / Line 143: @@
 |-
 ||03:28
-||Now press '''Enter'''.
+||Now, press '''Enter'''.
 |-

@@ Line 232: / Line 232: @@
 ||05:37
 ||Press '''Enter'''.
 |-
@@ Line 253: / Line 252: @@
 ||05:58
 ||Press '''Enter'''.
 |-

@@ Line 162: / Line 162: @@
 |-
-||3:39
+||03:39
 ||Now, in the condition statement let’s change “greater than” to “less than” and press the “Enter” key.

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