Scribd
Upload
15 views1 page

Excel 31

Chapter 3 discusses performing calculations on data using mathematical operators and Excel functions such as SUM, AVERAGE, COUNT, MAX, and MIN. These functions can be accessed from the AutoSum list and the Function Library in Excel. Additionally, the Formula AutoComplete feature aids in referencing functions and simplifies formula entry.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views1 page

Excel 31

Chapter 3 discusses performing calculations on data using mathematical operators and Excel functions such as SUM, AVERAGE, COUNT, MAX, and MIN. These functions can be accessed from the AutoSum list and the Function Library in Excel. Additionally, the Formula AutoComplete feature aids in referencing functions and simplifies formula entry.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Chapter 3: Perform calculations on data

You can perform mathematical operations on numbers by using the mathematical


operators for addition (+), subtraction (–), multiplication (*), division (/), negation (-),
and exponentiation (^). You can perform other operations on a range of numbers by
using the following Excel functions:

■ SUM Returns the sum of the numbers.


■ AVERAGE Returns the average of the numbers.
■ COUNT Returns the number of entries in the cell range.
■ MAX Returns the largest number.
■ MIN Returns the smallest number.

These functions are available from the AutoSum list, which is in the Editing group on
the Home tab of the ribbon and in the Function Library group on the Formulas tab.
The Function Library is also where you’ll find the rest of the Excel functions, organized
into categories.

Excel includes a wide variety of functions

The Formula AutoComplete feature simplifies the process of referencing functions,


named ranges, and tables in formulas. It provides a template for you to follow and
suggests entries for each function argument. Here’s how it works:

1. As you begin to enter a function name after the equal sign, Excel displays a list
of functions matching the characters you’ve entered. You can select a function
from the list and then press Tab to enter the function name and the opening
parenthesis in the cell or formula bar.

78

You might also like