Excel 2010 Functions & Formulas
ISBN: 978-1-55374-269-2
Functions and formulas are powerful and versatile tools that can perform a variety of calculations using your spreadsheet data. Formulas automate your work, instantly adding up section totals, calculating averages and percentages, and much more. Functions are pre-defined formulas that simplify and standardize statistical, financial, and other calculations. Many Excel functions draw from basic programming formats (e.g. IF/THEN statements). Functions like SUM can be added to your worksheets to dynamically update and display results as data is added or changed.