Formula Essentials In Excel 2007
In order to create formula in Microsoft Excel begin by typing an equal sign this distinguishes it from other types of data. A formula consists of groups of expressions. There are three key elements in these expressions arithmetic operators such as add & subtract; functions; & references to worksheet.
To create a formula which returns the total of two of the numbers in a spreadsheet say 24 & 12 you simply type “=24 12″. When you press the Enter key you would get the correct result. However the formula would not be linked to the two cells containing the numbers. If the entry in either of the cells were to change the formula would still give the old result.
Obviously the solution is to ensure that our formula contains a reference to the two cells in question. The simplest way of doing this is to click on the first cell having typed “=”. Excel then automatically creates a reference to that cell. Next type the plus sign & click on the second cell. Excel creates a reference to the second cell & we then confirm the formula either by clicking on the Enter button on the left of the formula bar or pressing the Enter key on the keyboard.
Once your formula contains a reference to these two cells any time the contents of the cells change the result produced by formula will be updated.
If this were the only way of performing calculations in Excel formulas would become very long & extremely complex. To avoid this situation we can use Excel’s built-in functions. Functions carry out complex mathematical calculations without the user having to worry about how the result is reached.
For example let’s say that we wanted to total the contents of a hundred different cells. If we relied purely on the plus sign we would end up creating a formula with a hundred different arguments; in other words a reference to each an every cell. Instead we can simply use the SUM function.
To insert a function into a formula type an equal sign followed by the name of the function. Next type open parentheses & enter the arguments of the function. The arguments of a function are the parameters required by that function in order to return a result. When using the SUM function the arguments are the references of the cells contain the numbers we want to total. We can generate these references by clicking or dragging across the cells in question.
Having entered references to all the cells containing numbers that we want to total press the Enter key to add the formula to the worksheet. You don’t even need to put in the closing parentheses. Excel will close them automatically.
The author is trainer & developer with Macresource Computer Training an independent computer training company offering Excel courses in London & all over the UK.
Find competent suggestions in the sphere of buy PlayStation 3 this is your personal knowledge base.