Use of “Insert Function” in Microsoft Excel

Use of “Insert Function” from Formula Tab:

Using “Insert Function” button in Formula tab we can use all the available functions in Excel. The following box will appear on the screen. It contains all formulas and they are categories wise divided. We can avoid any syntax error using formula from this option (Insert function)

As picture shows, dialog box is appeared for sum function. We can type the numbers or range in the text boxes. More importantly we can select range using mouse, for this we can click red-arrow button, by this sum dialog box will reduce its size and then after selecting range we can re-click on this red-arrow button.