General Knowledge  Written by

## Excel Formula List PDF Summary

No.-1. Friends, today we have brought Excel Formula List PDF / Excel Formula List PDF for you, in which you will get to read all the formulas of MS Excel.

No.-2. The ms excel formula calculates the mean by adding a set of numbers and then dividing the sum by the count of those numbers.

No.-3. In Microsoft Excel, the mean can be calculated by using one of the following functions: AVERAGE – Returns the average number. A formula is an expression that calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

No.-4. Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas by giving them human-friendly names.

No.-5. For example: =SUM(A1:A3). The function sums all the values ​​in A1 through A3.

### Excel Formula List PDF | Excel Formula List PDF

 SUM Excel Formula : SUM(number1, [number2] ) AVERAGE Excel Formula : AVERAGE(number1, [number2], …) MAX & MIN Excel Formula : =MAX(A2:A5) =MIN(A2:A5) COUNT & COUNTA Formula : COUNT(value1, [value2], …) IF Excel Formula : IF(logical_test, [value_if_true], [value_if_false]) TRIM Excel Formula : = TRIM(A1) LEN Excel Formula : =LEN (text) CONCATENATE Excel Formula : CONCATENATE(text1, [text2], …)

No.-1. When analyzing data, there are five common ways to insert basic Excel formulas. Each strategy comes with its own advantages.

No.-2. So, before going further into the main formulas, we will explain those methods so that you can first create your preferred workflow.

No.-3. To make all this work, you have to enter the formula in the cell.

No.-4. Don’t waste any more time doing all this stuff manually in Microsoft Excel.

No.-5. There are many ways to use Excel formulas to reduce the amount of time you spend in Excel and increase the accuracy of your data and reports.

No.-6. The objective of this tutorial is to teach you the essentials of Excel functions and how to use basic formulas in Excel.

### 1) I am Excel Formulas

No.-1. The first Excel function you should be familiar with is SUM, which performs the basic arithmetic operation of addition.

Syntax Of SUM Function:

No.-1. The syntax of the SUM function is as follows:

No.-1. The first argument to the SUM function is required, the other numbers are optional, and you can pass up to 255 numbers in a formula.

No.-2. That means, your SUM formula must include at least 1 number, cell, or cell range reference.

Example of SUM Function

For example:

No.-1. =SUM(A1:A5) – This cell adds the value of the cells from A1 to A5.

No.-2. =SUM(A2, A5) – This cell adds the values ​​of cells A2 and A5.

No.-3. =SUM(A2:A5)/5 – Adds the values ​​of cells A1 to A5 and divides the sum by 5.

No.-4. In your Excel worksheet, this formula might look something like this:

No.-5. Tip – The fastest way to sum a column or row is to select the cells next to these cells and click the AutoSum button on the Home tab.

#### 2) AVERAGE Excel Formula

No.-1. Excel’s AVERAGE function finds the average (arithmetic mean) of numbers.

Syntax Of AVERAGE Function:

No.-1. The syntax of the AVERAGE function is as follows:

No.-1. AVERAGE(number1, [number2], …)

No.-2. where number1, [number2], etc. are one or more numbers (or references to cells containing numbers) whose average you want to calculate.

Example of AVERAGE Function:

For example:

No.-1. =AVERAGE(A1:A5)

#### 3) MAX & MIN Excel Formula

No.-1. The MAX and MIN formulas in Excel find the largest and smallest value, respectively, of a set of numbers.

Example of MAX & MIN Function :

For example:

No.-1. =MAX(A2:A5)

No.-2. =MIN(A2:A5)

#### 4) COUNT & COUNTA Formula

No.-1. If you want to know how many cells in a sales range contain numeric values ​​(numbers or dates), don’t waste your time counting them manually. Excel’s COUNT function will count in a single second.

Syntax Of COUNT Function:

No.-1. The syntax of the COUNT function is as follows:

No.-1. COUNT(value1, [value2], …)

No.-2. While the COUNT function only counts cells that contain numbers, Excel’s COUNTA function counts all cells that are not blank

No.-3. whether they contain numbers, dates, times, text, logical values ​​of TRUE and FALSE. Values ​​can be errors or empty text strings (“”).

Syntax Of COUNTA Function:

No.-1. The syntax of the COUNTA function is as follows:

No.-1. COUNTA (value1, [value2], …)

Example of COUNT & COUNTA Function :

No.-1. For example, to find out how many numbers are in column A, use this formula:

No.-1 =COUNT(A:A)

No.-2. To count all non-empty cells in column A, use this formula:

No.-1. =COUNTA(A:A)

No.-3. In both formulas, you’re referencing cells in the entire A column.

#### 5) IF Excel Formula

No.-1. When you use the IF formula in Excel, then you tell Excel to test some conditions and when this condition is met, Excel returns a value or does a calculation, and if this condition is not met, Excel does another Performs value or other calculations.

Syntax Of IF Function:

No.-1. The syntax of the IF function is as follows:

No.-2. IF(logical_test, [value_if_true], [value_if_false])

In simple language –

