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

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.
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	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 ...............................(Name of the translator and narrator). And this is -----------------------(name of the recorder) from --------------------------(name of the place) signing off. Thanks for watching.

Contributors and Content Editors

PoojaMoolya, Sandhya.np14