Difference between revisions of "LibreOffice-Suite-Calc/C2/Working-with-Cells/English-timed"

|| Welcome to the Spoken tutorial on LibreOffice Calc – Working with Cells.

|| In this tutorial we will learn:

||How to enter numbers, text, numbers as text, date and time in a spreadsheet.

||How to use the '''Format Cells dialog box'''.

||How to navigate between '''cells''' and in between '''sheets'''.

||How to select items in '''rows, columns and sheets'''.

|| We will be using '''Ubuntu''' 10.04 as our operating system and '''LibreOffice Suite''' version 3.3.4.

|| So let us first learn how to enter data in the cells.

||We shall open our '''personal finance tracker.ods''' file.

|| You can type any text in a particular cell by simply clicking on the cell and then typing the '''text''' using the keyboard.

||The text is left-aligned by default. One can change the alignment by clicking any one of the '''alignment''' tabs on the '''Formatting Bar'''.

||Lets undo this.

|| Now click on the cell corresponding to '''A1''' in the spreadsheet.

||You see that the selected cell gets highlighted.

|| Under the heading, '''Items''' we shall type the names of a few items one below the other as  '''Salary''', '''House rent''', '''Electricity bill''', '''Phone bill''', '''Laundry''' and '''Miscellaneous'''.

|| In order to enter numbers in the cell, click on the cell and type in the numbers.

||Let us undo the changes.

|| Now under the Serial Number heading, denoted as '''SN''' in our '''personal finance tracker.ods''' spreadsheet, we want the serial number of each item one below the other.

||So click on the cell corresponding to '''A2''' and enter numbers as '''1,2,3''' one below the other.

|| In order to auto-fill the serial numbers, click on the cell '''A4'''.  A little black box is visible at the bottom-right corner of the cell.  Drag it till cell '''A7''' and release the mouse button.

||So we click on the cell referenced as '''C3''' and type the expense for '''House rent''' as '''Rupees 6000'''.

|| Now, what if we want precede the number with the Rupee symbol?

|| This will open the '''Format Cells''' dialog box.

||The first tab is '''Numbers'''.  Click on it if not already selected.

|| Lets select '''Currency'''.

||Now under the '''Format''' option, click on the down arrow.  This will display the various currency symbols from across the world.

||Lets scroll up and select '''INR''' Rupees English India.  By default, '''Rupee 1234''' is selected in the drop-down below.   

||You can see a preview of it in the small preview area on the right.

||Notice that as we increase the number of '''zeroes''', the selection under Format has changed to Rupees '''1,234''' decimal zero zero indicating 2 decimal places.  

|| Notice the change is displayed in the preview area.

|| Click on Thousands separator to add the '''comma''' separator for each thousand. Once again, notice the change in the preview area.   

|| One can also change the font style by clicking on the Font tab.  It has various options for '''Font, Typeface and Size'''.

||Lets click on '''OK'''.

|| Lets type '''800''' and press '''Enter'''.  You will notice that the number 800 is represented as Rupees 800 with 2 decimal places.

|| Now, lets select cells '''C5''' to '''C7'''.  Hold the CTRL key and select cell '''G2''' also.  Notice all the selected cells are highlighted.

||Choose the same options as before.Click on '''OK'''.

|| Now, we type the expense on all the other items one below the other as '''Rupees 600''' for '''Phone bill''', '''Rupees 300''' as '''Laundry''' charges and '''Rupees 2000''' as other '''Miscellaneous''' charges.

|| Under the heading '''Accounts''' we type the salary for the month as '''Rupees 30000'''.

|| For entering date in Calc, select the cell and type the date.

||Calc recognizes a variety of date formats.

||Also, the Format code is displayed below as '''MM, DD and YYYY'''.  One can change the Format code as required.   

||I will type '''DD, MM and YYYY'''.  Notice the change in the preview area.

Click on '''OK'''.

||Let us undo the changes.

|| After learning how to write text, numbers and dates in Calc, we will now learn how to navigate within a spreadsheet from cell to cell and from sheet to sheet.   

||So we will first see how we can navigate from cell to cell within a spreadsheet.

|| You can simply access a particular cell by clicking on it with the cursor.

|| Another method of accessing a particular cell is by using a cell reference.

||Now type the cell reference of the cell you want to go to and press '''Enter''' .

||You can even click into the '''Name box''', delete the existing cell reference and type in the cell reference you want and press '''Enter'''.

|| To move the focus using the cursor, simply move the cursor to the cell where you want|the focus to be and click the left mouse button.

||'''Shift + Tab''' to go to the previous cell in a row,

||'''Shift + Enter''' to go to the previous cell in a  column.

|| Next we will learn how to navigate between different spreadsheets in Calc using the keyboard.

||Detailed information on this is available in the tutorial '''Working with Sheets'''.

|| If you have a number of sheets, then some of the sheet tabs may be hidden behind the horizontal

scroll bar at the bottom of the screen.

||If this is the case, then the four buttons at the bottom-left of the sheet tabs can move the tabs into view.

||Let us undo the changes.

|| For selecting a range of contiguous cells with the cursor, first click in a cell.

||Now press and hold down the left mouse button.

||Move the cursor around the screen and once the desired block of cells is highlighted, release the left mouse button.

You see that the selected cells are highlighted.

|| In order to select multiple columns or rows that are contiguous click on the first column or row in the group.

||To select multiple columns or rows that are not contiguous click on the first column or row in the group.

||All the tabs between these two sheets will turn white, which indicates that they are all selected.

||Any actions that you perform will now affect

all highlighted sheets.

|| For selecting multiple non- contiguous sheets, Click on the sheet tab for the first sheet.

||Now move the cursor over the third sheet tab.

||Hold down the '''Control''' key and click on the sheet tab.

||How to enter numbers,  text , numbers as text, date and time in Calc.

||How to use the '''Format''' Cells dialog box.

||How to select items in '''rows, columns''' and '''sheets'''.

|| COMPREHENSIVE ASSIGNMENT

||Open '''Spreadsheet Practice.ods'''

||Under '''Serial Numbers''' type the serial number from 1 to 5 one below the other.

||Select all the items under serial number.

||Add a column for Date and Time.

||Enter some values in them using the Format Cells dialog box options.

||*Watch the video available at the following link

||*It summarises the Spoken Tutorial project

||*If you do not have good bandwidth, you can download and watch it

||The Spoken Tutorial Project Team

||*Conducts workshops using spoken tutorials

||*Gives certificates for those who pass an online test

||*For more details, please write to '''contact at spoken hyphen tutorial dot org'''

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

||*More information on this Mission is available at

||*'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''

||*This tutorial has been contributed by ...............................(Name of the translator and narrator)

 

||*Thanks for joining