excel

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

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

Excel

resolvedResolved · Low Priority · Version 2003

Edward has attended:
Excel Intermediate course

Excel

what is a nested function?
what is the capital of poland?

RE: excel

Hi Edward

Thanks for your questions.

a nested function is a term used to describe a function which uses another function as a value. For example the following would apply the round function to the results of a sum function:

=ROUND(SUM(A1:A5),1)

and the capital of Poland is Warsaw.

Hope this helps - let us know if you have any other MS Office questions.

Kind regards,
Andrew


 

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips


Server loaded in 0.08 secs.