Generally used to run a cell or range of cells in the calculations in Excel. So if you're a value of one is an employee in cell "A2", where "a" defines the column and was '2 'defines the line, and you have a different salary amounts in cell "A3" and so on, A1 you calculate the sum of wages as "= SUM (: A20) in cell" A21 ", in which all cells from'a1" A20 "to" filled with the workers 'salaries'. Is there a more simple and intuitive to do this? Yes! You can assign the contentData in cell "A1" in cell "A20" of all those cells, and type a name in the field, "as" content. "The 'name' field is the text box next to the Formula box (FX) and an arrow next to it. Another way to assign a name is to select the appropriate cells, and then click Insert and click on 'Name', and, finally, define'...' and become a new pop-up window appears. Here you can define the term "salary" in the text box under "Names in workbook. Here, one could also observein the text box under the title 'refers to' the cell that has the exact weight of the name 'assigned. In addition, you will discover that you are adding more names of other ranges of cells can. In this window, there is an option name, use the removal no longer want to be, too.

Well, as the name or names, in order to do calculations? Well, you could, with a cell suitable for your choice "= SUM (salary) and write the sum of salaries in those cells that may be appropriate. Another interesting example ofMore info: Suppose you have 3 sheets in the workbook. Right-click on the first sheet (Sheet1) and the menu, select "Rename" and give the paper the name of "income". Right mouse button on the first page, select "Tab Color ..." menu and assign a color, for example, blue for the tab of the worksheet. Have similar actions on sheet 2-3, and rename it to "expenditure" and "profit / loss replaced. Even the note card in color worksheets. Suppose we enter 'income' per month.

SoThere are 12 entries for "income" in 12 different cells, for example, "A2" to "A13" with cell "A1" under the heading "income". Similarly, we take for granted that the cost of each month to Sheet2 in cell "A2" to "A13" with "cost" as a title in "A1". Note: You can, of course, select all the cells of data. Now we want the name to be cells A1 to A13 in both worksheets 1 and 2, "or income" and "costs". In worksheet 3, which was renamed it was win-lose "We can now enter a formula'= Sum (nonprofit)-sum (expenses) in each cell of our choice to compute the gain or loss! Remember that you can package your expenses and income in more detail that you want. As long as the cells are supplied with data is a name you can not for profit and loss calculations are running as usual with the name of "areas with a reasonable formula.

Visit : Review Computers and neteboox SNSD Thai IPod touch