May 22, 2011

Excel Basic Terminology


Excel Basic Terminology
Excel helps in making our financial budgets more easier to plan and easy to make. There are few basic terms that we need to learn if we want to use and understand excel. They are necessary as they help in understanding the excel better if we know them.

They are:

1) Cell:
The single entity that can be fed with any data and that has a name or identification column name row number. Example: A1 indicates the cell that is in column A and row 1.

2) Column:
The vertical cells that are named with alphabets in a sheet are called Columns. The maximum number of columns we have in a sheet are 256 by default.

3) Row:
The Horizontal cells that are given numbers in a sheet are called rows. By default we have 65536 rows in a sheet.

4) Sheet:
It is the a page where we have rows and columns in a Excel application. By default we get three sheets in a single book. A spreadsheet is a computer application that simulates a paper or accounting worksheet. It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns. It is also called as worksheet. A worksheet is a collection of cells on a single "sheet" where you actually keep and manipulate the data.

5) Workbook:
A workbook is the MS Excel file in which you enter and store related data.

6) Workspace:
When we do some work in cells that we cannot remember in their names, we can save the cells where we have entered some data. The specified range of cells where we have written data is saved as workspace.

7) Range:
It specifies certain group of cells with starting and ending cell addresses. Ex: A1:C6


Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More