Thursday, January 21, 2010

Quick Quiz- Entering Functions

The five methods you can use to enter functions in Excel are the average, the lowest, the highest, the range, and the Auto Sum. You write =AVE and that will give you the formula, for the lowest you write =MIN and that will give you the formula, for the highest you write =MAX, for the range you go to insert function (fx) and then type range and click on the SUMIF, and for the Auto Sum you just click on the Auto Sum button in the home tab. So if you know the formulas it will be easier to type them than to go to insert functions (fx) and look for them. So theirs is five different functions to enter formulas.

No comments:

Post a Comment