Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Formatting-Data/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
 
 
{|Border=1
 
{|Border=1
 
||'''Time'''
 
||'''Time'''
Line 7: Line 5:
 
|-
 
|-
 
||00:00  
 
||00:00  
||Welcome to the Spoken tutorial on LibreOffice Calc – Formatting Data in Calc.
+
||Welcome to the '''Spoken tutorial''' on '''LibreOffice Calc – Formatting Data in Calc'''.
  
 
|-
 
|-
 
||00:07
 
||00:07
||In this tutorial we will learn about:Formatting Borders, background colors.
+
||In this tutorial, we will learn about: * Formatting '''Borders, background colors'''.
  
 
|-
 
|-
 
||00:14
 
||00:14
||Formatting multiple lines of text using Automatic Wrapping.
+
||Formatting multiple lines of text using '''Automatic Wrapping'''.
  
 
|-
 
|-
 
||00:19
 
||00:19
||Merging Cells.Shrinking text to fit the cell.
+
||Merging Cells, Shrinking text to fit the '''cell'''.
  
 
|-
 
|-
 
||00: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'''.
  
 
|-
 
|-
 
||00:33  
 
||00:33  
||First let us learn about formatting borders in LibreOffice Calc.
+
||First, let us learn about formatting borders in LibreOffice Calc.
  
 
|-
 
|-
Line 35: Line 33:
 
|-
 
|-
 
||00:43
 
||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.
  
 
|-
 
|-
 
||00:49
 
||00:49
||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:00
 
||01:00
||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”'''.
  
 
|-
 
|-
 
||01:07
 
||01:07
||Now hold down the left mouse button and drag it along the cells containing the headings.
+
||Now, hold down the '''left mouse button''' and drag it along the cells containing the headings.
  
 
|-
 
|-
 
||01:13
 
||01:13
||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 71: Line 69:
 
|-
 
|-
 
||01:41
 
||01:41
||Let us undo this change.
+
||Let us '''undo''' this change.
  
 
|-
 
|-
 
||01:44
 
||01:44
||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:53
 
||01:53
||Now click on the “Borders” tab.  
+
||Now click on the '''“Borders”''' tab.  
  
 
|-
 
|-
 
||01:56
 
||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 95: Line 93:
 
|-
 
|-
 
||02:14  
 
||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:21
 
||02:21
||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  
 
||02:29  
||I will also change the “Style”, “Width” and “Color”.
+
||I will also change the '''“Style”, “Width”''' and '''“Color”'''.
  
 
|-
 
|-
 
||02:33
 
||02:33
||Again notice the change in the preview window.
+
||Again, notice the change in the '''preview''' window.
  
 
|-
 
|-
 
||02:37
 
||02:37
||Spacing to contents has the “Synchronize” option checked.  
+
||'''Spacing to contents''' has the '''“Synchronize”''' option checked.  
  
 
|-
 
|-
Line 119: Line 117:
 
|-
 
|-
 
||02:46
 
||02:46
||One can uncheck it and change the margin spacing as per the requirement.  
+
||One can uncheck it and change the '''margin spacing''' as per the requirement.  
  
 
|-
 
|-
 
||02:52
 
||02:52
||I will change “Top” and “Bottom” margins to 1.4pt.
+
||I will change '''“Top”''' and '''“Bottom”''' margins to '''1.4pt'''.
  
 
|-
 
|-
 
||02:59
 
||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.
  
 
|-
 
|-
 
||03:03
 
||03:03
||Click on OK.  
+
||Click on '''OK'''.  
  
 
|-
 
|-
Line 143: Line 141:
 
|-
 
|-
 
||03:17
 
||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'''.
  
 
|-
 
|-
 
||03:27  
 
||03:27  
||Now let us see how it is implemented.
+
||Now, let us see how it is implemented.
  
 
|-
 
|-
Line 155: Line 153:
 
|-
 
|-
 
||03:36
 
||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”.
  
 
|-
 
|-
 
||03:43
 
||03:43
||Now hold down the left mouse button and drag it along the cells containing the headings.
+
||Now hold down the '''left mouse button''' and drag it along the cells containing the headings.
  
 
|-
 
|-
 
||03:49
 
||03:49
||After selecting the entire horizontal row containing the headings, click on the “Background Color” option in the Formatting toolbar.
+
||After selecting the entire horizontal row containing the headings, click on the '''“Background Color”''' option in the Formatting toolbar.
  
 
|-
 
|-
 
||04:00  
 
||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.
  
 
|-
 
|-
 
||04:08  
 
||04:08  
||Let us click on “Grey” color.
+
||Let us click on '''“Grey”''' color.
  
 
|-
 
|-
 
||04:11
 
||04:11
||You can see that the cell background for the headings turns grey.
+
||You can see that the '''cell background''' for the headings turns grey.
  
 
|-
 
|-
 
||04:16
 
||04:16
||Calc provides various options for formatting multiple lines of text.
+
||'''Calc''' provides various options for formatting multiple lines of text.
  
 
|-
 
|-
 
||04:21
 
||04:21
||The first one is by using “Automatic Wrapping”.
+
||The first one is by using '''“Automatic Wrapping”'''.
  
 
|-
 
|-
 
||04:25
 
||04:25
||"Automatic Wrapping” allows a user to enter multiple lines of text into a single cell.
+
||'''"Automatic Wrapping”''' allows a user to enter multiple lines of text into a single cell.
  
 
|-
 
|-
 
||04:32
 
||04:32
||So let us see how it is implemented.
+
||So, let us see how it is implemented.
  
 
|-
 
|-
 
||04:35
 
||04:35
||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 a empty cell.
  
 
|-
 
|-
 
||04:43
 
||04:43
||For example lets click on cell number “B12”.
+
||For example, let's click on cell number “B12”.
  
 
|-
 
|-
 
||04:47
 
||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.
  
 
|-
 
|-
 
||04:53
 
||04:53
||Now click on the “Alignment” tab in the dialog box.
+
||Now, click on the '''“Alignment”''' tab in the '''dialog box'''.
  
 
|-
 
|-
 
||04:57
 
||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
 
||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 223: Line 221:
 
|-
 
|-
 
||05:19
 
||05:19
||Lets undo the changes
+
||Let's '''undo''' the changes.
  
 
|-
 
|-
 
||05:22
 
||05:22
||After learning about “Automatic Wrapping”, we will now learn how to merge cells in Calc.
+
||After learning about '''“Automatic Wrapping”''', we will now learn how to '''merge''' cells in Calc.
  
 
|-
 
|-
 
||05:28
 
||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”.
+
||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  
 
||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 243: Line 241:
 
|-
 
|-
 
||05:59  
 
||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:06
 
||06:06
||In the sidebar which pops up, click on the “Merge Cells” option.
+
||In the sidebar which pops up, click on the '''“Merge Cells”''' option.
  
 
|-
 
|-
 
||06:11
 
||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.
+
||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.
  
 
|-
 
|-
Line 259: Line 257:
 
|-
 
|-
 
||06:29
 
||06:29
||Now let us undo the merging we did by clicking by pressing “CTRL+Z” together.
+
||Now let us '''undo''' the merging we did by pressing '''CTRL+Z''' together.
  
 
|-
 
|-
 
||06:37  
 
||06:37  
||Next we will learn how to shrink text to fit into the cell.
+
||Next, we will learn how to shrink text to fit into the '''cell'''.
  
 
|-
 
|-
Line 275: Line 273:
 
|-
 
|-
 
||06:51
 
||06:51
||Lets type the text “This is for the month of January” in the cell referenced as B14.
+
||Let's type the text “This is for the month of January” in the cell referenced as '''B14'''.
  
 
|-
 
|-
Line 283: Line 281:
 
|-
 
|-
 
||07:03  
 
||07:03  
||In order to shrink the text so that it fits, click on the cell referenced as B14 first.
+
||In order to shrink the text so that it fits, click on the cell referenced as '''B14''' first.
  
 
|-
 
|-
 
||07:10
 
||07:10
||Now click on the “Format” option in the menu bar and then click on “Cells”.  
+
||Now click on the '''Format''' option in the menu bar and then click on '''“Cells”'''.  
  
 
|-
 
|-
 
||07:18
 
||07:18
||Alternately, right-click on the cell and click on “Format Cells”.
+
||Alternately, right-click on the cell and click on '''“Format Cells”'''.
  
 
|-
 
|-
 
||07:23
 
||07:23
||You see that the “Format Cells” dialog box opens.
+
||You see that the “Format Cells” dialog-box opens.
  
 
|-
 
|-
 
||07:27
 
||07:27
||Click on the “Alignment” tab in the dialog box.
+
||Click on the '''“Alignment”''' tab in the dialog-box.
  
 
|-
 
|-
 
||07:32
 
||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.
+
||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
 
||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.
+
||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
 
||07:53
||Lets undo the changes
+
||Let's '''undo''' the changes.
  
 
|-
 
|-
 
||07:56
 
||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'''.
  
 
|-
 
|-
 
||08:01
 
||08:01
||To summarize, we learned about: Formatting Borders, background colors in Calc.
+
||To summarize, we learned about: * Formatting Borders, background colors in Calc.
  
 
|-
 
|-
 
||08:08
 
||08:08
||Formatting multiple lines of text using Automatic Wrapping.
+
||Formatting multiple lines of text using 'Automatic Wrapping'.
  
 
|-
 
|-
 
||08:14
 
||08:14
||Merging Cells. Shrinking text to fit the cell.
+
||Merging Cells, Shrinking text to fit the cell.
  
 
|-
 
|-
 
||08:17
 
||08:17
||COMPREHENSIVE ASSIGNMENT
+
||COMPREHENSIVE ASSIGNMENT-
  
 
|-
 
|-
Line 339: Line 337:
 
|-
 
|-
 
||08:24
 
||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.
+
  
 
|-
 
|-
 
||08:30
 
||08:30
||Using “Automatic Wrapping” type the text, “This is a Department Spreadsheet”.
+
||Using '''“Automatic Wrapping”''', type the text: “This is a Department Spreadsheet”.
  
 
|-
 
|-
 
||08:36
 
||08:36
||Shrink this text to fit in the cell.
+
||Shrink this text to fit in the '''cell'''.
  
 
|-
 
|-
 
||08:39
 
||08:39
||Watch the video available at the following link
+
||Watch the video available at the following link:
  
 
|-
 
|-
 
||08:42
 
||08:42
||It summarises the Spoken Tutorial project
+
||It summarizes the Spoken Tutorial project.
  
 
|-
 
|-
 
||08:45
 
||08:45
||If you do not have good bandwidth, you can download and watch it
+
||If you do not have good bandwidth, you can download and watch it.
  
 
|-
 
|-
 
||08:50
 
||08:50
||The Spoken Tutorial Project Team Conducts workshops using spoken tutorials
+
||The Spoken Tutorial Project team: * Conducts workshops using spoken tutorials.
  
 
|-
 
|-
 
||08:55
 
||08:55
||Gives certificates for those who pass an online test
+
||Gives certificates for those who pass an online test.
  
 
|-
 
|-
 
||08:59
 
||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.
  
 
|-
 
|-
 
||09:05
 
||09:05
||Spoken Tutorial Project is a part of the Talk to a Teacher project
+
||'''Spoken Tutorial''' Project is a part of the '''Talk to a Teacher''' project.
  
 
|-
 
|-
 
||09:10
 
||09:10
||It is supported by the National Mission on Education through ICT, MHRD, Government of India
+
||It is supported by the National Mission on Education through ICT, MHRD, Government of India.
  
 
|-
 
|-
 
||09:18  
 
||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: spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
  
 
|-
 
|-
 
||09:28
 
||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.
+
 
+
  Thanks for joining
+

Latest revision as of 10:50, 27 March 2017

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 GNU/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 color.
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, let's 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 Let's 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 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 Let's 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 Let's 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,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 summarizes 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 DesiCrew Solutions Pvt. Ltd. Thanks for joining.

Contributors and Content Editors

PoojaMoolya, Sandhya.np14