98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formuals and Functions
Formuals and Functions
Resolved · Urgent Priority · Version 2003
Deorne has attended:
Excel Intermediate course
Excel Advanced course
Formuals and Functions
I want to understand how to use the fx key.
RE: Formuals and Functions
Hello Deorne
Thank you for your question and welcome to the forum.
Are you referring to the fx button that is up near the top of the screen in Excel; or the function keys (e.g. F1, F2 etc) on the keyboard?
Amanda
RE: Formuals and Functions
Hello Amanda,
I'm referring to the fx button as you've suggested.
Many thanks
Deorne
RE: Formuals and Functions
Hi Deorne
Thanks for clarifying.
The fx button is referred to as the Insert Function button.
It's purpose is to allow you to search for and insert functions into a spreadsheet.
If you select the cell where you want the function to go in your spreadsheet, then click the Insert Function button, you will then be able to search for a function (e.g. IF function).
Then you select the function you wish to use from the options presented, and click OK.
At the following screen, you will be presented with the parts of the function (called arguments) that you need to enter into the function in order to obtain a result. Some functions have more arguments than others. Once you have filled in all the arguments, then click OK and if Excel can figure out a result for you based on the arguments you have entered, then this will display in the spreadsheet.
Kind regards
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |