#7 simple functions on MS Excel

 

Simple functions on Microsoft Excel

Microsoft Excel is spreadsheet software that provides a powerful set of tools for organizing, analyzing, and presenting data. It is widely used by individuals and businesses to manage financial, numerical, and other types of data. In this article, we will take a look at some of the simple functions that can be used in Microsoft Excel to analyze data and perform calculations.

1. SUM Function: The SUM function is one of the most commonly used functions in Microsoft Excel. It allows you to quickly add up a range of numbers. To use the SUM function, simply select the cell where you want the result to appear, type "=SUM (", select the range of cells that you want to add up, and close the parentheses.

2. PRODUCT Function: The PRODUCT function multiplies all the numbers given as arguments. This is useful when you want to multiply several values at once. Type `=PRODUCT(`, select the range or numbers, and close the parentheses. 

   Example: `=PRODUCT(F1:F5)` multiplies all values from F1 to F5.

3. SUBTRACTION Formula: Excel doesn’t have a specific SUBTRACT function, but you can easily subtract using the minus (`-`) operator. Type `=A1-B1` to subtract the value in B1 from A1. 

Example: `=A5-B5`

4. DIVISION Formula: Similar to subtraction, Excel uses the division (`/`) operator instead of a specific function. Type `=A1/B1` to divide the value in A1 by the value in B1. 

Example: `=C5/D5`

5. AVERAGE Function: The AVERAGE function calculates the average value of a range of numbers. To use the AVERAGE function, simply select the cell where you want the result to appear, type "=AVERAGE (", select the range of cells that you want to find the average of, and close the parentheses.

3. MAX Function: The MAX function returns the largest value in a range of numbers. To use the MAX function, simply select the cell where you want the result to appear, type "=MAX (", select the range of cells that you want to find the maximum of, and close the parentheses.

4. MIN Function: The MIN function returns the smallest value in a range of numbers. To use the MIN function, simply select the cell where you want the result to appear, type "=MIN (", select the range of cells that you want to find the minimum of, and close the parentheses.

6. COUNT Function: The COUNT function returns the number of cells in a range that contain numerical data. To use the COUNT function, simply select the cell where you want the result to appear, type "=COUNT (", select the range of cells that you want to count, and close the parentheses.

 click here for Introduction of IT skills