Abstract
It is in formulas and functions that Excel’s true power resides because it is through them that calculations and evaluations are processed and relationships between items of data are created. Formulas can range from simple addition or subtraction calculations to formulas that handle nonnumerical data and more sophisticated three-dimensional or array formulas. Functions are basically predefined formulas built into Excel to facilitate complex or cumbersome calculations and to enable you to carry out a wide variety of analytical tasks. Most of Excel’s analytical tools, like the PivotTables or data tables discussed in previous chapters, are simply user-friendly facades for the multiple complex formulas and functions required to produce particular analyses and reports.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2007 Helen Dixon
About this chapter
Cite this chapter
(2007). Formulas and Functions. In: Excel 2007. Apress. https://doi.org/10.1007/978-1-4302-0389-6_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0389-6_10
Publisher Name: Apress
Print ISBN: 978-1-59059-798-9
Online ISBN: 978-1-4302-0389-6
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)