LibreOffice-Calc-on-BOSS-Linux/C2/Formatting-Data/English-timed - Revision history

PoojaMoolya at 05:20, 27 March 2017

2017-03-27T05:20:37Z

Sandhya.np14 at 06:14, 5 September 2015

2015-09-05T06:14:26Z

Sandhya.np14 at 09:28, 17 August 2015

2015-08-17T09:28:18Z

Show changes

Sandhya.np14 at 06:47, 17 August 2015

2015-08-17T06:47:55Z

Show changes

PoojaMoolya at 04:57, 19 January 2015

2015-01-19T04:57:17Z

Show changes

PoojaMoolya at 04:56, 19 January 2015

2015-01-19T04:56:56Z

Show changes

PoojaMoolya at 04:56, 19 January 2015

2015-01-19T04:56:21Z

PoojaMoolya at 04:54, 19 January 2015

2015-01-19T04:54:10Z

Show changes

PoojaMoolya at 04:53, 19 January 2015

2015-01-19T04:53:56Z

Show changes

PoojaMoolya: Created page with " {|Border=1 ||'''Time''' ||'''Narration''' |- ||00:00 ||Welcome to the Spoken tutorial on LibreOffice Calc – Formatting Data in Calc. |- ||00:07 ||In this tutorial we wi..."

2015-01-01T05:58:10Z

Created page with " {|Border=1 ||'''Time''' ||'''Narration''' |- ||00:00 ||Welcome to the Spoken tutorial on LibreOffice Calc – Formatting Data in Calc. |- ||00:07 ||In this tutorial we wi..."

New page

{|Border=1
||'''Time'''
||'''Narration'''

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

|-
||02:08
||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:21
||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:37
||Spacing to contents has the “Synchronize” option checked.

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

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

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

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

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

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

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

|-
||03:17
||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:43
||Now hold down the left mouse button and drag it along the cells containing the headings.

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

|-
||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:16
||Calc provides various options for formatting multiple lines of text.

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

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

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

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

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

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

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

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

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

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

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

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

|-
||05:28
||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:06
||In the sidebar which pops up, click on the “Merge Cells” option.

|-
||06:11
||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:29
||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:42
||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:51
||Lets type the text “This is for the month of January” in the cell referenced as B14.

|-
||06:59
||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:10
||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:23
||You see that the “Format Cells” dialog box opens.

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

|-
||07:32
||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:53
||Lets undo the changes

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

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

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

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

|-
||08:17
||COMPREHENSIVE ASSIGNMENT

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

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

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

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

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

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

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

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

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

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

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

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

|-
||09:10
||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:28
||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 23: / Line 23: @@
 |-
 ||00:23
-||Here we are using Ubuntu Linux  as our operating system and LibreOffice Suite version 3.3.4.
+||Here we are using GNU/Linux  as our operating system and LibreOffice Suite version 3.3.4.
 |-

@@ Line 1: / Line 1: @@
 {|Border=1
 ||'''Time'''
@@ Line 15: / Line 13: @@
 |-
 ||00:14
-||* Formatting multiple lines of text using '''Automatic Wrapping'''.
+||Formatting multiple lines of text using '''Automatic Wrapping'''.
 |-
 ||00:19
-||* Merging Cells, Shrinking text to fit the '''cell'''.
+||Merging Cells, Shrinking text to fit the '''cell'''.
 |-
@@ Line 323: / Line 321: @@
 |-
 ||08:08
-||* Formatting multiple lines of text using 'Automatic Wrapping'.
+||Formatting multiple lines of text using 'Automatic Wrapping'.
 |-
 ||08:14
-||* Merging Cells, Shrinking text to fit the cell.
+||Merging Cells, Shrinking text to fit the cell.
 |-
@@ Line 339: / Line 337: @@
 |-
 ||08:24
-||Select all the headings.
+||Select all the headings,Give the background color to the headings as blue.
-−
-|-
-||08:25
-||Give the background color to the headings as blue.
 |-
@@ Line 371: / Line 365: @@
 |-
 ||08:55
-||* Gives certificates for those who pass an online test.
+||Gives certificates for those who pass an online test.
 |-

@@ Line 35: / Line 35: @@
 |-
 ||00:43
-||Formatting of borders can be done on a particular '''cell''' or a block of cells.
+||Formatting of borders can be done on a particular '''cell''' or a '''block''' of cells.
 |-
@@ Line 127: / Line 127: @@
 |-
 ||02:59
-||I will leave you to explore the various '''Shadow styles''', on your own.
+||I will leave you to explore the various '''Shadow style'''s, on your own.
 |-
@@ Line 143: / Line 143: @@
 |-
 ||03:17
-||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 167: / Line 167: @@
 |-
 ||04:00
-||A pop-up menu opens up where you can select the color you want to apply as a background.
+||A pop-up menu opens up where you can select the color you want to apply as a background color.
 |-
@@ Line 179: / Line 179: @@
 |-
 ||04:16
-||Calc provides various options for formatting multiple lines of text.
+||'''Calc''' provides various options for formatting multiple lines of text.
 |-
@@ Line 199: / Line 199: @@
 |-
 ||04:43
-||For example lets click on cell number “B12”.
+||For example, let's click on cell number “B12”.
 |-
 ||04:47
-||Now, do a right click on cell and then click on the '''“Format Cells”''' option.
+||Now, do a right-click on cell and then click on the '''“Format Cells”''' option.
 |-
@@ Line 211: / Line 211: @@
 |-
 ||04:57
-||At the bottom of the dialog box, click on the '''“Wrap text automatically”''' option and then click on the '''“OK”''' button.
+||At the bottom of the dialog box, click on the '''“Wrap text automatically”''' option and then click on the '''OK''' button.
 |-
 ||05:06
-||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 311: / Line 311: @@
 |-
 ||07:53
-||Let's undo the changes.
+||Let's '''undo''' the changes.
 |-
 ||07:56
-||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 323: / Line 323: @@
 |-
 ||08:08
-||* Formatting multiple lines of text using Automatic Wrapping.
+||* Formatting multiple lines of text using 'Automatic Wrapping'.
 |-
@@ Line 351: / Line 351: @@
 |-
 ||08:36
-||Shrink this text to fit in the cell.
+||Shrink this text to fit in the '''cell'''.
 |-
@@ Line 359: / Line 359: @@
 |-
 ||08:42
-||It summarizes the Spoken Tutorial project
+||It summarizes the Spoken Tutorial project.
 |-
@@ Line 367: / Line 367: @@
 |-
 ||08:50
-||The Spoken Tutorial Project Team: * Conducts workshops using spoken tutorials.
+||The Spoken Tutorial Project team: * Conducts workshops using spoken tutorials.
 |-
@@ Line 375: / Line 375: @@
 |-
 ||08:59
-||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 391: / Line 391: @@
 |-
 ||09:28
-||This tutorial has been contributed by ...............................(Name of the translator and narrator).
+||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd. Thanks for joining.
-And this is -----------------------(name of the recorder) from --------------------------(name of the place) signing off. Thanks for watching.