Ad Code

Ticker

6/recent/ticker-posts

Commercial package of MS-Office: MS-Excel

3. MS-Office: MS-Excel



  • MS-Excel

   Microsoft Excel is a spreadsheet package used for calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. MS-Excel has replaced another spreadsheet package Lotus 1-2-3. The current versions of MS-Excel are MS-Excel 2010 for Windows and 2011 for Mac.

 
  • Definition Of Spreadsheet

   Spreadsheet package uses a grid of cells arranged in numbered rows and lettered named columns to organize data manipulations like arithmetic operations.

   MS-Excel is an electronic spreadsheet program that then can be used for storing, organizing, and manipulating data. MS-Excel contains all the basic features and functions of a spreadsheet package. In spite of a grid of rows and Columns, it has special Functions to perform advanced statistical, engineering, and financial calculations.

   The intersection of row and column in excel is known as cell i.e. a small rectangular box. As there are many cells in one workspace, each all had specific addresses to identify it is known as a cell reference. The cell reference is a combination of the column letter and row number. e.g. A10, B5, etc. Each workspace contains different worksheets the default name each of each worksheet is sheet 1, sheet 2, sheet 3, and so on. Functions in Excel help users to perform common tasks easily. Excel files are saved with extension .xls. The default file name of the excel file is is Book 1.

 
  • Features of Excel


   1. Excel supports charts, graphs generated from a specified group of cells.

   2. The analysis becomes very easy with the Pivot table.

   3. Sorting of data saves the user from the hassle of rearranging the records manually in a specific order.

   4. To use a single formula that adjusts for each row in a table, the calculated column can be created. It automatically expands to include additional rows so that the formula is immediately extended to those rows.

   5. The filter can be created on the basis of specific conditions.

   6. With the help of conditional formatting, a set of rules can be defined for all formatting. If the rules are met, then the formatting is applied.

   7. The goal seek feature enables the user to see how one data item in a formula impacts another.

 

  • Steps to Start MS-Excel


   To start Excel, go to Start Button, click and select MS-Office from Program Menu.

   Start --> Program --> MS-Office --> MS-Excel.

 

   Windows components are the same in every package. Specific components of Excel are:

   1. Cell Number Box: This Box contains the address of the cell where the current cursor is placed on the cell.

   2. Formula Box: The contents which are typed in a cell are shown in Formula Box.

   3. Worksheet Scroll Buttons: These buttons help the user for navigating from one sheet to another.

Post a Comment

2 Comments