Microsoft Excel is spreadsheet software in the Microsoft Office Suite widely used to perform mathematical calculations. The data is spread in a tabular form consisting of rows and columns. It provides built-in features and tools such as formulas, functions and data analysis tools that make it easier to work with large amount of data.
Spreadsheet are primarily used to work with numbers and text. A file of MS-Excel is called a workbook and it contains multiple worksheets or spreadsheets. A worksheet is divided into a series of rows and columns to store the information. MS-Excel helps us to:
Arrange data in an organized way.
Compare data through charts
Sort data for better analysis.
Compare two workbooks side by side.
MS-Excel allows you to store, organize, and analyze numerical and text data. You can use this robust application to enter numerical values or data into the rows or columns of a spreadsheet and to use these numerical entries for calculations, charts, formulas, statistical analysis etc.
Components of Excel Window
Title Bar :- The title bar displays both the name of the application and the are of the spreadsheet.
Menu Bar :- The men bar displays all the menus available for use in Excel XP. Te contents of any menu can be displayed by clicking on the menu name with the left mouse button.
Toolbar :- Some commands in the menus have pictures or icons associated with them. These pictures may also appear as shortcuts in the Toolbar.
Column Headings :- Each Excel spreadsheet contains 256 columns. Each column is named by a letter or combination of letters.
Row Headings :- Each spreadsheet contains 65,536 rows. Each row is named by a number.
Name Box :- Name box shows the address of the current selection or active cell.
Formula Bar :- Formula bar displays information entered or being entered as you type in the current or active cell. The contents of a cell can also be edited in the formulas bar.
Cell :- A cell is an intersection of a column and row Each cell has a unique cell address. In the picture above, the cell address of the selected cell in B3. The heavy border around the selected cell is called the cell pointer.
Navigation Buttons and Sheet Tabs :- Navigation buttons allow you to move to another worksheet in an Excel workbook. Used to display the first, previous, next or last worksheets in the workbook.