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.