Microsoft® Excel 2007 Formulas
Description of formula used in Microsoft Excel 2007
In Microsoft Excel 2007, by using a specific style or applying a theme you can quickly format the data in your worksheet. One of the most useful features of Microsoft Excel 2007 is that it supports formulas. We can use the Excel 2007 formula for basic purposes, like addition, subtraction, division and lot more. By using any formula we can easily and accurately calculate either simple calculations like addition of two numbers or complex calculations meant for high-level business projections. All Excel formulas start with the equal sign (=). The equal sign always goes onto a specific cell where you want the formula’s answer to appear.
Some of the Excel formulas are mentions in the points below:
- MIN function
- MAX function
SUM function displays the sum of selected cells directly. Sum can be calculated by entering the number in the cell. Now, select the cell with numbers and press ‘AutoSum’ (âˆ‘) button. Example is =SUM (A1:A5)
AVERAGE function returns the average of its arguments. Average can be calculated by entering the numbers in the cell for average calculations and selecting the average function from the list of Excel functions. Else, enter the numbers in the cell for calculating the average and select a cell where the result needs to be displayed. Specify the cell as arguments in the AVERAGE function. Example is =AVERAGE (A1:A5)
MIN function returns the smallest values in a set of values. Like MAX function MIN function can be calculated in two different manners. Enter the numbers to find the minimum of numbers and select those numbers and select MIN from the list of Excel functions. Otherwise select a cell where the result is displayed and pass cell name as arguments. For Example =MIN (A1:A10)
MAX function returns the largest values in a set of values. For calculating the MAX function enter the set of numbers in cell and select that numbers and select the MAX function from the set of Excel functions. Otherwise, select a cell where the result is present and pass cell name as function argument. For example =MAX (A2:A6).
AND function checks whether all arguments are true and returns true if all arguments are true. AND function is denoted by * sign. For calculating you need to enter =SUM(IF(Test1*Test2*...*Testn)). For example =SUM (IF((A1:A10>=1)*(A1:A10<=10),1,0))