### Introduction

By the finish of this lesson, you must be maybe to:Understand the meaning of a functionUse Excel XP functions in calculationsAccess Excel XP functionsFind the amount of a selection of data### Using functions

A **function** is a **predefined formula** the helps perform common mathematical functions. Attributes save you the time of writing lengthy formulas. You could use an Excel role called **Average**, because that example, to quickly uncover the typical of variety of numbers. Or you can use the **Sum** function to uncover the amount of a cabinet range. Excel XP consists of many different functions.

You are watching: Enter a formula in cell b7 to calculate the average value of cells b2:b6.

Each duty has a specific order, referred to as **syntax**, which have to be strictly followed for the role to work correctly.

Here is the syntax order:

All functions start with the equates to (=) sign.After the equals sign, define the**function name**(e.g., Sum).Add one or more

**arguments**—numbers, text, or cabinet references—enclosed by parentheses. If over there is an ext than one argument, different each by a comma.

Here's an example of a function with one dispute that adds a range of cell (B3 through B10):

Here's an instance of a duty with **more 보다 one argument** the calculates the mean of numbers in a variety of cell (B3 with B10 and also C3 with C10):

Excel has hundreds of **functions** to help with your calculations. Structure formulas can be difficult and time consuming. Excel's features can conserve you a many time and headaches.

### Excel's various functions

There are plenty of different attributes in Excel XP. Few of the an ext common attributes include:

Statistical functions:**SUM**: This to add a range of cells.

**AVERAGE**: This calculates the median of a range of cells.

**COUNT**: This counts the variety of chosen data in a range of cells.

**MAX**: This identifies the biggest number in a selection of cells.

**MIN**: This identifies the smallest number in a range of cells.Financial functions:

**Interest rates**

**Loan payments**

**Depreciation amounts**Date and time functions:

**DATE**: This converts a serial number come a work of the month.

**Day that Week**: This populates cells with the days of the week.

**DAYS360**: This calculates the number of days in between two dates based on a 360-day year.

**TIME**: This return the serial number of a certain time.

**HOUR**: This counter a serial number come an hour.

**MINUTE**: This switch a serial number to a minute.

**TODAY**: This return the serial number of today's date.

**MONTH**: This converts a serial number to a month.

**YEAR**: This converts a serial number come a year.You don't have to memorize the functions however should have an idea the what each deserve to do because that you.

### Finding the sum of a selection of data

The **AutoSum function** permits you to produce a formula that contains a cabinet range—many cells in a column, because that example, or plenty of cells in a row.

**first cell**(B2) to be consisted of in the formula.Using the point-click-drag method, traction the mouse to define a cell selection from cabinet B2 with cell B6.On the

**Standard**toolbar, click the

**Sum**button.The amount of the numbers is added to cabinet B7, or the cell immediately beneath the defined selection of numbers.Notice that the formula,

**=SUM(B2:B6)**, has been identified to cabinet B7.

Excel **will not always tell you** if your role contains one error, for this reason it's as much as you come check all of your functions. To learn exactly how to execute this, review the Double-Check her Formulas great from ours Excel recipe tutorial.

### Finding the typical of a variety of numbers

The **Average** function calculates the median of a range of numbers. The Average role can it is in selected native the AutoSum drop-down menu.

**first cell**(B2) to be had in the formula.Using the point-click-drag method,

**drag**the mouse to define a cell selection from cabinet B2 with cell B6.On the

**Standard**toolbar, click the drop-down part of the

**AutoSum**button. Select the

**Average function**from the drop-down features list. The median of the number is included to cell B7, or the cell immediately beneath the defined variety of numbers.Notice that the formula,

**=AVERAGE(B2:B6)**, has actually been defined to cell B7.

### Accessing Excel XP functions

To accessibility other functions in Excel:Using the point-click-drag method, choose a cell range to be had in the formula.On the**Standard**toolbar, click the drop-down component of the

**AutoSum**button.If you don't see the function you desire to use, display additional functions by picking

**More Functions**. The

**Paste Function**dialog crate opens.There room three ways to situate a role in the

**Insert Function**dialog box:

You can type a question in the **Search because that a duty box** and click **GO**, scroll with the alphabetical list of functions in the **Select a function** field, or pick a duty category in the **Select a category** drop-down list and also review the corresponding role names in the **Select a function** field.

**OK**.

If you're comfortable with basic functions, you may want to try a more advanced one favor **VLOOKUP**. Girlfriend can examine out our short article on how to use Excel's VLOOKUP function for more information. If you want to discover even more about functions, examine out ours Excel formulas tutorial.

### Challenge!

Type the complying with information:In cell A1, type**7842**

**.**

See more: ▷❤️ Clyde Wants To Raise The Profile Of His Dance School, Campaign Can Help Him:

In cell A2, type

See more: ▷❤️ Clyde Wants To Raise The Profile Of His Dance School, Campaign Can Help Him:

**5681**. In cabinet A3, kind

**3947**. In cell B1, form

**2594**. In cabinet B2, form

**9024**. In cabinet B3, type

**6505**.Create a formula in cabinet A4 that uses the

**AutoSum function**to add the worths in cell A1, cell A2, and also cell A3.Create a formula in cell B4 that offers the

**Average function**to uncover the averages of values in cell B1, cell B2, and also cell B3.

Continue