19. Using Functions
In This Chapter
• Entering Functions Using the Function Arguments Dialog Box
A function is like a shortcut for using a long or complex formula. If you’ve ever summed cells by adding them individually (as in =A1+A2+A3+A4+A5), you could have instead used a SUM function like this: =SUM(A1:A5). Excel offers more than 400 functions. These include logical functions, lookup functions, statistical functions, financial functions, and more.
This chapter shows you how to look up functions available in Excel and reviews some functions helpful for everyday use.
Tip
Only a handful of Excel’s functions are reviewed here. For a more in-depth review ...
Get Office 2013 All-In-One Absolute Beginner’s Guide 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.
