formuals and functions

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formuals and Functions

Formuals and Functions

resolvedResolved · 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

RE: Formuals and Functions

Hi Amanda,

Thank you for explaining how this works. I know this will be relevant in my new role.

I'm happy for this to be resolved.

Kind regards,
Deorne

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Calculate age or service

The 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:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips


Server loaded in 0.08 secs.