Formulas and functions

Dear Victoria

Thank you for attending Excel Intro course. I hope you enjoyed the course and benefited from it.

I think it is a matter of personal preference as to which is teh quikest method of entering formula/functions. I personally like to type them myself because I am more used to the structure of the function.

e.g. if I want to do Average of cells B3: B10 I would type =Average(B3:B10).

But if someone is not very familiar with the structure of the function or not sure of the name then it is suggested that they use the fx button on the Formula bar.

If you are using the fx method for inputing functions then be very extra careful with the cells that teh function automatically selects for you. Ensure that the correct cells have been selected for your function. If they are not then manually select them.

I hope this helps!!

If this has helped in answering your question then can I please request you to mark this post as resolved!!

Many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007