Excel is very powerful and easy easy to use separate seed package, which is begin commonly used these days. You don't works very well with numbers and their complex calculation. Excel help to prepare your data in a organized, orderly and meaningful fashion. Excel files it measure contribution in creating reports using formulas and performing calculations.
Excel can also be used to prepare profit and loss accounts balance sheet and other tax statement. It can be used for preparing analytical reports including statistical analysis, forecasting and regression analysis.
Good looking and attractive chart can be creed which depressed data in clerk and meaningful fashions. Excel can also we use to create relationship between different type of data. Excel can do all the work of a full - fledged word processor but it legs the advantage features of desktop publishing. It also supports the high level features of object linking and invading which means data for what can be safely and easily pot and linked with data in excel and vice versa is also true.
How to Start Microsoft Excel -
To start XL you have to follow the following steps.
- Click on the start button.
- Select all programs option.
- Select Microsoft office options.
- Now select Microsoft Excel option.
Components of Excel Windows -
Normal XL window has the following components.
- Title bar
- Menu Bar
- Standard bar
- Formatting toolbar
- Status bar
- Formula bar
- Cell
- Rows
- Columns
- Name Box
- Help Assistants
- Scroll Bars
- Worksheet
Function of various components of Microsoft Excel :
Function of various components of Microsoft Excel is given below :
- Title bar : Title bar shoes the name of the documents and situated in the top of the windows.
- Menu Bar : Menu Bar contents the various menu such as : File Edit View, Format, Tools etc. Menu bar is located under the title bar
- Standard toolbar : Standard toolbar contents the most frequently used commands or short cuts to different menu options like - New, Save, Open, Print etc.
- Formatting toolbar : Formatting toolbar contains the various commands related to formatting of the documents like : Font, size, Font style, Font Color, Alignment, Bold, Italics etc.
- Status bar : It displays the positioning of the cursor displays the status of some important case of keyboard, choose the message for the toolbar when a mouse prints to it.
- Formula Bar : Formula barso you the formula instead of the result whenever you click on a cell in which you have a formula.
- Rows : Rows are combination of the horizontal sales joined together ine single horizontal lines. Excel workbook has maximum 65, 536 in a worksheet.
- Columns : Columns are combination of the vertical sales joined together in single vertical lines. Nxl workbook has maximum 256 columns in a worksheet.
- Cell : A Cell is an intersection point of row and column. It is use to store data. There are 65536x 256 = 16777216 cells. in a single worksheet.
- Name Box : This box shoes the name on the address of the currently active cells.
- Office Assistant : Office assistant provides you the online helps, real-time while working.
- Scroll Bars : There are two types of scroll bars :
- Worksheet :As name suggests it is the working area in which you can work. Each worksheet of a single worksheets has its own identity.
The Maximum Limit of The Worksheet in A Workbook 255.