Microsoft Excel is a spreadsheet based program. There are many more applications in Microsoft and windows, but MS Excel is most used application among all. The reason behind its widely use are it features. It can be used in completing business tasks, analysis, inventory, invoicing, data management and many more.
Some major features are:
- Calculations (Number Crunching)
- Business Analysis
- Data Analysis
- Accounting & Budgeting
- Administrative Management
The important components of MS Excel you need to understand are:
- Cell
- Worksheet
- Workbook.
CELL
Cell is small but a very important part of a spreadsheet. Whatever, you input in spreadsheet by typing/writing, by copy paste, these all actions happens in a cell. Cell can be customised in size, colour, shape, borders etc.
Every Cell has its identification, it is called cell address/ cell reference. Cell is a intersection of a Column and Row.
WORKSHEET
Worksheet is also known as Spreadsheet. A worksheet is made of Cells, Columns and Rows. Every worksheet contains 16384 Columns and 1048576 Rows. Columns are run vertically and counted from A to XFD in alphabets. Cells are counted horizontally from 1 to 1048576 in numbers.
WORKBOOK
A workbook is made of worksheets/ spreadsheets. It can be one or more worksheet in a workbook. Worksheets of a Workbook can be adjusted/shifted, move, copy, delete and add.