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.

Know More

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:

    How do I freeze cells in Microsoft Excel?

    A:

    To freeze cells in Microsoft Excel: open a worksheet, select the rows and columns that are to be locked, and then navigate to the Freeze Panes options from the View tab. From the list of options, select the most appropriate choice to freeze a single row, single column or multiples.

    Full Answer >
    Filed Under:
  • Q:

    What are the disadvantages of using Microsoft Excel?

    A:

    There are several disadvantages of using Microsoft Excel, some of which include limited reporting, a lack of an audit trail and version control. In light of some of these disadvantages, a user may want to use actual database software or cloud storage software, such as Google Drive, which has the capability of housing spreadsheets indefinitely.

    Full Answer >
    Filed Under:
  • Q:

    What companies use Microsoft Excel?

    A:

    Accounting, marketing and management consultant firms commonly rely on Microsoft Excel to perform functions related to their industry of expertise, says Brad Zomick of SkilledUp. Investment banking and business intelligence analysts also use the program to amalgamate and scrutinize data. Microsoft Excel is a basic application included in the Microsoft Office Suite of desktop programs and is an extremely popular resource among a variety of business professionals.

    Full Answer >
    Filed Under:
  • Q:

    What are the advantages of using Microsoft Excel?

    A:

    Microsoft Excel is a spreadsheet program that allows users to quickly log, sort and analyze data. To use Excel to its full functionality, users must be familiar with the basic formulas and commands Excel uses to find trends or make projections.

    Full Answer >
    Filed Under:

Explore