No.-1. IF(if something is true, then do something, otherwise do something else)

No.-2. So an IF statement can have two results. If your comparison is true then the first result, otherwise the second result.

Example of IF Function :

No.-1. For example, if students have marks above 35 then they are PASS and if they have less than 35 marks then they are FAIL.

No.-2. =IF(A2>=35, “PASS”, “FAIL”)

#### 6) TRIM Excel Formula

No.-1. Excel’s TRIM function removes extra spaces from words and does not place a single space character at the start or end of the text.

No.-2. There are several ways to remove unwanted spaces in Excel, with the TRIM function being the easiest:

Syntax Of TRIM Function:

No.-1. The syntax of TRIM function is as follows:

No.-2. TRIM(text)

Example of TRIM Function :

No.-1. For example, to remove all extra spaces in the A column, enter the following formula in cell A1, and then copy it down the column:

No.-2. = TRIM(A1)

No.-3. This will remove all extra whitespace in the cells and leave only one space character between the words.

#### 7) LEN Excel Formula

No.-1. Use LEN whenever you want to know how many characters are in a cell.

Syntax Of LEN Function:

No.-1. The syntax of LEN function is as follows:

No.-2. =LEN (text)

Example of LEN Function :

No.-1. To know how many characters are there in A2 cell –

No.-2. =LEN(A2)

#### 8) AND & OR Excel Formula

No.-1. These are the two most popular logical functions for checking multiple parameters.

AND Function:

No.-1. This comes in handy when you need to test multiple conditions and make sure they are all TRUE.

No.-2. Technically the AND function tests the conditions you specify and returns TRUE if all the conditions are TRUE otherwise it returns FALSE.

Syntax Of AND Function:

No.-1. The syntax of AND function is as follows:

No.-1. =AND (logical1, [logical2], …)

Example of AND Function :

No.-1. For example, students have marks above 35 in both Maths and English then they are PASS, otherwise FAIL.

No.-2. =IF(AND(B2>35,C2>35), “PASS”, “FAIL”)

OR Function:

No.-1. Just like the AND function in Excel, an OR is a logical function that is used to compare two values ​​or statements.

No.-2. The only difference is that the OR function returns TRUE if any one of the given conditions is TRUE and returns FALSE if all the given conditions are FALSE.

Syntax Of OR Function:

No.-1. The syntax of OR function is as follows:

No.-2. =OR (logical1, [logical2], …)

Example of OR Function :

No.-1. For example, students have marks above 35 in either subject of Maths and English, then they are PASS, otherwise they are FAIL.

No.-2. =IF(OR(B2>35,C2>35), “PASS”, “FAIL”)

#### 9) CONCATENATE Excel Formula

No.-1. Excel’s CONCATENATE function joins two or more text items. It combines the values ​​of two or more cells into a single cell.

Syntax Of CONCATENATE Function:

No.-1. The syntax of the CONCATENATE function is as follows:

No.-2. CONCATENATE(text1, [text2], …)

No.-3. Example of CONCATENATE Function :

No.-4. For example, to combine the values ​​in cells A2 and B2, simply enter the following formula in a separate cell:

No.-5. =CONCATENATE(A2, B2)

No.-6. If you want to separate these combined values, that is, add a space to them, type the space character (” “) in the arguments list.

No.-7. =CONCATENATE(A2, ” “, B2)

No.-1. कला और शिल्प में प्रयोग किए जाने वाले किस रसायन से एनीमिया और ल्यूकीमिया हो सकता है?

Ans. एल्ड्रीन

No.-2. आर्टीजियन कुंए किस प्रकार की चट्टान में मिलते हैं?

Ans. परतदार चट्टान में

No.-3. भ्रूण के विकास के लिए किस अंग के द्वारा खाद्य की पूर्ति की जाती है?

Ans. बीजाण्डासन से

No.-4. जैन तीर्थंकर पार्श्वनाथ द्वारा प्रतिपादित चार महाव्रतों में महावीर स्वामी ने पाँचवें महाव्रत के रूप में क्या जोड़ा?

Ans. ब्रह्मचर्य

No.-5. ‘श्रीहरिकोटा’ किस राज्य में स्थित है?

Ans. आंध्र प्रदेश में

No.-6. भारत द्वारा सबसे अधिक विदेशी मुद्रा किस वस्तु के आयात पर व्यय की जाती है?

Ans. पेट्रोलियम पदार्थ पर

No.-7. किस बिल के पास होने के विरोध में बटुकेश्वर दत और भगत सिंह ने सेन्ट्रल लेजिस्लेटिव असेम्बली में बम फेंके थे?

Ans. पब्लिक सेफ्टी बिल

No.-8. किस अनुच्छेद के तहत संसद किसी भी राज्य में विधान परिषद् का गठन कर सकती है?

Ans. अनुच्छेद 169

No.-9. राज्य के सप्तांग सिद्धांत का प्रतिपादन किसने किया?

Ans. कौटिल्य ने

No.-10. ‘फायर ऑन द माउंटेन’ किसकी रचना है?

Ans. अनिता देसाई की 