Difference between revisions of "LibreOffice-Suite-Calc/C2/Formatting-Data/English-timed"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 12: | Line 12: | ||
|- | |- | ||
||00:06 | ||00:06 | ||
| − | ||In this tutorial, we will learn about: | + | ||In this tutorial, we will learn about: Formatting borders, background colors |
|- | |- | ||
| Line 20: | Line 20: | ||
|- | |- | ||
||00:18 | ||00:18 | ||
| − | ||Merging Cells | + | ||Merging Cells Shrinking text to fit the cell. |
|- | |- | ||
| Line 32: | Line 32: | ||
|- | |- | ||
||00:39 | ||00:39 | ||
| − | ||Let us open our | + | ||Let us open our "personal finance tracker.ods" file. |
|- | |- | ||
| Line 64: | Line 64: | ||
|- | |- | ||
||01:33 | ||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. |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| Line 172: | Line 168: | ||
|- | |- | ||
||04:08 | ||04:08 | ||
| − | ||Let us click on | + | ||Let us click on “Grey” color. |
|- | |- | ||
| Line 196: | Line 192: | ||
|- | |- | ||
||04:37 | ||04:37 | ||
| − | ||Now, in our | + | ||Now, in our “personal finance tracker.ods” sheet, let us click on an empty cell. |
|- | |- | ||
| Line 216: | Line 212: | ||
|- | |- | ||
||05:08 | ||05:08 | ||
| − | ||Now, we type | + | ||Now, we type “THIS IS A PERSONAL FINANCE TRACKER. IT IS VERY USEFUL”. |
|- | |- | ||
| Line 232: | Line 228: | ||
|- | |- | ||
||05:29 | ||05:29 | ||
| − | ||In our | + | ||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 240: | ||
|- | |- | ||
||05:59 | ||05:59 | ||
| − | ||Next, click on the '''“Format”''' option in the menu bar and then click on the ''' | + | ||Next, click on the '''“Format”''' option in the menu bar and then click on the '''“Merge Cells”''' option. |
|- | |- | ||
||06:07 | ||06:07 | ||
| − | ||In the sidebar which pops-up, click on the ''' | + | ||In the sidebar which pops-up, click on the '''“Merge Cells”''' option. |
|- | |- | ||
| Line 272: | Line 268: | ||
|- | |- | ||
||06:49 | ||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'''. |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| Line 328: | Line 320: | ||
|- | |- | ||
||08:14 | ||08:14 | ||
| − | ||Merging Cells. Shrinking text to fit the cell. | + | ||Merging Cells. * Shrinking text to fit the cell. |
|- | |- | ||
| Line 336: | Line 328: | ||
|- | |- | ||
||08:21 | ||08:21 | ||
| − | ||Open | + | ||Open “spreadsheet practice.ods” sheet. |
|- | |- | ||
| Line 348: | Line 340: | ||
|- | |- | ||
||08:31 | ||08:31 | ||
| − | ||Using | + | ||Using “Automatic Wrapping”, type the text: “This is a Department Spreadsheet”. |
|- | |- | ||
| Line 368: | Line 360: | ||
|- | |- | ||
||08:51 | ||08:51 | ||
| − | ||The '''Spoken Tutorial''' project team: | + | ||The '''Spoken Tutorial''' project team: Conducts workshops using spoken tutorials. |
|- | |- | ||
Latest revision as of 12:41, 23 March 2017
Resources for recording Formatting Data
| 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,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 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: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 an empty cell. |
| 04:44 | For example- let's 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 | Let's 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 on 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,Let's 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 | Let's 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 summarizes 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 DesiCrew Solutions Pvt. Ltd.Thanks for joining. |
