MICROSOFT EXCEL FEATURES

MICROSOFT EXCEL

  • Microsoft Excel is a spreadsheet application.
  • It is a part of MS Office.
  • It features Calculation, graphic tools, Pivot tables and a macro programming language called Visual Basic for Application (VBA).

MICROSOFT EXCEL FEATURES

  • Worksheet : It is a grid of cells made up of horizontal rows and vertical columns . It contains 65536 rows and 256 columns.
  • Row Number : Each row is given a number .
  • Column Letter : Each column is given a letter starting from A, …,Z ,AA,…..ZZ and so on.
  • Cell : It is basic unit of worksheet where numbers ,text ,formulae etc ., can be place.
  • Cell Pointer : It is a cell boundary that specifies which cell is active at that moment.
  • Current Cell : It is a cell which is active.
  • Range of Cell : It is a group of contiguous cells that forms a rectangular area in shape.
  • Work Book : A worksheet is a grid of cells made up of rows and columns .
  • Data in Worksheet : Three types of data can be entered numbers/characters ,text and formulae.
  • Formula : It is a sequence of values , cell address ,names functions or operators in cell that produces a new value form existing values.
  • Cell Referencing : Each cell in worksheet has a unique address ,when cell address is referred in formulas it is called Cell Referencing .
  • Relative Referencing: Cell Referencing in which the cells are refereed by their relative position in which worksheet relative to a particular cell.
  • Absolute Referencing : Cell referencing in which the cells are referred by their fixed position in the worksheet.
  • Mixed Referencing : Combination of relative and absolute referencing .
  • Functions : Functions are predefined formulae, that perform calculations by using specific values called arguments.
  • Structure: The structure of a function begins with the function name, followed by an opening parenthesis argument for the function separated by commas and a closing parenthesis.
  • Charts: Charts are the pictorial representation of worksheet data.
  • Area chart: An area chart emphasises the magnitude of change over time.
  • Column chart: A column chart shows data changes over a period of time.
  • Bar chart: It illustrates comparisons among individual items.
  • Line chart: It shows trends in data at equal intervals.