In Excel 2010 you must have noticed that while typing the formula in a cell excel displays a list of functions starting with the characters typed in the cell as shown in figure 1.1 below…

Figure 1.1

Excel 2010 provides auto complete functionality to complete the function without the need to type it. To auto complete the desired function you can click the desired function name in the auto complete list or hit [TAB] key on the keyboard. The function name along with open parenthesis appears i the cell for you proceed with entering the function parameters as shown in figure 1.2 below.

Figure 1.2

Thus Auto complete makes life a bit easier for the power users.

I hope you found the information useful and Thank you for reading.