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.

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 in 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 disadvantages of Microsoft Excel?

    A:

    One disadvantage of Microsoft Excel is that users cannot enter numbers starting with "0" unless the field of the cell is changed from a number to text. Macros and other mini programs written into Microsoft Excel spreadsheets are prone to virus infections.

    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:
  • Q:

    How do you concatenate text in Microsoft Excel?

    A:

    The concatenate function joins the text from cells or functions into one text string. Each cell contains text, numbers, cell references or any combination of these. To use this function, enter "=CONCATENATE(" into a cell, then choose reference cells, values or entered text to combine. Separate each item with a comma, and close the parenthesis for the formula to work properly

    Full Answer >
    Filed Under:

Explore