LibreOffice-Suite-Calc/C2/Formatting-Data/English-timed - Revision history

PoojaMoolya at 07:11, 23 March 2017

2017-03-23T07:11:04Z

Pratik kamble at 12:22, 26 October 2016

2016-10-26T12:22:59Z

Pratik kamble at 12:22, 26 October 2016

2016-10-26T12:22:03Z

Sandhya.np14 at 09:58, 7 January 2016

2016-01-07T09:58:19Z

Sandhya.np14 at 09:39, 7 January 2016

2016-01-07T09:39:39Z

Sandhya.np14 at 05:25, 8 October 2015

2015-10-08T05:25:24Z

Show changes

Pratik kamble at 12:04, 9 February 2015

2015-02-09T12:04:47Z

Pratik kamble at 09:51, 9 July 2014

2014-07-09T09:51:28Z

Minal: Created page with ''''Resources for recording''' Formatting Data {|Border=1 ||Time ||NARRATION |- ||00:00 ||Welcome to the Spoken tutorial on LibreOffice Calc – …'

2012-12-27T10:46:50Z

Created page with ''''Resources for recording''' Formatting Data {|Border=1 ||Time ||NARRATION |- ||00:00 ||Welcome to the Spoken tutorial on LibreOffice Calc – …'

New page

'''Resources for recording'''
[[Media:Formatting Data.zip |Formatting Data]]

{|Border=1
||Time
||NARRATION

|-
||00:00
||Welcome to the Spoken tutorial on LibreOffice Calc – Formatting Data in Calc.

|-
||00:06
||In this tutorial we will learn about:Formatting Borders, background colors.

|-
||00:12
||Formatting multiple lines of text using Automatic Wrapping.

|-
||00:18
||Merging Cells.Shrinking text to fit the cell.

|-
||00:22
||Here we are using Ubuntu Linux version 10.04 as our operating system and LibreOffice Suite version 3.3.4.

|-
||00:33
||First let us learn about formatting borders in LibreOffice Calc.

|-
||00:39
||Let us open our “personal finance tracker.ods” file.

|-
||00:45
||Formatting of borders can be done on a particular cell or a block of cells.

|-
||00:50
||For example, let us format the cells with the headings “Serial Number”, “Item”, “Cost”, “Spent”, ”Received”, ”Date”and ”Account”.

|-
||01:01
||So let us first click on the cell with the heading Serial Number, denoted by “SN”.

|-
||01:08
||Now hold down the left mouse button and drag it along the cells containing the headings.

|-
||01:14
||After selecting the entire horizontal row containing the headings, click on the “Borders” icon on the Formatting toolbar.

|-
||01:23
||A drop down box opens up containing several border styles.

|-
||01:28
||Click on one of the styles you want to apply on the borders.

|-
||01:33
||I will click on the last option.

|-
||01:34
||We see that the borders get formatted according to our selected style.

|-
||01:39
||Let us undo this change.

|-
||01:45
||The selected cells are still highlighted.Right-click on the selection and choose “Format Cells” option.

|-
||01:54
||Now click on the “Borders” tab.

|-
||01:56
||You will see the options for “Line arrangement”, “Line”, “Spacing to contents” and “Shadow style”.

|-
||02:05
||Displayed in each of these are the default settings of Calc.

|-
||02:10
||But one can change any of these to suit our requirement.

|-
||02:14
||Under “User-defined”, you can see a small preview window which displays the selection.

|-
||02:22
||I will choose the third option under “Default” and you can see that it is reflected in the preview window.

|-
||02:29
||I will also change the “Style”, “Width” and “Color”.

|-
||02:33
||Again notice the change in the preview window.

|-
||02:38
||Spacing to contents has the “Synchronize” option checked.

|-
||02:42
||This means that the same spacing is applied to all the margins.

|-
||02:47
||One can uncheck it and change the margin spacing as per the requirement.

|-
||02:53
||I will change “Top” and “Bottom” margins to 1.4pt.

|-
||03:00
||I will leave you to explore the various Shadow styles, on your own.

|-
||03:04
||Click on OK.

|-
||03:06
||This will apply the chosen style to the selected cells.

|-
||03:11
||After learning how to format borders, now let us learn how to give background colors to cells.

|-
||03:18
||In order to give background colors to cells, Calc provides an option called “Background Color”, located in the Formatting toolbar.

|-
||03:27
||Now let us see how it is implemented.

|-
||03:30
||For example, let us give a background color to the cells containing the headings.

|-
||03:36
||So let us first click on the cell which contains the heading Serial Number, denoted by “SN”.

|-
||03:44
||Now hold down the left mouse button and drag it along the cells containing the headings.

|-
||03:50
||After selecting the entire horizontal row containing the headings, click on the “Background Color” option in the Formatting to::olbar.

|-
||04:00
||A pop up menu opens up where you can select the color you want to apply as a background.

|-
||04:08
||Let us click on “Grey” color.

|-
||04:11
||You can see that the cell background for the headings turns grey.

|-
||04:17
||Calc provides various options for formatting multiple lines of text.

|-
||04:22
||The first one is by using “Automatic Wrapping”.

|-
||04:26
||"Automatic Wrapping” allows a user to enter multiple lines of text into a single cell.

|-
||04:33
||So let us see how it is implemented.

|-
||04:37
||Now in our “personal finance tracker.ods” sheet, let us click on a empty cell.

|-
||04:44
||For example lets click on cell number “B12”.

|-
||04:49
||Now do a right click on cell and then click on the “Format Cells” option.

|-
||04:54
||Now click on the “Alignment” tab in the dialog box.

|-
||04:58
||At the bottom of the dialog box click on the “Wrap text automatically” option and then click on the “OK” button.

|-
||05:08
||Now we type “THIS IS A PERSONAL FINANCE TRACKER. IT IS VERY USEFUL”.

|-
||05:11
||You see that the multiple statements get wrapped in a single cell.

|-
||05:19
||Lets undo the changes

|-
||05:21
||After learning about “Automatic Wrapping”, we will now learn how to merge cells in Calc.

|-
||05:29
||In our “personal finance tracker.ods” file , if we want to merge cells containing the Serial Number with the heading “SN” and their corresponding items, then first click on the data entry '1' under the heading “SN”.

|-
||05:46
||Now hold down the “Shift” key on the keyboard and click on the cell with its corresponding item, “Salary”.

|-
||05:55
||This highlights the two cells that are to be merged.

|-
||05:59
||Next click on the “Format” option in the menu bar and then click on the “Merge Cells” option.

|-
||06:07
||In the sidebar which pops up, click on the “Merge Cells” option.

|-
||06:12
||In order to move the contents of both the cells in a single cell, click on the “Yes” option in the dialog box which appears.

|-
||06:21
||You see that the selected cells get merged into one and the contents are also within the same merged cell.

|-
||06:31
||Now let us undo the merging we did by clicking by pressing “CTRL+Z” together.

|-
||06:37
||Next we will learn how to shrink text to fit into the cell.

|-
||06:41
||The font size of the data in a cell can be automatically adjusted to fit into a cell.

|-
||06:49
||Let us learn how to do it.

|-
||06:50
||Lets type the text “This is for the month of January” in the cell referenced as B14.

|-
||07:00
||You see that the text doesn't fit into the cell.

|-
||07:03
||In order to shrink the text so that it fits, click on the cell referenced as B14 first.

|-
||07:11
||Now click on the “Format” option in the menu bar and then click on “Cells”.

|-
||07:18
||Alternately, right-click on the cell and click on “Format Cells”.

|-
||07:24
||You see that the “Format Cells” dialog box opens.

|-
||07:28
||Click on the “Alignment” tab in the dialog box.

|-
||07:31
||At the bottom of the dialog box, click on the “Shrink to fit cell size” check-box and then click on the “OK” button.

|-
||07:41
||You see that the entire text shrinks and adjusts itself by decreasing its font size so that the text fits into the cell referenced as B14.

|-
||07:54
||Lets undo the changes

|-
||07:57
||This brings us to the end of the Spoken Tutorial on LibreOffice Calc.

|-
||08:02
||To summarize, we learned about: Formatting Borders, background colors in Calc.

|-
||08:09
||Formatting multiple lines of text using Automatic Wrapping.

|-
||08:14
||Merging Cells. Shrinking text to fit the cell.

|-
||08:19
||COMPREHENSIVE ASSIGNMENT

|-
||08:21
||Open “spreadsheet practice.ods” sheet.

|-
||08:25
||Select all the headings.

|-
||08:27
||Give the background color to the headings as blue.

|-
||08:31
||Using “Automatic Wrapping” type the text, “This is a Department Spreadsheet”.

|-
||08:37
||Shrink this text to fit in the cell.

|-
||08:40
||Watch the video available at the following link

|-
||08:43
||It summarises the Spoken Tutorial project

|-
||08:46
||If you do not have good bandwidth, you can download and watch it

|-
||08:51
||The Spoken Tutorial Project Team Conducts workshops using spoken tutorials

|-
||08:56
||Gives certificates for those who pass an online test

|-
||09:00
||For more details, please write to contact at spoken hyphen tutorial dot org

|-
||09:06
||Spoken Tutorial Project is a part of the Talk to a Teacher project

|-
||09:11
||It is supported by the National Mission on Education through ICT, MHRD, Government of India

|-
||09:18
||More information on this Mission is available at spoken hyphen tutorial dot org slash NMEICT hyphen Intro

|-
||09:29
||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.

Thanks for joining

@@ Line 64: / Line 64: @@
 |-
 ||01:33
-||I will click on the last option.
+||I will click on the last option,We see that the borders get formatted according to  our selected style.
-−
-|-
-||01:34
-||We see that the borders get formatted according to  our selected style.
 |-
@@ Line 272: / Line 268: @@
 |-
 ||06:49
-||Let us learn how to do it.
+||Let us learn how to do it,Let's type the text “This is for the month of January” in the cell referenced as '''B14'''.
-−
-|-
-||06:50
-||Let's type the text “This is for the month of January” in the cell referenced as '''B14'''.
 |-

@@ Line 3: / Line 3: @@
 {|Border=1
-||Time
+||'''Time'''
-||NARRATION
+||'''Narration'''
 |-

@@ Line 12: / Line 12: @@
 |-
 ||00:06
-||In this tutorial, we will learn about: * Formatting borders, background colors
+||In this tutorial, we will learn about: Formatting borders, background colors
 |-
@@ Line 20: / Line 20: @@
 |-
 ||00:18
-||Merging Cells  * Shrinking text to fit the cell.
+||Merging Cells  Shrinking text to fit the cell.
 |-
@@ Line 32: / Line 32: @@
 |-
 ||00:39
-||Let us open our '''personal finance tracker.ods''' file.
+||Let us open our "personal finance tracker.ods" file.
 |-
@@ Line 172: / Line 172: @@
 |-
 ||04:08
-||Let us click on '''Grey''' color.
+||Let us click on “Grey” color.
 |-
@@ Line 196: / Line 196: @@
 |-
 ||04:37
-||Now, in our '''personal finance tracker.ods''' sheet, let us click on an empty cell.
+||Now, in our “personal finance tracker.ods” sheet, let us click on an empty cell.
 |-
@@ Line 216: / Line 216: @@
 |-
 ||05:08
-||Now, we type '''THIS IS A PERSONAL FINANCE TRACKER. IT IS VERY USEFUL'''.
+||Now, we type “THIS IS A PERSONAL FINANCE TRACKER. IT IS VERY USEFUL”.
 |-
@@ Line 232: / Line 232: @@
 |-
 ||05:29
-||In our '''personal finance tracker.ods''' file , if we want to merge cells containing the '''Serial Number''' with the heading “SN” and their corresponding items, then first click on the data entry '1' under the heading “SN”.
+||In our “personal finance tracker.ods” file , if we want to merge cells containing the '''Serial Number''' with the heading “SN” and their corresponding items, then first click on the data entry '1' under the heading “SN”.
 |-
@@ Line 244: / Line 244: @@
 |-
 ||05:59
-||Next, click on the '''“Format”''' option in the menu bar and then click on the '''Merge Cells''' option.
+||Next, click on the '''“Format”''' option in the menu bar and then click on the '''“Merge Cells”''' option.
 |-
 ||06:07
-||In the sidebar which pops-up, click on the '''Merge Cells''' option.
+||In the sidebar which pops-up, click on the '''“Merge Cells”''' option.
 |-
@@ Line 328: / Line 328: @@
 |-
 ||08:14
-||Merging Cells. Shrinking text to fit the cell.
+||Merging Cells. * Shrinking text to fit the cell.
 |-
@@ Line 336: / Line 336: @@
 |-
 ||08:21
-||Open '''spreadsheet practice.ods''' sheet.
+||Open “spreadsheet practice.ods” sheet.
 |-
@@ Line 348: / Line 348: @@
 |-
 ||08:31
-||Using '''Automatic Wrapping''', type the text: “This is a Department Spreadsheet”.
+||Using “Automatic Wrapping”, type the text: “This is a Department Spreadsheet”.
 |-
@@ Line 368: / Line 368: @@
 |-
 ||08:51
-||The '''Spoken Tutorial''' project team: * Conducts workshops using spoken tutorials.
+||The '''Spoken Tutorial''' project team: Conducts workshops using spoken tutorials.
 |-

@@ Line 236: / Line 236: @@
 |-
 ||05:46
-||Now hold down the '''Shift''' key on the keyboard and click on the '''cell''' with its corresponding item, '''“Salary”'''.
+||Now, hold down the '''Shift''' key on the keyboard and click on the '''cell''' with its corresponding item, '''“Salary”'''.
 |-
@@ Line 260: / Line 260: @@
 |-
 ||06:31
-||Now let us '''undo''' the merging we did by clicking by pressing '''Ctrl+Z''' together.
+||Now, let us '''undo''' the merging we did by clicking on '''Ctrl+Z''' together.
 |-
@@ Line 268: / Line 268: @@
 |-
 ||06:41
-||The font size of the data in a cell can be automatically adjusted to fit into a cell.
+||The '''font size''' of the data in a cell can be automatically adjusted to fit into a cell.
 |-
@@ Line 316: / Line 316: @@
 |-
 ||07:57
-||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 324: / Line 324: @@
 |-
 ||08:09
-||* Formatting multiple lines of text using Automatic Wrapping.
+||* Formatting multiple lines of text using '''Automatic Wrapping'''.
 |-
@@ Line 368: / Line 368: @@
 |-
 ||08:51
-||The '''Spoken Tutorial''' Project team: * Conducts workshops using spoken tutorials.
+||The '''Spoken Tutorial''' project team: * Conducts workshops using spoken tutorials.
 |-
@@ Line 376: / Line 376: @@
 |-
 ||09:00
-||For more details, please write to: contact at spoken hyphen tutorial dot org.
+||For more details, please write to:
 |-
@@ Line 388: / Line 389: @@
 |-
 ||09:18
-||More information on this mission is available at: spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
+||More information on this mission is available at:
 |-

@@ Line 32: / Line 32: @@
 |-
 ||00:39
-||Let us open our ''''personal finance tracker.ods'''' file.
+||Let us open our "personal finance tracker.ods" file.
 |-
@@ Line 44: / Line 44: @@
 |-
 ||01:01
-||So, let us first click on the '''cell''' with the heading "Serial Number", denoted by '''SN'''.
+||So, let us first click on the '''cell''' with the heading "Serial Number", denoted by "SN".
 |-
@@ Line 80: / Line 80: @@
 |-
 ||01:54
-||Now click on the '''Borders''' tab.
+||Now, click on the '''Borders''' tab.
 |-
@@ Line 112: / Line 112: @@
 |-
 ||02:38
-||Spacing to contents has the '''Synchronize''' option checked.
+||'''Spacing to contents''' has the '''Synchronize''' option checked.
 |-
@@ Line 144: / Line 144: @@
 |-
 ||03:18
-||In order to give background colors to cells, '''Calc''' provides an option called '''Background Color''', located in the Formatting toolbar.
+||In order to give '''background color'''s to cells, '''Calc''' provides an option called '''Background Color''', located in the '''Formatting toolbar'''.
 |-
 ||03:27
-||Now let us see how it is implemented.
+||Now, let us see how it is implemented.
 |-
@@ Line 156: / Line 156: @@
 |-
 ||03:36
-||So, let us first click on the '''cell''' which contains the heading "Serial Number", denoted by '''SN'''.
+||So, let us first click on the '''cell''' which contains the heading "Serial Number", denoted by "SN".
 |-
@@ Line 196: / Line 196: @@
 |-
 ||04:37
-||Now, in our “personal finance tracker.ods” sheet, let us click on a empty cell.
+||Now, in our “personal finance tracker.ods” sheet, let us click on an empty cell.
 |-
@@ Line 208: / Line 208: @@
 |-
 ||04:54
-||Now click on the '''“Alignment”''' tab, in the dialog-box.
+||Now, click on the '''“Alignment”''' tab, in the dialog-box.
 |-
@@ Line 232: / Line 232: @@
 |-
 ||05:29
-||In our “personal finance tracker.ods” file , if we want to merge cells containing the 'Serial Number' with the heading “SN” and their corresponding items, then first click on the data entry '1' under the heading '''“SN”'''.
+||In our “personal finance tracker.ods” file , if we want to merge cells containing the '''Serial Number''' with the heading “SN” and their corresponding items, then first click on the data entry '1' under the heading “SN”.
 |-

@@ Line 24: / Line 24: @@
 |-
 ||00:22
-||Here we are using Ubuntu Linux version 10.04 as our operating system and LibreOffice Suite version 3.3.4.
+||Here we are using '''Ubuntu Linux''' version 10.04 as our operating system and '''LibreOffice Suite''' version 3.3.4.
 |-
 ||00:33
-||First let us learn about formatting borders in LibreOffice Calc.
+||First let us learn about formatting borders in '''LibreOffice Calc'''.
 |-
 ||00:39
-||Let us open our “personal finance tracker.ods” file.
+||Let us open our '''personal finance tracker.ods''' file.
 |-
@@ Line 40: / Line 40: @@
 |-
 ||00:50
-||For example, let us format the cells with the headings “Serial Number”, “Item”, “Cost”, “Spent”, ”Received”, ”Date”and ”Account”.
+||For example, let us format the cells with the headings '''Serial Number''', '''Item''', '''Cost''', '''Spent''', '''Received''', '''Date''' and '''Account'''.
 |-
 ||01:01
-||So let us first click on the cell with the heading Serial Number, denoted by “SN”.
+||So let us first click on the cell with the heading Serial Number, denoted by '''SN'''.
 |-
@@ Line 52: / Line 52: @@
 |-
 ||01:14
-||After selecting the entire horizontal row containing the headings, click on the “Borders” icon on the Formatting toolbar.
+||After selecting the entire horizontal row containing the headings, click on the '''Borders''' icon on the Formatting toolbar.
 |-
@@ Line 76: / Line 76: @@
 |-
 ||01:45
-||The selected cells are still highlighted.Right-click on the selection and choose “Format Cells” option.
+||The selected cells are still highlighted.Right-click on the selection and choose '''Format Cells''' option.
 |-
 ||01:54
-||Now click on the “Borders” tab.
+||Now click on the '''Borders''' tab.
 |-
 ||01:56
-||You will see the options for “Line arrangement”, “Line”, “Spacing to contents” and “Shadow style”.
+||You will see the options for '''Line arrangement''', '''Line''', '''Spacing to contents''' and '''Shadow style'''.
 |-
@@ Line 96: / Line 96: @@
 |-
 ||02:14
-||Under “User-defined”, you can see a small preview window which displays the selection.
+||Under '''User-defined''', you can see a small preview window which displays the selection.
 |-
 ||02:22
-||I will choose the third option under “Default” and you can see that it is reflected in the preview window.
+||I will choose the third option under '''Default''' and you can see that it is reflected in the preview window.
 |-
 ||02:29
-||I will also change the “Style”, “Width” and “Color”.
+||I will also change the '''Style''', '''Width''' and '''Color'''.
 |-
@@ Line 112: / Line 112: @@
 |-
 ||02:38
-||Spacing to contents has the “Synchronize” option checked.
+||Spacing to contents has the '''Synchronize''' option checked.
 |-
@@ Line 124: / Line 124: @@
 |-
 ||02:53
-||I will change “Top” and “Bottom” margins to 1.4pt.
+||I will change '''Top''' and '''Bottom''' margins to '''1.4pt'''.
 |-
@@ Line 132: / Line 132: @@
 |-
 ||03:04
-||Click on OK.
+||Click on '''OK'''.
 |-
@@ Line 144: / Line 144: @@
 |-
 ||03:18
-||In order to give background colors to cells, Calc provides an option called “Background Color”, located in the Formatting toolbar.
+||In order to give background colors to cells, Calc provides an option called '''Background Color''', located in the Formatting toolbar.
 |-
@@ Line 156: / Line 156: @@
 |-
 ||03:36
-||So let us first click on the cell which contains the heading Serial Number, denoted by “SN”.
+||So let us first click on the cell which contains the heading Serial Number, denoted by '''SN'''.
 |-