What is MS Excel ?
What is MS Excel ?
Ms Excel is an electronic program which is based on spreadsheet technology and allows us to store, organize and manipulate data.
If we understand it in a simple language then we can say, a paper sheet in electronic form to store and manipulate (working with data) data.
Electronic spreadsheet programs were originally based on paper spreadsheets used for accounting. As such, the basic layout of computerized spreadsheets is the same as the paper ones. Related data is stored in tables which are a collection of small rectangular boxes or cells organized into rows and columns.
All versions of Excel and other spreadsheet programs can store several spreadsheet pages in a single computer file. The saved computer file is often referred to as a workbook and each page in the workbook is a separate worksheet.
Spreadsheet Cells
When we look at any spreadsheet screen we see there is a collection of rows and columns in the grid form looks like a rectangular box which is simple called a cell.
In newer versions of Excel, each worksheet contains roughly a million rows and more than 16,000 columns, which necessitates an addressing scheme in order to keep track of where data is located.
The horizontal rows are identified by numbers (1, 2, 3) and the vertical columns by letters of the alphabet (A, B, C). For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC or AAA, AAB, etc.
The intersection point between a column and a row is the small rectangular box known as a cell. The cell is the basic unit for storing data in the worksheet, and because each worksheet contains millions of these cells, each one is identified by its cell reference.
A cell reference is a combination of the column letter and the row number such as A3, B6, and AA345. In these cell references, the column letter is always listed first.
No comments: