Working with spreadsheet
Spreadsheet package enables to complete the tasks easily which require effort and
time like long calculations, comparisons, graphical representation ,etc
Store and arrange data
Compute and analyze data
Features :
o Long and complex calculations can be solved easily
o Data can be exported or imported from other applications.
o A huge amount of data can be stored and handled.
o Data can be presented in the form of tables and graphs
o Formulae for calculation can be automatically applied.
Note : Visicalc was the first spreadsheet to be invented in 1979. Lotus1-2-3, Calc,
Excel, Quattro PRO, etc.
LibreOffice Calc , Ms Excel and Open office Calc are the commonly used packages.
OpenOffice Calc is developed by Sun Microsystems.-free and easily downloadable.
Parts of a screen
1.Workbook- It is a collection of worksheets. It opens with 3 worksheets. Their name appears
towards the bottom of the page. The sheet on which we were currently working is active
sheet.
2.Worksheet- It is the working area or page on the screen. It is a collection of rows and
columns .
3.Rows- Rectangular box that are placed on top of eachother in a horizontal position.
Numbered from top to bottom along the left edge.
No of rows- 10,48,756
4.Columns – Vertical box that are placed adjacent to eachother. Labelled from left to right .
No of columns – 1024
First column -A First column – A (Excel)
Last column – AMJ Last column – 16348-XFD
5.Cells – intersection of a row and a column. It is the basic unit of worksheet where the data
is being entered .
6.Title bar – It lies at the top of the window . It displays the name of the active workbook. –
Default-Untitled1
7.Menu bar- It is located below the title bar . It has various menus. Either click on them or on
alt along with the underlined character of the menu name
8. Standard Toolbar- It lies below menu bar . It contains frequently used buttons
9.Formatting Toolbar – It liesbelow the standard toolbar . It contains shortcut buttons that
helps in formatting to provide access to options,
10.Formula Bar – Below FT. It performs different calculations is entered and displayed here.
Its denoted by `fx`.
o Name box – cell reference – A1 or D10
o Sum- Total of the numbers selected
o Functions wizard-List of available functions
o Function-Function icon and inserts an = sign into the selected cell
o Input line- Displays the contents of active cell.-editing can be done.
11.Name box- Beside FB. Contains the address of active cell.
, 12.Status Bar – It lies at the bottom. It shows the current status .
13.Cell Address- Column position followed by its row number.
14.Horizontal scroll bar – It lies below the sheet at the right side of the sheet tabs. Scroll from
right to left and vice versa.
15. Vertical scroll bar- It lies towards the right side of worksheet. Top to bottom and vice
versa.
16.Cell pointer-Active cell in a worksheet .Highlighted with bold border.
17.Active cell – The selected or activated cell is always highlighted with thick borders .It
needs to be first selected by placing a cursor on it.
Types of data
1.Numeric data – consists of digits from 0-9 and operators like +,*,%,#,etc.
2.Alphanumeric- (alphabets+ spaces+ digits+ characters) .It is mentioned within double
quotes “”. Alphanumeric data is assigned towards the left side and not for calculation.
3.Date and TIME – Sequential numbers are known as serial values . Time is displayed as a
fractional part.They are aligned towards the right.
4.Formula-It helps to perform arithmetical calculation and also executes non – arithmetical
tasks. Has operators and operands. Formula has to be expressed with = before the
operator /data .
Creating a workbook
Step1- Click on File menu . Select `new` option.
Step2-Click on spreadsheet.
Step3- A new workbook named untitled 1 appears on the screen.
Entering data in worksheet- To enter data in the cell , click on it and the typed data is
visible in the formula bar . Press `Enter` key or move the cursor or click on the other cell
simply.
Moving in a worksheet –
Shortcut keys
1. Ctrl+N open a new workbook
2. Ctrl+S save an existing document
3. Ctrl+W close a workbook
4. Ctrl+Q exit from spreadsheet
5. Ctrl+O open an existing file
6. Ctrl+P Print a document
7. Ctrl+Shift+S save a new workbook
8. Ctrl+A Select everything
9. Alt +pg up One screen to left
10. Alt+ pg down One screen to right
11. Reach A1 Ctrl+Home
12. Next sheet Ctrl+ pg down
13. Previous sheet Ctrl+ pg up
14. Previous opened workbook Ctrl+Shift+Tab
Ctrl+Shift+F6
15. Select a row Shift+Spacebar in active cell
16. Right Tab
Spreadsheet package enables to complete the tasks easily which require effort and
time like long calculations, comparisons, graphical representation ,etc
Store and arrange data
Compute and analyze data
Features :
o Long and complex calculations can be solved easily
o Data can be exported or imported from other applications.
o A huge amount of data can be stored and handled.
o Data can be presented in the form of tables and graphs
o Formulae for calculation can be automatically applied.
Note : Visicalc was the first spreadsheet to be invented in 1979. Lotus1-2-3, Calc,
Excel, Quattro PRO, etc.
LibreOffice Calc , Ms Excel and Open office Calc are the commonly used packages.
OpenOffice Calc is developed by Sun Microsystems.-free and easily downloadable.
Parts of a screen
1.Workbook- It is a collection of worksheets. It opens with 3 worksheets. Their name appears
towards the bottom of the page. The sheet on which we were currently working is active
sheet.
2.Worksheet- It is the working area or page on the screen. It is a collection of rows and
columns .
3.Rows- Rectangular box that are placed on top of eachother in a horizontal position.
Numbered from top to bottom along the left edge.
No of rows- 10,48,756
4.Columns – Vertical box that are placed adjacent to eachother. Labelled from left to right .
No of columns – 1024
First column -A First column – A (Excel)
Last column – AMJ Last column – 16348-XFD
5.Cells – intersection of a row and a column. It is the basic unit of worksheet where the data
is being entered .
6.Title bar – It lies at the top of the window . It displays the name of the active workbook. –
Default-Untitled1
7.Menu bar- It is located below the title bar . It has various menus. Either click on them or on
alt along with the underlined character of the menu name
8. Standard Toolbar- It lies below menu bar . It contains frequently used buttons
9.Formatting Toolbar – It liesbelow the standard toolbar . It contains shortcut buttons that
helps in formatting to provide access to options,
10.Formula Bar – Below FT. It performs different calculations is entered and displayed here.
Its denoted by `fx`.
o Name box – cell reference – A1 or D10
o Sum- Total of the numbers selected
o Functions wizard-List of available functions
o Function-Function icon and inserts an = sign into the selected cell
o Input line- Displays the contents of active cell.-editing can be done.
11.Name box- Beside FB. Contains the address of active cell.
, 12.Status Bar – It lies at the bottom. It shows the current status .
13.Cell Address- Column position followed by its row number.
14.Horizontal scroll bar – It lies below the sheet at the right side of the sheet tabs. Scroll from
right to left and vice versa.
15. Vertical scroll bar- It lies towards the right side of worksheet. Top to bottom and vice
versa.
16.Cell pointer-Active cell in a worksheet .Highlighted with bold border.
17.Active cell – The selected or activated cell is always highlighted with thick borders .It
needs to be first selected by placing a cursor on it.
Types of data
1.Numeric data – consists of digits from 0-9 and operators like +,*,%,#,etc.
2.Alphanumeric- (alphabets+ spaces+ digits+ characters) .It is mentioned within double
quotes “”. Alphanumeric data is assigned towards the left side and not for calculation.
3.Date and TIME – Sequential numbers are known as serial values . Time is displayed as a
fractional part.They are aligned towards the right.
4.Formula-It helps to perform arithmetical calculation and also executes non – arithmetical
tasks. Has operators and operands. Formula has to be expressed with = before the
operator /data .
Creating a workbook
Step1- Click on File menu . Select `new` option.
Step2-Click on spreadsheet.
Step3- A new workbook named untitled 1 appears on the screen.
Entering data in worksheet- To enter data in the cell , click on it and the typed data is
visible in the formula bar . Press `Enter` key or move the cursor or click on the other cell
simply.
Moving in a worksheet –
Shortcut keys
1. Ctrl+N open a new workbook
2. Ctrl+S save an existing document
3. Ctrl+W close a workbook
4. Ctrl+Q exit from spreadsheet
5. Ctrl+O open an existing file
6. Ctrl+P Print a document
7. Ctrl+Shift+S save a new workbook
8. Ctrl+A Select everything
9. Alt +pg up One screen to left
10. Alt+ pg down One screen to right
11. Reach A1 Ctrl+Home
12. Next sheet Ctrl+ pg down
13. Previous sheet Ctrl+ pg up
14. Previous opened workbook Ctrl+Shift+Tab
Ctrl+Shift+F6
15. Select a row Shift+Spacebar in active cell
16. Right Tab
