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:

    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:
  • 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 is the importance of Microsoft Excel?

    A:

    Microsoft Excel is important because it is the basic spreadsheet program used in Windows, which means a large number of computers in the world use it. This also means that a lot of businesses use it for payroll.

    Full Answer >
    Filed Under:

Explore