Excel Formulas and Functions Tutorial

Excel Formulas and Functions Tutorial

 

 

How do I use formulas and functions in Excel?
Enter a formula that contains a built-in function
  1. Select an empty cell.
  2. Type an equal sign = and then type a function. For example, =SUM for getting the total sales.
  3. Type an opening parenthesis (.
  4. Select the range of cells, and then type a closing parenthesis).
  5. Press Enter to get the result.
    What are the top 10 Excel formulas?
    Top 10 Excel Formulas Interview Questions & Answers (2021)
    • SUM formula: =SUM (C2,C3,C4,C5) …
    • Average Formula: = Average (C2,C3,C4,C5) …
    • SumIF formula = SUMIF (A2:A7,“Items wanted”, D2:D7) …
    • COUNTIF Formula: COUNTIF(D2:D7, “Function”) …
    • Concatenate Function: =CONCATENATE(C4,Text, D4, Text,…)

Leave a Comment