Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Working-with-Sheets/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
'''Resources for recording'''
 
−
[[Media:Working with Sheets.zip |Working with Sheets]]
 
−
 
 
{| border=1
 
{| border=1
 
|| '''Time'''
 
|| '''Time'''
Line 7: Line 4:
  
 
|-
 
|-
−
|| 00:00
+
||00:00
−
|| Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells and Sheets.
+
||Welcome to the '''Spoken tutorial''' on '''LibreOffice Calc – Working with Cells and Sheets'''.
  
 
|-
 
|-
−
|| 00:07
+
||00:07
−
|| In this tutorial we will learn about:
+
||In this tutorial, we will learn about:
  
 
|-
 
|-
−
|| 00:09
+
||00:09
 
||Inserting and Deleting rows and columns
 
||Inserting and Deleting rows and columns
  
 
|-
 
|-
−
|| 00:13
+
||00:13
−
||Inserting and Deleting sheets. Renaming Sheets  
+
||Inserting and Deleting sheets. * Renaming Sheets.
  
 
|-
 
|-
−
|| 00:17
+
||00:17
−
|| Here we are using GNU/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:28
+
||00:28
−
|| So let us start our tutorial by learning how to insert rows and columns in a spreadsheet.
+
||So, let us start our tutorial by learning how to insert '''row'''s and '''column'''s in a '''spreadsheet'''.
  
 
|-
 
|-
−
|| 00:35
+
||00:35
 
||Let us open our “personal finance tracker.ods” file.
 
||Let us open our “personal finance tracker.ods” file.
  
 
|-
 
|-
−
|| 00:41
+
||00:41
−
|| Columns and rows can be inserted individually or in groups.
+
||Columns and rows can be inserted individually or in groups.
  
 
|-
 
|-
−
|| 00:47
+
||00:47
−
|| In order to insert a single row or a single column in the spreadsheet, first select the cell, column or row where you want the new column or a new row to be inserted.
+
||In order to insert a single row or a single column in the spreadsheet- first select the '''cell, column''' or '''row''' where you want the new column or a new row to be inserted.
  
 
|-
 
|-
−
|| 00:59
+
||00:59
−
||For example in our “personal finance tracker.ods” file lets click somewhere on the first row.
+
||For example: in our “personal finance tracker.ods” file, let's click somewhere on the first row.
  
 
|-
 
|-
−
|| 01:08
+
||01:08
 
||I will click on the cell which has “Cost” written in it.
 
||I will click on the cell which has “Cost” written in it.
  
 
|-
 
|-
−
|| 01:12
+
||01:12
−
|| Now click on the “Insert” option in the menu bar and then click on “Rows”.
+
||Now, click on the '''Insert''' option in the menu bar and then click on '''Rows'''.
  
 
|-
 
|-
−
|| 01:18
+
||01:18
 
||We see that a new row gets inserted just above the selected row.
 
||We see that a new row gets inserted just above the selected row.
  
 
|-
 
|-
−
|| 01:24
+
||01:24
−
|| Similarly, for inserting a new column, just click on the “Insert” button in the menu bar and click on “Columns”.
+
||Similarly, for inserting a new column, just click on the '''“Insert”''' button in the menu bar and click on '''“Columns”'''.
  
 
|-
 
|-
−
|| 01:33
+
||01:33
−
||You see that a new column gets inserted before the selected cell column.
+
||You see that a new column gets inserted before the selected '''cell''' column.
  
 
|-
 
|-
−
|| 01:39
+
||01:39
−
||Now lets undo the change we made.
+
||Now let's '''undo''' the change we made.
  
 
|-
 
|-
−
|| 01:42
+
||01:42
−
|| If you have selected a column by clicking the Alphabet that identifies it or a row by the Number that identifies it, then right-click and choose the Insert Columns or Insert Rows option in the drop down menu that appears, in order to add a new column or row.   
+
||If you have selected a column by clicking the alphabet that identifies it or a row by the number that identifies it, then right-click and choose the '''Insert Columns''' or '''Insert Rows''' option in the drop down menu that appears, in order to add a new column or row.   
  
 
|-
 
|-
−
|| 02:04
+
||02:04
−
|| Alternately, select a cell by simply clicking on it with the cursor.  Then right click and choose the Insert option.  You will see a dialog box like this.  
+
||Alternately, select a cell by simply clicking on it with the cursor.  Then right click and choose the '''Insert''' option.  You will see a dialog box like this.  
  
 
|-
 
|-
−
|| 02:17
+
||02:17
−
||Choose Entire Row or Entire Column option to add a row or a column.
+
||Choose '''Entire Row''' or '''Entire Column''' option to add a row or a column.
  
 
|-
 
|-
−
|| 02:24
+
||02:24
−
|| For inserting multiple columns or rows at the same time, we should first highlight the required number of columns or rows by holding down the left mouse button on the initial cell and then dragging across the required number of identifiers.
+
||For inserting multiple columns or rows at the same time, we should first highlight the required number of columns or rows by holding down the '''left mouse button''' on the initial cell and then dragging across the required number of identifiers.
  
 
|-
 
|-
−
|| 02:43
+
||02:43
−
||Here we have highlighted 4 cells.
+
||Here, we have highlighted 4 cells.
  
 
|-
 
|-
−
|| 02:46
+
||02:46
−
|| Follow one of the methods discussed, to add new rows or columns.  I wish to add new rows.  So, I shall right-click on the selection and choose Insert option.
+
||Follow one of the methods discussed to add new rows or columns.  I wish to add new rows.  So, I shall right-click on the selection and choose '''Insert option'''.
  
 
|-
 
|-
−
|| 02:59
+
||02:59
−
|| Next I choose Entire Row option. Click on the “OK” button. Notice that 4 new rows are added above the first of the selected rows.
+
||Next, I choose '''Entire Row''' option. Click on the '''OK''' button. Notice that 4 new rows are added above the first of the selected rows.
  
 
|-
 
|-
−
|| 03:13
+
||03:13
−
|| Next we will learn about how to delete Columns individually and in groups.
+
||Next we will learn about how to delete '''columns''' individually and in groups.
  
 
|-
 
|-
−
|| 03:19
+
||03:19
 
||For deleting a single column or a row, first select the column or row you wish to delete.
 
||For deleting a single column or a row, first select the column or row you wish to delete.
  
 
|-
 
|-
−
|| 03:27
+
||03:27
−
||For example if we want to delete the column which has “Laundry” written in it, first select a cell in that column by clicking on it.
+
||For example- if we want to delete the column which has “Laundry” written in it, first select a cell in that column by clicking on it.
  
 
|-
 
|-
−
|| 03:36
+
||03:36
−
||Now right-click on the cell and click on the “Delete” option.
+
||Now right-click on the cell and click on the '''Delete''' option.
  
 
|-
 
|-
−
|| 03:42
+
||03:42
−
|| A dialog box appears with the heading “Delete Cells”.
+
||A dialog box appears with the heading “Delete Cells”.
  
 
|-
 
|-
−
|| 03:46
+
||03:46
−
||Now click on the “Shift cells up” option and then click on the “OK” button.
+
||Now click on the '''“Shift cells up”''' option and then click on the '''“OK”''' button.
  
 
|-
 
|-
−
|| 03:52
+
||03:52
−
||You see that the cell gets deleted and the cells below it shifts up. Lets undo this change.
+
||You see that the cell gets deleted and the cells below it shift up. Let's '''undo''' this change.
  
 
|-
 
|-
−
|| 04:00
+
||04:00
−
|| Now lets learn how to delete multiple columns or rows at the same time.
+
||Now, let's learn how to delete multiple columns or rows at the same time.
  
 
|-
 
|-
−
|| 04:07
+
||04:07
−
|| For example, if we want to delete the row which has “Miscellaneous” written in it, first select the cell which contains its serial number which is 6.
+
||For example, if we want to delete the row which has “Miscellaneous” written in it, first select the cell which contains its serial number which is 6.
  
 
|-
 
|-
−
|| 04:17
+
||04:17
−
||Now hold down the left mouse button on this cell and drag it across the entire row. Alternately, click on the row number to be deleted.  The entire row gets highlighted.
+
||Now hold down the '''left mouse button''' on this cell and drag it across the entire row. Alternately, click on the row number to be deleted.  The entire row gets highlighted.
  
 
|-
 
|-
−
|| 04:32
+
||04:32
−
||Right-click on the cell and then click on the “Delete” option.
+
||Right-click on the '''cell''' and then click on the '''“Delete”''' option.
  
 
|-
 
|-
−
|| 04:37
+
||04:37
−
|| A dialog box appears with the heading “Delete Cells”.
+
||A dialog box appears with the heading “Delete Cells”.
  
 
|-
 
|-
−
|| 04:41
+
||04:41
−
||Now click on the “Shift cells up” option and then click on the “OK” button.
+
||Now click on the '''“Shift cells up”''' option and then click on the '''OK''' button.
  
 
|-
 
|-
−
|| 04:47
+
||04:47
 
||You see that the entire row gets deleted and the row below it shifts up.
 
||You see that the entire row gets deleted and the row below it shifts up.
  
 
|-
 
|-
−
|| 04:54
+
||04:54
−
||Similarly we can delete columns by selecting columns instead of rows.
+
||Similarly, we can delete columns by selecting columns instead of rows.
−
Let us undo the change we made.
+
Let us '''undo''' the change we made.
  
 
|-
 
|-
−
|| 05:03
+
||05:03
−
|| After learning about how to insert and delete multiple rows and columns in a sheet, we will now learn about how to insert and delete sheets in Calc.
+
||After learning about how to insert and delete multiple rows and columns in a sheet, we will now learn about how to insert and delete '''sheet'''s in Calc.
  
 
|-
 
|-
−
|| 05:14  
+
||05:14  
 
||There are several ways to insert a new sheet in Calc. We will learn about each one of them one by one.
 
||There are several ways to insert a new sheet in Calc. We will learn about each one of them one by one.
  
 
|-
 
|-
−
|| 05:22
+
||05:22
−
|| The first step for all of the methods is to select the sheet next to which the new sheet will be inserted.
+
||The first step for all of the methods is to select the sheet next to which the new sheet will be inserted.
  
 
|-
 
|-
−
|| 05:29
+
||05:29
−
||Now click on the “Insert” option in the menu bar then click on “Sheet”.
+
||Now click on the '''“Insert”''' option in the menu bar, then click on '''“Sheet”'''.
  
 
|-
 
|-
−
|| 05:35
+
||05:35
−
||A dialog box opens up with the heading “Insert Sheet”.
+
||A dialog box opens up with the heading '''“Insert Sheet”'''.
−
 
+
  
 
|-
 
|-
−
|| 05:41
+
||05:41
−
||Now let us select “After current sheet” radio button to insert a new sheet after our current sheet.
+
||Now, let us select '''“After current sheet”''' radio-button to insert a new sheet after our current sheet.
  
 
|-
 
|-
−
|| 05:48
+
||05:48
−
||In the “Name” field, the name of our new sheet is displayed as “Sheet 4”.  That is the system-generated name. You may rename it if you want to.
+
||In the '''“Name”''' field, the name of our new sheet is displayed as “Sheet 4”.  That is the system-generated name. You may '''rename''' it if you want to.
  
 
|-
 
|-
−
|| 06:00
+
||06:00
−
||Now click on the “OK” button.
+
||Now, click on the '''OK''' button.We see that a new sheet is inserted after our current sheet.
−
We see that a new sheet is inserted after our current sheet.
+
  
 
|-
 
|-
−
|| 06:07
+
||06:07
−
|| Another method for inserting a new sheet is by right-clicking on the current sheet tab at the bottom left of the Calc window and clicking on the “Insert Sheet” option.
+
||Another method for inserting a new sheet is by right-clicking on the current sheet tab at the bottom left of the '''Calc window''' and clicking on the '''“Insert Sheet”''' option.
  
 
|-
 
|-
−
|| 06:19
+
||06:19
−
||You can choose the position, number of sheets and the name and then click on the “OK” button.  This will insert the sheet accordingly.
+
||You can choose the position, number of sheets and the name and then click on the '''OK''' button.  This will insert the sheet accordingly.
  
 
|-
 
|-
−
|| 06:30
+
||06:30
−
|| Another simple way of inserting a sheet after the current sheet is by clicking on the “Add Sheet” button, denoted by a plus sign, next to the sheet tab.
+
||Another simple way of inserting a sheet after the current sheet is by clicking on the '''“Add Sheet”''' button, denoted by a plus sign, next to the '''sheet tab'''.
  
 
|-
 
|-
−
|| 06:42
+
||06:42
−
||On clicking it a new sheet gets inserted automatically after the last sheet in the series.
+
||On clicking it, a new sheet gets inserted automatically after the last sheet in the series.
  
 
|-
 
|-
−
|| 06:50
+
||06:50
−
|| The last method of inserting a new sheet by accessing the “Insert Sheet” dialog box is by simply clicking on the empty space next to the “Add Sheet” plus sign in the sheet tabs at the bottom.
+
||The last method of inserting a new sheet by accessing the “Insert Sheet” dialog box is simply by clicking on the empty space next to the “Add Sheet” plus sign in the sheet tabs at the bottom.
  
 
|-
 
|-
−
|| 07:05
+
||07:05
−
||On clicking the empty space, we see, that the “Insert Sheet” dialog box appears.
+
||On clicking the empty space, we see that the “Insert Sheet” dialog box appears.
  
 
|-
 
|-
−
|| 07:12
+
||07:12
−
||You can enter the sheet details in the dialog box and then click on the “OK” button.
+
||You can enter the sheet details in the dialog box and then click on the '''OK''' button.
  
 
|-
 
|-
−
|| 07:18
+
||07:18
−
|| After learning about how to insert sheets, we will now learn how to delete sheets in Calc.
+
||After learning about how to insert sheets, we will now learn how to delete sheets in '''Calc'''.
  
 
|-
 
|-
−
|| 07:25
+
||07:25
−
|| Sheets can be deleted individually or in groups.
+
||Sheets can be deleted individually or in groups.
  
 
|-
 
|-
−
|| 07:30
+
||07:30
−
||In order to delete single sheets, right-click on the tab of the sheet you want to delete and then click on the “Delete Sheet” option in the pop up menu and then click on the “Yes” option.
+
||In order to delete a single sheet, right-click on the tab of the sheet you want to delete and then click on the '''“Delete Sheet”''' option in the pop up menu and then click on the '''“Yes”''' option.
  
 
|-
 
|-
−
|| 07:44
+
||07:44
 
||You see that the sheet gets deleted.
 
||You see that the sheet gets deleted.
  
 
|-
 
|-
−
|| 07:48
+
||07:48
−
|| Another way of deleting a particular sheet is by using the “Edit” option in the menu bar.
+
||Another way of deleting a particular sheet is by using the '''“Edit”''' option in the menu bar.
  
 
|-
 
|-
−
|| 07:54
+
||07:54
−
||For example if we want to delete “Sheet 3” from the list, click on the “Edit” option in the menu bar and then click on the “Sheet” option.
+
||For example- if we want to delete “Sheet 3” from the list, click on the '''Edit''' option in the menu bar and then click on the '''Sheet''' option.
  
 
|-
 
|-
−
|| 08:04
+
||08:04
−
||Now click on the “Delete” option in the pop up menu and then click on the “Yes” option.
+
||Now, click on the '''“Delete”''' option in the '''pop-up menu''' and then click on the '''“Yes”''' option.
  
 
|-
 
|-
−
|| 08:11
+
||08:11
−
||You see that the sheet gets deleted. Now lets undo the change we made in the document.
+
||You see that the sheet gets deleted. Now let's '''undo''' the change we made in the document.
  
 
|-
 
|-
−
|| 08:18
+
||08:18
−
|| In order to delete multiple sheets, for example, if we want to delete “Sheet 2” and “Sheet 3” then click on the “Sheet 2” tab first and then holding the “Shift” button on the keyboard, click on the “Sheet 3”tab.
+
||In order to delete multiple sheets- for example, if we want to delete “Sheet 2” and “Sheet 3” then click on the “Sheet 2” tab first and then holding the '''Shift''' button on the keyboard, click on the “Sheet 3” tab.
  
 
|-
 
|-
−
|| 08:35
+
||08:35
−
||Now right-click over one of the tabs and click on the “Delete Sheet” option from the pop-up menu
+
||Now, right-click over one of the tabs and click on the '''“Delete Sheet”''' option from the pop-up menu and then click on the '''“Yes”''' option.
−
and then click on the “Yes” option.
+
  
 
|-
 
|-
−
|| 08:46
+
||08:46
−
||You see that both the sheets get deleted. To learn further, let us first undo the changes we made.
+
||You see that both the sheets get deleted. To learn further, let us first '''undo''' the changes we made.
  
 
|-
 
|-
−
|| 08:54
+
||08:54
−
|| Another way of deleting a particular sheet is by using the “Edit” option in the menu bar.
+
||Another way of deleting a particular sheet is by using the '''“Edit”''' option in the menu bar.
  
 
|-
 
|-
−
|| 09:01
+
||09:01
−
|| For example if we want to delete “Sheet 6” and “Sheet 7”from the list, click on the “Edit” option in the menu bar and then click on the “Sheet” option.
+
||For example- if we want to delete “Sheet 6” and “Sheet 7” from the list, click on the '''“Edit”''' option in the menu bar and then click on the '''Sheet''' option.
  
 
|-
 
|-
−
|| 09:13
+
||09:13
−
||Now click on the “Select” option in the pop up menu.
+
||Now click on the '''Select''' option in the pop-up menu.
  
 
|-
 
|-
−
|| 09:18
+
||09:18
−
||In the dialog box which appears, click on the “Sheet 6” option and then holding the “Shift” button on the keyboard, click on the “Sheet 7” option.
+
||In the dialog box which appears, click on the “Sheet 6” option and then holding the '''Shift''' button on the keyboard, click on the “Sheet 7” option.
  
 
|-
 
|-
−
|| 09:30
+
||09:30
−
||Click on the “OK” button. This selects the sheets we want to delete.
+
||Click on the '''OK''' button. This selects the sheets we want to delete.
  
 
|-
 
|-
−
|| 09:36
+
||09:36
−
|| Now again click on the “Edit” option in the menu bar and then click on the “Sheet” option.
+
||Now again click on the '''“Edit”''' option in the menu-bar and then click on the '''Sheet''' option.
  
 
|-
 
|-
−
|| 09:43
+
||09:43
−
||Now click on the “Delete” option in the pop up menu and then click on the “Yes” option.
+
||Now, click on the '''“Delete”''' option in the pop-up menu and then click on the '''“Yes”''' option.
  
 
|-
 
|-
−
|| 09:50
+
||09:50
 
||You see that the selected sheets get deleted.
 
||You see that the selected sheets get deleted.
  
 
|-
 
|-
−
|| 09:54
+
||09:54
−
|| After learning about how to delete sheets in Calc, we will now learn how to rename sheets in a spreadsheet.
+
||After learning about how to delete sheets in Calc, we will now learn how to '''rename''' sheets in a spreadsheet.
  
 
|-
 
|-
−
|| 10:02
+
||10:02
 
||If you see in a spreadsheet, the different sheets are named by default as  “Sheet 1”, “Sheet 2”, “Sheet 3” and likewise.
 
||If you see in a spreadsheet, the different sheets are named by default as  “Sheet 1”, “Sheet 2”, “Sheet 3” and likewise.
  
 
|-
 
|-
−
|| 10:11
+
||10:11
 
||This works for a small spreadsheet with only a few sheets but it becomes cumbersome when there are many sheets.
 
||This works for a small spreadsheet with only a few sheets but it becomes cumbersome when there are many sheets.
  
 
|-
 
|-
−
|| 10:21
+
||10:21
−
|| Calc provides provision to rename the sheets according to our liking.
+
||'''Calc''' provides provision to '''rename''' the sheets according to our liking.
  
 
|-
 
|-
−
|| 10:25
+
||10:25
−
||Now for example, if we want to rename “Sheet 4” as “Dump”.
+
||Now, for example- if we want to rename “Sheet 4” as “Dump”, you can simply do this by double clicking on the “Sheet 4”tab below.
−
You can simply do this by double clicking on the “Sheet 4”tab below.
+
  
 
|-
 
|-
−
|| 10:36
+
||10:36
−
|| You see that a dialog box opens up with the heading “Rename Sheet”.
+
||You see that a dialog box opens up with the heading “Rename Sheet”. There is a textbox with “Sheet 4” written in it, by default.
−
There is a textbox with “Sheet 4” written in it, by default.
+
  
 
|-
 
|-
−
|| 10:46
+
||10:46
−
||Now delete the default name and write the new sheet name as “Dump”.
+
||Now, delete the default name and write the new sheet name as “Dump”.
−
 
+
  
 
|-
 
|-
−
|| 10:51
+
||10:51
−
||Click on the “OK” button and you see that the “Sheet 4” tab has been renamed to “Dump”.
+
||Click on the '''OK''' button and you see that the “Sheet 4” tab has been renamed to “Dump”. Let us delete "Sheets 5" and "Dump".
−
Let us delete Sheets 5 and Dump.
+
  
 
|-
 
|-
−
|| 11:01
+
||11:01
 
|| 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.
  
 
|-
 
|-
−
|| 11:06
+
||11:06
−
||To summarize, we learned about: Inserting and Deleting rows and columns.
+
||To summarize, we learned about: * Inserting and Deleting rows and columns.
  
 
|-
 
|-
−
|| 11:12
+
||11:12
−
||Inserting and Deleting sheets. Renaming Sheets
+
||Inserting and Deleting sheets. * Renaming Sheets.
  
 
|-
 
|-
−
|| 11:17
+
||11:17
−
|| COMPREHENSIVE ASSIGNMENT
+
||COMPREHENSIVE ASSIGNMENT- Open “Spreadsheet Practice.ods” file.
−
Open “Spreadsheet Practice.ods” file
+
  
 
|-
 
|-
−
|| 11:23
+
||11:23
−
||Select and delete the row with the heading “Serial Number”. Rename the sheet to “Department Sheet”.
+
||Select and delete the row with the heading “Serial Number”. * Rename the sheet to “Department Sheet”.
  
 
|-
 
|-
−
|| 11:32
+
||11:32
−
||*Watch the video available at the following link
+
||Watch the video available at the following link:
  
 
|-
 
|-
−
|| 11:34
+
||11:34
−
||*It summarises the Spoken Tutorial project
+
||It summarizes the Spoken Tutorial project. 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
+
  
 
|-
 
|-
−
|| 11:44
+
||11:44
−
||The Spoken Tutorial Project Team
+
||The Spoken Tutorial Project Team:Conducts workshops using spoken tutorials.
−
*Conducts workshops using spoken tutorials
+
  
 
|-
 
|-
−
|| 11:48
+
||11:48
−
||*Gives certificates for those who pass an online test
+
||Gives certificates for those who pass an online test.
−
*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.
  
 
|-
 
|-
 
|| 11:58
 
|| 11:58
−
||*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.
−
*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.
  
 
|-
 
|-
−
|| 12:10
+
||12:10
−
||*More information on this Mission is available at
+
||More information on this mission is available at: spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
−
*spoken hyphen tutorial dot org slash NMEICT hyphen Intro
+
  
 
|-
 
|-
−
|| 12:21
+
||12:21
−
||This tutorial has been contributed by Desi Crew Pvt.Ltd
+
||This tutorial has been contributed by DesiCrew Solutions Pvt.Ltd.
−
 
+
Thanks for joining.
−
  Thanks for joining
+
−
 
+
 
|-
 
|-
−
 
 
|}
 
|}

Latest revision as of 10:39, 27 March 2017

Time Narration
00:00 Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells and Sheets.
00:07 In this tutorial, we will learn about:
00:09 Inserting and Deleting rows and columns
00:13 Inserting and Deleting sheets. * Renaming Sheets.
00:17 Here we are using GNU/Linux as our operating system and LibreOffice Suite version 3.3.4.
00:28 So, let us start our tutorial by learning how to insert rows and columns in a spreadsheet.
00:35 Let us open our “personal finance tracker.ods” file.
00:41 Columns and rows can be inserted individually or in groups.
00:47 In order to insert a single row or a single column in the spreadsheet- first select the cell, column or row where you want the new column or a new row to be inserted.
00:59 For example: in our “personal finance tracker.ods” file, let's click somewhere on the first row.
01:08 I will click on the cell which has “Cost” written in it.
01:12 Now, click on the Insert option in the menu bar and then click on Rows.
01:18 We see that a new row gets inserted just above the selected row.
01:24 Similarly, for inserting a new column, just click on the “Insert” button in the menu bar and click on “Columns”.
01:33 You see that a new column gets inserted before the selected cell column.
01:39 Now let's undo the change we made.
01:42 If you have selected a column by clicking the alphabet that identifies it or a row by the number that identifies it, then right-click and choose the Insert Columns or Insert Rows option in the drop down menu that appears, in order to add a new column or row.
02:04 Alternately, select a cell by simply clicking on it with the cursor. Then right click and choose the Insert option. You will see a dialog box like this.
02:17 Choose Entire Row or Entire Column option to add a row or a column.
02:24 For inserting multiple columns or rows at the same time, we should first highlight the required number of columns or rows by holding down the left mouse button on the initial cell and then dragging across the required number of identifiers.
02:43 Here, we have highlighted 4 cells.
02:46 Follow one of the methods discussed to add new rows or columns. I wish to add new rows. So, I shall right-click on the selection and choose Insert option.
02:59 Next, I choose Entire Row option. Click on the OK button. Notice that 4 new rows are added above the first of the selected rows.
03:13 Next we will learn about how to delete columns individually and in groups.
03:19 For deleting a single column or a row, first select the column or row you wish to delete.
03:27 For example- if we want to delete the column which has “Laundry” written in it, first select a cell in that column by clicking on it.
03:36 Now right-click on the cell and click on the Delete option.
03:42 A dialog box appears with the heading “Delete Cells”.
03:46 Now click on the “Shift cells up” option and then click on the “OK” button.
03:52 You see that the cell gets deleted and the cells below it shift up. Let's undo this change.
04:00 Now, let's learn how to delete multiple columns or rows at the same time.
04:07 For example, if we want to delete the row which has “Miscellaneous” written in it, first select the cell which contains its serial number which is 6.
04:17 Now hold down the left mouse button on this cell and drag it across the entire row. Alternately, click on the row number to be deleted. The entire row gets highlighted.
04:32 Right-click on the cell and then click on the “Delete” option.
04:37 A dialog box appears with the heading “Delete Cells”.
04:41 Now click on the “Shift cells up” option and then click on the OK button.
04:47 You see that the entire row gets deleted and the row below it shifts up.
04:54 Similarly, we can delete columns by selecting columns instead of rows.

Let us undo the change we made.

05:03 After learning about how to insert and delete multiple rows and columns in a sheet, we will now learn about how to insert and delete sheets in Calc.
05:14 There are several ways to insert a new sheet in Calc. We will learn about each one of them one by one.
05:22 The first step for all of the methods is to select the sheet next to which the new sheet will be inserted.
05:29 Now click on the “Insert” option in the menu bar, then click on “Sheet”.
05:35 A dialog box opens up with the heading “Insert Sheet”.
05:41 Now, let us select “After current sheet” radio-button to insert a new sheet after our current sheet.
05:48 In the “Name” field, the name of our new sheet is displayed as “Sheet 4”. That is the system-generated name. You may rename it if you want to.
06:00 Now, click on the OK button.We see that a new sheet is inserted after our current sheet.
06:07 Another method for inserting a new sheet is by right-clicking on the current sheet tab at the bottom left of the Calc window and clicking on the “Insert Sheet” option.
06:19 You can choose the position, number of sheets and the name and then click on the OK button. This will insert the sheet accordingly.
06:30 Another simple way of inserting a sheet after the current sheet is by clicking on the “Add Sheet” button, denoted by a plus sign, next to the sheet tab.
06:42 On clicking it, a new sheet gets inserted automatically after the last sheet in the series.
06:50 The last method of inserting a new sheet by accessing the “Insert Sheet” dialog box is simply by clicking on the empty space next to the “Add Sheet” plus sign in the sheet tabs at the bottom.
07:05 On clicking the empty space, we see that the “Insert Sheet” dialog box appears.
07:12 You can enter the sheet details in the dialog box and then click on the OK button.
07:18 After learning about how to insert sheets, we will now learn how to delete sheets in Calc.
07:25 Sheets can be deleted individually or in groups.
07:30 In order to delete a single sheet, right-click on the tab of the sheet you want to delete and then click on the “Delete Sheet” option in the pop up menu and then click on the “Yes” option.
07:44 You see that the sheet gets deleted.
07:48 Another way of deleting a particular sheet is by using the “Edit” option in the menu bar.
07:54 For example- if we want to delete “Sheet 3” from the list, click on the Edit option in the menu bar and then click on the Sheet option.
08:04 Now, click on the “Delete” option in the pop-up menu and then click on the “Yes” option.
08:11 You see that the sheet gets deleted. Now let's undo the change we made in the document.
08:18 In order to delete multiple sheets- for example, if we want to delete “Sheet 2” and “Sheet 3” then click on the “Sheet 2” tab first and then holding the Shift button on the keyboard, click on the “Sheet 3” tab.
08:35 Now, right-click over one of the tabs and click on the “Delete Sheet” option from the pop-up menu and then click on the “Yes” option.
08:46 You see that both the sheets get deleted. To learn further, let us first undo the changes we made.
08:54 Another way of deleting a particular sheet is by using the “Edit” option in the menu bar.
09:01 For example- if we want to delete “Sheet 6” and “Sheet 7” from the list, click on the “Edit” option in the menu bar and then click on the Sheet option.
09:13 Now click on the Select option in the pop-up menu.
09:18 In the dialog box which appears, click on the “Sheet 6” option and then holding the Shift button on the keyboard, click on the “Sheet 7” option.
09:30 Click on the OK button. This selects the sheets we want to delete.
09:36 Now again click on the “Edit” option in the menu-bar and then click on the Sheet option.
09:43 Now, click on the “Delete” option in the pop-up menu and then click on the “Yes” option.
09:50 You see that the selected sheets get deleted.
09:54 After learning about how to delete sheets in Calc, we will now learn how to rename sheets in a spreadsheet.
10:02 If you see in a spreadsheet, the different sheets are named by default as “Sheet 1”, “Sheet 2”, “Sheet 3” and likewise.
10:11 This works for a small spreadsheet with only a few sheets but it becomes cumbersome when there are many sheets.
10:21 Calc provides provision to rename the sheets according to our liking.
10:25 Now, for example- if we want to rename “Sheet 4” as “Dump”, you can simply do this by double clicking on the “Sheet 4”tab below.
10:36 You see that a dialog box opens up with the heading “Rename Sheet”. There is a textbox with “Sheet 4” written in it, by default.
10:46 Now, delete the default name and write the new sheet name as “Dump”.
10:51 Click on the OK button and you see that the “Sheet 4” tab has been renamed to “Dump”. Let us delete "Sheets 5" and "Dump".
11:01 This brings us to the end of the Spoken Tutorial on LibreOffice Calc.
11:06 To summarize, we learned about: * Inserting and Deleting rows and columns.
11:12 Inserting and Deleting sheets. * Renaming Sheets.
11:17 COMPREHENSIVE ASSIGNMENT- Open “Spreadsheet Practice.ods” file.
11:23 Select and delete the row with the heading “Serial Number”. * Rename the sheet to “Department Sheet”.
11:32 Watch the video available at the following link:
11:34 It summarizes the Spoken Tutorial project. If you do not have good bandwidth, you can download and watch it.
11:44 The Spoken Tutorial Project Team:Conducts workshops using spoken tutorials.
11:48 Gives certificates for those who pass an online test.

For more details, please write to contact at spoken hyphen tutorial dot org.

11:58 Spoken Tutorial Project is a part of the Talk to a Teacher project.

It is supported by the National Mission on Education through ICT, MHRD, Government of India.

12:10 More information on this mission is available at: spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
12:21 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/Working-with-Sheets/English-timed&oldid=34182"