What are the 7 basic Excel formulas PDF?

What are the 7 basic Excel formulas PDF?

Seven Basic Excel Formulas For Your Workflow

  • =SUM(number1, [number2], …)
  • =SUM(A2:A8) – A simple selection that sums the values of a column.
  • =SUM(A2:A8)/20 – Shows you can also turn your function into a formula.
  • =AVERAGE(number1, [number2], …)
  • =AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2:B11)/10)

What are the 20 functions of Excel?

Complete Excel Formulas with Their Functions

Formulas Functional Description
VLOOKUP Search for Data from a table arranged in an upright format
MATCH Displays the position of a specific cell address
COUNTIF Counting the Number of Cells in a Range with specific criteria
COUNTA Counting the Number of Filled Cells

How many functions in MS Excel?

Though every Excel feature has a use case, no single person uses every Excel feature themselves. Cut through the 500+ functions, and you’re left with 100 or so truly useful functions and features for the majority of modern knowledge workers.

What are the 5 functions in MS Excel?

To help you get started, here are 5 important Excel functions you should learn today.

  • The SUM Function. The sum function is the most used function when it comes to computing data on Excel.
  • The TEXT Function.
  • The VLOOKUP Function.
  • The AVERAGE Function.
  • The CONCATENATE Function.

What are the 5 most commonly used functions in Excel?

Most Used Functions

  1. COUNT. To count the number of cells that contain numbers, use the COUNT function in Excel.
  2. SUM. To sum a range of cells, use the SUM function in Excel.
  3. IF. The IF function checks whether a condition is met, and returns one value if true and another value if false.
  6. SUMIF.
  8. MIN.