One of the most common tecniques which one applies is - search on google (if one has internet connection). Right? Or, in case you do not have the internet, you would go to Excel's 'Help' section and find out how to use the function. (The second option is the best if someody ask me)
But what if you do not have time to go through the Excel's documentation to read the whole content and understand the stuff that Microsoft has written for you. And, all what you want to know is just what all arguments go into a function. (You can also refer to Excel Math Functions explained by Excel Matic)
Microsoft has taken care of this also. They have integrated in Excel something which I call as short-cut Help. Whenever you are writing a function, which you do not know about, you can acces this help.
How to get this help
Start writing the function, write the name of the function and only the opening brackets (to input the arguments, but do not input any arguments)
It should look like this -
= FunctionName(
After you have written this much, press CTRL+A. On pressing these key combinations the function wizard will pop up and will guide you through writing that particular function. You can also get this wizard by using the Menu bar (Menu Ribbon for Office 2007).
Whenever you use the menu bar to insert the function, the function wizard pops up and guides you through writing the function.
0 comments:
Post a Comment