Difference between revisions of "LibreOffice-Suite-Calc/C2/Formatting-Data/English-timed"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) |
|||
(6 intermediate revisions by 2 users not shown) | |||
Line 8: | Line 8: | ||
|- | |- | ||
||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:06 | ||00:06 | ||
− | ||In this tutorial we will learn about:Formatting | + | ||In this tutorial, we will learn about: Formatting borders, background colors |
|- | |- | ||
||00:12 | ||00:12 | ||
− | ||Formatting multiple lines of text using Automatic Wrapping | + | ||Formatting multiple lines of text using '''Automatic Wrapping''' |
|- | |- | ||
||00:18 | ||00:18 | ||
− | ||Merging Cells | + | ||Merging Cells Shrinking text to fit the cell. |
|- | |- | ||
||00:22 | ||00:22 | ||
− | ||Here we are using Ubuntu Linux version 10.04 as our operating system and LibreOffice Suite version 3.3.4. | + | ||Here, we are using '''Ubuntu Linux''' version '''10.04''' 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'''. |
|- | |- | ||
||00:39 | ||00:39 | ||
− | ||Let us open our | + | ||Let us open our "personal finance tracker.ods" file. |
|- | |- | ||
||00:45 | ||00:45 | ||
− | ||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:50 | ||00:50 | ||
− | ||For example | + | ||For example- let us format the cells with the headings '''Serial Number''', '''Item''', '''Cost''', '''Spent''', '''Received''', '''Date''' and '''Account'''. |
|- | |- | ||
||01:01 | ||01:01 | ||
− | ||So let us first click on the cell with the heading Serial Number, denoted by | + | ||So, let us first click on the '''cell''' with the heading "Serial Number", denoted by "SN". |
|- | |- | ||
||01:08 | ||01:08 | ||
− | ||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:14 | ||01:14 | ||
− | ||After selecting the entire horizontal row containing the headings, click on the | + | ||After selecting the entire horizontal row containing the headings, click on the '''Borders''' icon on the '''Formatting toolbar'''. |
|- | |- | ||
||01:23 | ||01:23 | ||
− | ||A drop down box opens up containing several border styles. | + | ||A drop-down box opens up containing several border styles. |
|- | |- | ||
||01:28 | ||01:28 | ||
− | ||Click on one of the styles you want to apply on the borders. | + | ||Click on one of the styles, you want to apply on the borders. |
|- | |- | ||
||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. |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
|- | |- | ||
||01:39 | ||01:39 | ||
− | ||Let us undo this change. | + | ||Let us '''undo''' this change. |
|- | |- | ||
||01:45 | ||01:45 | ||
− | ||The selected cells are still highlighted.Right-click on the selection and choose | + | ||The selected cells are still highlighted. Right-click on the selection and choose '''Format Cells''' option. |
|- | |- | ||
||01:54 | ||01:54 | ||
− | ||Now click on the | + | ||Now, click on the '''Borders''' tab. |
|- | |- | ||
||01:56 | ||01:56 | ||
− | ||You will see the options for | + | ||You will see the options for '''Line arrangement''', '''Line''', '''Spacing to contents''' and '''Shadow style'''. |
|- | |- | ||
Line 92: | Line 88: | ||
|- | |- | ||
||02:10 | ||02:10 | ||
− | ||But one can change any of these to suit our requirement. | + | ||But, one can change any of these to suit our requirement. |
|- | |- | ||
||02:14 | ||02:14 | ||
− | ||Under | + | ||Under '''User-defined''', you can see a small '''preview window''' which displays the selection. |
|- | |- | ||
||02:22 | ||02:22 | ||
− | ||I will choose the third option under | + | ||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 | + | ||I will also change the '''Style''', '''Width''' and '''Color'''. |
|- | |- | ||
Line 112: | Line 108: | ||
|- | |- | ||
||02:38 | ||02:38 | ||
− | ||Spacing to contents has the | + | ||'''Spacing to contents''' has the '''Synchronize''' option checked. |
|- | |- | ||
Line 124: | Line 120: | ||
|- | |- | ||
||02:53 | ||02:53 | ||
− | ||I will change | + | ||I will change '''Top''' and '''Bottom''' margins to '''1.4pt'''. |
|- | |- | ||
||03:00 | ||03:00 | ||
− | ||I will leave you to explore the various Shadow styles, on your own. | + | ||I will leave you to explore the various '''Shadow styles''', on your own. |
|- | |- | ||
||03:04 | ||03:04 | ||
− | ||Click on OK. | + | ||Click on '''OK'''. |
|- | |- | ||
Line 144: | Line 140: | ||
|- | |- | ||
||03:18 | ||03:18 | ||
− | ||In order to give background | + | ||In order to give '''background color'''s 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 156: | Line 152: | ||
|- | |- | ||
||03:36 | ||03:36 | ||
− | ||So let us first click on the cell which contains the heading Serial Number, denoted by | + | ||So, let us first click on the '''cell''' which contains the heading "Serial Number", denoted by "SN". |
|- | |- | ||
||03:44 | ||03:44 | ||
− | ||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:50 | ||03:50 | ||
− | ||After selecting the entire horizontal row containing the headings, click on the “Background Color” option in the Formatting | + | ||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. |
|- | |- | ||
Line 180: | Line 176: | ||
|- | |- | ||
||04:17 | ||04:17 | ||
− | ||Calc provides various options for formatting multiple lines of text. | + | ||'''Calc''' provides various options for formatting multiple lines of text. |
|- | |- | ||
||04:22 | ||04:22 | ||
− | ||The first one is by using “Automatic Wrapping”. | + | ||The first one is by using '''“Automatic Wrapping”'''. |
|- | |- | ||
Line 192: | Line 188: | ||
|- | |- | ||
||04:33 | ||04:33 | ||
− | ||So let us see how it is implemented. | + | ||So, let us see how it is implemented. |
|- | |- | ||
||04:37 | ||04:37 | ||
− | ||Now in our “personal finance tracker.ods” sheet, let us click on | + | ||Now, in our “personal finance tracker.ods” sheet, let us click on an empty cell. |
|- | |- | ||
||04:44 | ||04:44 | ||
− | ||For example | + | ||For example- let's click on cell number “B12”. |
|- | |- | ||
||04:49 | ||04:49 | ||
− | ||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:54 | ||04:54 | ||
− | ||Now click on the “Alignment” tab in the dialog box. | + | ||Now, click on the '''“Alignment”''' tab, in the dialog-box. |
|- | |- | ||
||04:58 | ||04:58 | ||
− | ||At the bottom of the dialog box click on the “Wrap text automatically” option and then click on the | + | ||At the bottom of the dialog-box, click on the '''“Wrap text automatically”''' option and then click on the '''OK''' button. |
|- | |- | ||
||05:08 | ||05:08 | ||
− | ||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 224: | Line 220: | ||
|- | |- | ||
||05:19 | ||05:19 | ||
− | || | + | ||Let's '''undo''' the changes. |
|- | |- | ||
||05:21 | ||05:21 | ||
− | ||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:29 | ||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”. | + | ||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 | + | ||Now, hold down the '''Shift''' key on the keyboard and click on the '''cell''' with its corresponding item, '''“Salary”'''. |
|- | |- | ||
Line 244: | Line 240: | ||
|- | |- | ||
||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:07 | ||06:07 | ||
− | ||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:12 | ||06:12 | ||
− | ||In order to move the contents of both the cells in a single cell, click on the | + | ||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 260: | Line 256: | ||
|- | |- | ||
||06:31 | ||06:31 | ||
− | ||Now let us undo the merging we did by clicking | + | ||Now, let us '''undo''' the merging we did by clicking on '''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. |
|- | |- | ||
||06:41 | ||06:41 | ||
− | ||The font size of the data in a cell can be automatically adjusted to fit into a cell. | + | ||The '''font size''' of the data in a cell can be automatically adjusted to fit into a cell. |
|- | |- | ||
||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 284: | Line 276: | ||
|- | |- | ||
||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:11 | ||07:11 | ||
− | ||Now click on the | + | ||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 | + | ||Alternately, right-click on the cell and click on '''Format Cells'''. |
|- | |- | ||
||07:24 | ||07:24 | ||
− | ||You see that the “Format Cells” dialog box opens. | + | ||You see that the “Format Cells” dialog-box opens. |
|- | |- | ||
||07:28 | ||07:28 | ||
− | ||Click on the | + | ||Click on the '''Alignment''' tab in the dialog-box. |
|- | |- | ||
||07:31 | ||07:31 | ||
− | ||At the bottom of the dialog box, click on the “Shrink to fit cell size” check-box and then click on the | + | ||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:54 | ||07:54 | ||
− | || | + | ||Let's '''undo''' the changes. |
|- | |- | ||
||07:57 | ||07:57 | ||
− | ||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:02 | ||08:02 | ||
− | ||To summarize, we learned about: Formatting Borders, background colors in Calc. | + | ||To summarize, we learned about: * Formatting Borders, background colors in Calc. |
|- | |- | ||
||08:09 | ||08:09 | ||
− | ||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:19 | ||08:19 | ||
− | ||COMPREHENSIVE ASSIGNMENT | + | ||COMPREHENSIVE ASSIGNMENT- |
|- | |- | ||
Line 348: | Line 340: | ||
|- | |- | ||
||08:31 | ||08:31 | ||
− | ||Using “Automatic Wrapping” type the text | + | ||Using “Automatic Wrapping”, type the text: “This is a Department Spreadsheet”. |
|- | |- | ||
||08:37 | ||08:37 | ||
− | ||Shrink this text to fit in the cell. | + | ||Shrink this text to fit in the '''cell'''. |
|- | |- | ||
||08:40 | ||08:40 | ||
− | ||Watch the video available at the following link | + | ||Watch the video available at the following link. |
|- | |- | ||
||08:43 | ||08:43 | ||
− | ||It | + | ||It summarizes the Spoken Tutorial project. |
|- | |- | ||
||08:46 | ||08:46 | ||
− | ||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:51 | ||08:51 | ||
− | ||The Spoken Tutorial | + | ||The '''Spoken Tutorial''' project team: Conducts workshops using spoken tutorials. |
|- | |- | ||
||08:56 | ||08:56 | ||
− | ||Gives certificates for those who pass an online test | + | ||Gives certificates for those who pass an online test. |
|- | |- | ||
||09:00 | ||09:00 | ||
− | ||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:06 | ||09:06 | ||
− | ||Spoken Tutorial | + | ||'''Spoken Tutorial''' project is a part of the '''Talk to a Teacher''' project. |
|- | |- | ||
||09:11 | ||09:11 | ||
− | ||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 | + | ||More information on this mission is available at:'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''. |
|- | |- | ||
||09:29 | ||09:29 | ||
− | ||This tutorial has been contributed by . | + | ||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.Thanks for joining. |
− | + | ||
− | + | ||
− | + | ||
− | + |
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. |