Q:

# What is a function in Microsoft Excel?

A:

In Microsoft Excel, a function is a type of formula that allows the user to perform mathematical, statistical and logical operations more easily. While it is possible to create a unique formula, Excel offers users a variety of preset formulas that they term functions.

## Keep Learning

All formulas and functions must start with the equal sign in order to work properly. One of the most common Excel functions is AutoSum, as many people use Excel to calculate numbers. When a user employs this function, Excel automatically determines what data the user wants to add and offers the total sum of that data.

Sources:

## Related Questions

• A:

The basics of using Microsoft Excel 2013 include knowing how to create a new workbook, how to enter data in worksheet cells, how to create simple formulas and how to use the AutoSum function. Additionally, the basics include the application of different number formats and modifying data in a table.

Filed Under:
• A:

To use the PMT function, correctly use the function’s formula syntax. The function syntax is PMT (rate, nper, pv, [fv], [type]), where rate is the interest rate, nper is the number of payments, pv is the present value, fv is the future value and type is the status of payment.

Filed Under:
• A:

You can create a formula in Microsoft Excel by using constants and calculation operators, cell references and names, or functions. Simple formulas to add, subtract, multiply or divide cell values are entered directly in your worksheet, while more complex formulas are initiated in the Excel formula dialogue box.