Q:

What is a function in Microsoft Excel?

A:

Quick Answer

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.

Continue Reading

Full Answer

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.

Learn more about Software
Sources:

Related Questions

  • Q:

    What are the basics of using Microsoft Excel?

    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.

    Full Answer >
    Filed Under:
  • Q:

    How do you use the PMT fucntion in Microsoft Excel?

    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.

    Full Answer >
    Filed Under:
  • Q:

    How do you create formulas in Excel?

    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.

    Full Answer >
    Filed Under:
  • Q:

    How can you sum in Excel?

    A:

    Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represents the values in cells to be summed.

    Full Answer >
    Filed Under:

Explore