# 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.
4. AVERAGE.
5. COUNTIF.
6. SUMIF.
7. VLOOKUP.
8. MIN.