Chapter 13Getting the most from formulas and functions
Performing calculations in Excel worksheets
Relative versus absolute referencing
Using range names in formulas and functions
Referencing cells or ranges on other worksheets
Copying and moving formulas and functions
Proofing your formulas and functions
Excel’s real power lies in its ability to do calculations. We enter values into Excel because we want to have those values acted upon by formulas or functions. Excel is all about answers, and the answers are provided by the various formulas and functions that you place in your worksheet. Whether you are a biologist using statistical ...
Get Microsoft Office 2019 Inside Out, First Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
