MS EXCEL - 2007(THEORY)

                  
  MS EXCEL - 2007(THEORY): 
Microsoft excel is a spreadsheet application program offered in the Microsoft office software package. This program allows you to perform calculations and use graphic tools, pivot tables  and a macro programming language called VBA. In addition, excel can also be used to create charts and graphs.


1>COLUMN: The vertical lines in a sheet is known as column. There are total column in a sheet is 16384. The default width of a column is 8.43 point.

2>ROW: The horizontal lines in a sheet is known as row. There are total 148576 rows in a columns. The height of a row by default is 15 point.

3>WORKSHEET: The sheet in a workbook from in combination of rows and columns to perform different . Arithmetical and logical calculations is known as worksheet as it is electronic while opening excel 3 worksheet open by default.

4>WORKBOOK: While opening MS excel the application screen that appear with some tools and 3 sheets by default to perform different calculations.

5>CELL: Intersection of row and column is called cell.
                 Cell = Column*Row

6>GRID LINES: The line which separate rows and columns is called grid lines. It is non printable area by default.

7>GOAL SEEK: Goal seek is a option through which we can obtain any target value by changing other data.

8>SUBTOTAL: Subtotal is a system through which we can consolidate any subject wise value depending on the condition.

9>AUTO FILL: Auto fill is an option which helps the user to automatically fill the above data underneath.

10>FILTER: Filter is an option through which we can sort out the value depending on a criteria given by the user.

11>RIBBON: The ribbon, a panel that houses the command buttons and icons , organizes commands as a set of tabs , each grouping relevant commands. Each application has a different set of tabs which expose the functionality that application offers.

12>AUTOSUM: The autosum button allows you to quickly insert the sum function.It is located in two places on the ribbon. On the right end of the "HOME" tab in the editing section , and on the far left of the "FORMULA" tab. Select the cell where you want to put the total and then click on the autosum button. Excel will insert the sum function and take a guess as to what cell range you'd like to sum by listing the first and last cell in  the sum , separated by a colon .Check to make sure the cell range is correct, then press enter to accept the function.

13>AUTOCALCULATE: Excel will automatically perform calculation on a set of cells that you select and display the results on the status bar in the bottom right of your window. The default calculation is the sum function , but you can change the calculation by right clicking or control+clicking(MAC) on the autocalculate result.

14>PIVOT TABLE: A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet. It is an interactive representation of a data table. One can rearrange the data and choose what to display and what to hide.The best way to find out what a pivot table can do is to create one.

15>CHARTS: A full discussion of excel"s many charting options is beyond the scope of this handout. However, it is fairly straightforward to create a simple chart using the chart wizard. Just highlight the data you wish to base your chart on and click on the insert tab and you will see the available charts there. When you click on a type of chart , you will be promoted to select a subtype of chart. Once you have done so, the chart will appear on your spreadsheet. Three additional tabs will also appear on your ribbon , through which you can alter your chart by adding titles, changing data points and many other options.

16>NAME MANAGER: You can use name manager to name a group of cells, and therefore only type one name when you want to perform a calculation with that group. This can be useful when you are performing many different calculations on the same set of numbers, especially when you want to perform these calculations across multiple sheets. To do this, select the cells you would like to name and name them in the "name box" next to the formula bar. You can then perform any function on these cells by just typing the name you gave the cells instead of referencing the cell numbers. You can edit the names you gave the cells and change which cells they refer to by clicking on "name manager" on the "formula" tab.

17>FUNCTIONS: Excel has created hundreds of functions that prevent you from having to write out complex or repetitive formula yourself. Functions can be inserted by clicking on the function symbol to the left of the formula bar. Functions can also be inserted by clicking on the "insert function" button on the "formula" tab or jumping to any of the subcategories of functions on that tab. Yet another way to insert a function is to type the equals sign into a cell and begin to type the name of formula. A drop down menu will appear, from which you can select the formula.

18>FORMULAS: Select the cell that the formula result is going to be displayed in. The formula can be constructed in the formula bar or typed directly into the cell in which you want the formula to begin. You must always put the = sign before a formula , as this is how excel recognizes what you are entering as a formula. Autofill helps you fill in formula quickly once you have constructed one in a cell. In order to autofill, select the cell with the formula.

19>CELL REFERENCES: There are two different types of cell references -----
a>relative cell references: Cell references that change when the formula is autofilled into different cells.
b>absolute cell references: If you don't want a certain part of your cell reference to change when you copy the formula to a new cell, you need to put a $ in front of the row and /or column part of the reference.