Chapter 8
Using everyday functions: math, date and time, and text functions
Examples of date and time functions
Excel offers many functions for dealing with basic math, dates and times, and text. This chapter describes the functions that you can access with the Formulas tab using the Text icon, the Date & Time icon, and the Math portion of the Math & Trig icon.
Examples of math functions
The most common formula in Excel is a formula to add a column of numbers. In addition to SUM, Excel offers a variety of mathematical functions.
Using SUM to add numbers
The SUM function is by far the most commonly used function in Excel. This function can add numbers from one or more ranges of data.
Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) 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.
