Formulas in MS Excel by Ashly Nicole Mirador

                    FORMULAS IN EXCEL

Formulas and functions in Excel 

 According to Microsoft.com, Microsoft Excel is a powerful application that enables you to perform calculations and solve problems using formulas and the provided functions. You can create formulas that refer to data in other cells and use built-in functions to perform calculations and solve problems.

    These are a few of the Excel formulas that are most commonly used:

• SUM: Adds up a range of cells.        
• AVERAGE: Determines a range of cells' average.
• MAX: Provides the largest number in a range of cells.
• MIN: Returns the smallest number in a range of cells.
• COUNT: Counts the number of cells in a range that contains numbers.
• IF: tests a condition and returns one value if the condition holds true and another value if the condition is untrue.
• VLOOKUP: Looks for a value in the first column of a table and returns a value in the same row from another column in the table.

 Here's a tutorial of how to use formulas in excel:

 I hope it helps you! 

-Ashly Nicole Mirador

CLICK HERE TO GO BACK TO MY PORTFOLIO