Ms Excel is an electronic spreadsheet that is used to create accounting statements and we present these statement graphically.
Key Terms
Workbook
workbook like a folder that contain sheets, workbook is a file name and this file we found number of sheets, by default on workbook contains one sheet in excel 2013, and we have the option to add unlimited sheets in book.
Sheet
Sheet is the combination of columns and rows, Sheet consists of number of columns and rows,in excel columns recognized as alphabet and rows in numbers, but still we have the option to represent our columns also in numbers.
Cell
One column and one row make single cell, its mean there is a number of cells in sheet.For example, A is a column and 1 is row, so A1 is Cell.One cell is also called reference.
Work space file
if we open more than one workbooks in excel, and show all workbook windows as tiled, so number of files that is appear on one screen called workspace file. we also have a option to save all different files as on file.
Total Columns in Excel sheet:16384
Total Rows in Excel sheet:1048576
Total Rows in Excel sheet:1048576
Jumping Tricks.........
if you want to move your cursor or pointer just press END key and then press right arrow from direction pad.
Similarly if you want to move your pointer from any row to last row, so press END key and then press down arrow key from numeric keypad.
Type of Addressing in Excel
There are two type of addressing in excel.
- Absolute Addressing
the exact address of a cell, regardless the position of a cell that contain the formula. the absolute cell reference take the form$column and $row.
Example no.1 $A$1
Example no.2 $a$100
The main advantage of this type of formula is if you want to copy exact cell in different locations.
The main advantage of this type of formula is if you want to copy exact cell in different locations.
- Relative Addressing
Address of a cell based on the relative position of cell that contains a formula and cell reference, if you copy this formula the reference automatically adjusts. A relative reference take the form ColumnRow
Example no.1 A1
Example no.2 A100
in many cases we used this type of addressing.
in many cases we used this type of addressing.
No comments:
Post a Comment