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

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 35: Line 35:
 
|-
 
|-
 
||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.
  
 
|-
 
|-
Line 127: Line 127:
 
|-
 
|-
 
||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.
  
 
|-
 
|-
Line 143: Line 143:
 
|-
 
|-
 
||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'''.
  
 
|-
 
|-
Line 167: Line 167:
 
|-
 
|-
 
||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.
  
 
|-
 
|-
Line 179: Line 179:
 
|-
 
|-
 
||04:16
 
||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
 
||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.
  
 
|-
 
|-
Line 211: Line 211:
 
|-
 
|-
 
||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 311: Line 311:
 
|-
 
|-
 
||07:53
 
||07:53
−
||Let's 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'''.
  
 
|-
 
|-
Line 323: Line 323:
 
|-
 
|-
 
||08:08
 
||08:08
−
||* Formatting multiple lines of text using Automatic Wrapping.
+
||* Formatting multiple lines of text using 'Automatic Wrapping'.
  
 
|-
 
|-
Line 351: Line 351:
 
|-
 
|-
 
||08:36
 
||08:36
−
||Shrink this text to fit in the cell.
+
||Shrink this text to fit in the '''cell'''.
  
 
|-
 
|-
Line 359: Line 359:
 
|-
 
|-
 
||08:42
 
||08:42
−
||It summarizes the Spoken Tutorial project
+
||It summarizes the Spoken Tutorial project.
  
 
|-
 
|-
Line 367: Line 367:
 
|-
 
|-
 
||08:50
 
||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
 
||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
 
||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.
+

Revision as of 11:44, 5 September 2015


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.
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 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

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice-Calc-on-BOSS-Linux/C2/Formatting-Data/English-timed&oldid=23471"