Ms Excel Formulas With Examples Pdf In Telugu [NEW]
Ms Excel Formulas With Examples Pdf In Telugu
Ms Excel is a powerful and versatile spreadsheet program that can help you perform various calculations, analyze data, and create charts and graphs. But to use Ms Excel effectively, you need to know how to use formulas. Formulas are expressions that tell Ms Excel what to do with the data in your cells. Formulas can perform simple operations like adding or subtracting numbers, or complex functions like finding the average or the maximum value of a range of cells.
Ms Excel Formulas With Examples Pdf In Telugu
In this article, you will learn some of the basic and advanced formulas in Ms Excel, with examples in Telugu. You will also learn how to download a PDF file that contains all the formulas and examples in this article, so you can refer to it anytime you need.
What are Ms Excel Formulas?
A formula in Ms Excel is an expression that starts with an equal sign (=) and follows the order of operations (PEMDAS). A formula can contain any of the following elements:
Constants: These are fixed values, such as numbers or text.
Cell references: These are addresses of cells or ranges of cells, such as A1 or B2:B10.
Operators: These are symbols that indicate the type of calculation to perform, such as + for addition or * for multiplication.
Functions: These are predefined formulas that perform specific tasks, such as SUM for adding up a range of numbers or IF for testing a condition.
For example, the formula =A1+A2 adds the values in cells A1 and A2. The formula =SUM(A1:A10) adds up all the values in the range A1 to A10. The formula =IF(A1>10,"Yes","No") checks if the value in cell A1 is greater than 10, and returns "Yes" if true, or "No" if false.
How to Enter a Formula in Ms Excel?
To enter a formula in Ms Excel, follow these steps:
Select the cell where you want to enter the formula.
Type an equal sign (=) to start the formula.
Type the elements of the formula, such as constants, cell references, operators, and functions. You can use the keyboard or the mouse to enter them. You can also use the Formula Bar at the top of the worksheet to enter or edit your formula.
Press Enter or Tab to complete the formula. Ms Excel will calculate the result and display it in the cell.
If you want to edit an existing formula, double-click on the cell or click on the Formula Bar, and make the changes you want. Press Enter or Tab to confirm your changes.
How to Download a PDF File with Ms Excel Formulas and Examples in Telugu?
If you want to download a PDF file that contains all the formulas and examples in this article, you can click on this link: [తెలగ] MS Excel MCQ [Free Telugu PDF]. This PDF file is from Testbook.com, a website that provides objective questions and answers for various exams and topics. You can use this PDF file as a reference guide or a study material for learning Ms Excel formulas in Telugu.
Some Basic Ms Excel Formulas with Examples in Telugu
In this section, you will learn some of the basic formulas in Ms Excel, with examples in Telugu. These formulas are useful for performing simple calculations and operations on your data.
Addition (+)
The addition operator (+) adds two or more numbers or values together. For example:
ABC
10=A1+5=B1+15
20=A2+10=B2+25
=A1+A2=B1+B2=C1+C2
302555
503585
=SUM(A1:A3)=SUM(B1:B3)=SUM(C1:C3)
8060140
In this example, we have used the addition operator (+) to add two numbers in each cell. We have also used the SUM function to add up a range of cells. The SUM function takes one or more arguments (the cells or ranges to add up) and returns the total sum. For example:
=A1+5 adds 5 to the value in cell A1 and returns 15.
=B1+15 adds 15 to the value in cell B1 and returns 30.
=C1+C2 adds the values in cells C1 and C2 and returns 85.
=SUM(A1:A3) adds up all the values in the range A1 to A3 and returns 80.
Subtraction (-)
The subtraction operator (-) subtracts one number or value from another. For example:
ABC
50=A1-10=B1-20
40
Multiplication (*)
The multiplication operator (*) multiplies two or more numbers or values together. For example:
ABC
10=A1*2=B1*3
20=A2*4=B2*5
=A1*A2=B1*B2=C1*C2
20040120
80160600
=PRODUCT(A1:A3)=PRODUCT(B1:B3)=PRODUCT(C1:C3)
160001024004320000
In this example, we have used the multiplication operator (*) to multiply two numbers in each cell. We have also used the PRODUCT function to multiply a range of cells. The PRODUCT function takes one or more arguments (the cells or ranges to multiply) and returns the total product. For example:
=A1*2 multiplies the value in cell A1 by 2 and returns 20.
=B1*3 multiplies the value in cell B1 by 3 and returns 60.
=C1*C2 multiplies the values in cells C1 and C2 and returns 600.
=PRODUCT(A1:A3) multiplies all the values in the range A1 to A3 and returns 16000.
Division (/)
The division operator (/) divides one number or value by another. For example:
AB<
Exponentiation (^)
The exponentiation operator (^) raises one number or value to the power of another. For example:
ABC
2=A1^2=B1^3
3=A2^4=B2^5
=A1^A2=B1^B2=C1^C2
41664
981243
=POWER(A1,A2)=POWER(B1,B2)=POWER(C1,C2)
5126553616777216
In this example, we have used the exponentiation operator (^) to raise one number to the power of another in each cell. We have also used the POWER function to do the same thing. The POWER function takes two arguments (the base and the exponent) and returns the result of raising the base to the power of the exponent. For example:
=A1^2 raises the value in cell A1 to the power of 2 and returns 4.
=B1^3 raises the value in cell B1 to the power of 3 and returns 64.
=C1^C2 raises the value in cell C1 to the power of the value in cell C2 and returns 16777216.
=POWER(A1,A2) raises the value in cell A1 to the power of the value in cell A2 and returns 512.
Parentheses ()
Parentheses () are used to group parts of a formula and control the order of operations. Ms Excel calculates the formulas inside parentheses first, then performs other calculations from left to right, following the order of operations (PEMDAS). For example:
A<
Percentage (%)
The percentage operator (%) converts a number or value to a percentage by multiplying it by 100. For example:
ABC
0.5=A1%=B1*10
0.25=A2%=B2*20
=A1+A2=B1+B2=C1+C2
0.7575%750
5%0.0550
=AVERAGE(A1:A3)=AVERAGE(B1:B3)=AVERAGE(C1:C3)
25%0.25250
In this example, we have used the percentage operator (%) to convert a decimal number to a percentage in each cell. We have also used the AVERAGE function to calculate the average of a range of cells. The AVERAGE function takes one or more arguments (the cells or ranges to average) and returns the arithmetic mean. For example:
=A1% converts the value in cell A1 to a percentage by multiplying it by 100 and returns 50%.
=B1*10 multiplies the value in cell B1 by 10 and returns 500.
=C1+C2 adds the values in cells C1 and C2 and returns 800.
=AVERAGE(A1:A3) calculates the average of all the values in the range A1 to A3 and returns 25%.
Absolute and Relative References ($)
Absolute and relative references are used to specify the cells or ranges in a formula. A relative reference changes when a formula is copied or moved to another cell, while an absolute reference remains constant. To make a reference absolute, you need to add a dollar sign ($) before the column letter and/or the row number. For example:
ABC
1DataFormula
210=B2*2 (relative)
320=B3*2 (relative)
430=B4*2 (relative)
5Total:=SUM(B2:B4) (relative)
6
7
<tr
Sorting and Filtering Data
Sorting and filtering are two popular features available in Microsoft Excel. They are widely used in data analysis to organize, arrange, and subset your data based on specific conditions. In this section, you will learn how to sort and filter data in Excel.
Sorting Data
Sorting data means arranging the data in a certain order, such as ascending or descending, alphabetical or numerical, or by date or color. Sorting data can help you find and compare data easily, as well as identify patterns and trends. To sort data in Excel, follow these steps:
Select the data range that you want to sort. You can also select a single cell within the data range and Excel will automatically select the entire range.
Go to the Data tab and click on the Sort button. A Sort dialog box will appear.
In the Sort dialog box, you can specify how you want to sort your data. You can choose one or more columns (or rows) to sort by, and select the order (ascending or descending) and the type (values, cell color, font color, or icon) of each column (or row). You can also choose whether your data has headers or not.
Click OK to apply the sorting.
You can also use the Sort & Filter button on the Home tab to quickly sort your data by a single column (or row) in ascending or descending order.
Filtering Data
Filtering data means hiding some rows (or columns) of data that do not meet certain criteria, and showing only the rows (or columns) that do. Filtering data can help you focus on a specific subset of data that you are interested in, and remove unnecessary or irrelevant data. To filter data in Excel, follow these steps:
Select the data range that you want to filter. You can also select a single cell within the data range and Excel will automatically select the entire range.
Go to the Data tab and click on the Filter button. Filter arrows will appear at the top of each column (or at the left of each row).
Click on the filter arrow of the column (or row) that you want to filter by. A drop-down list will appear with all the unique values in that column (or row).
In the drop-down list, you can check or uncheck the values that you want to show or hide. You can also use the search box to find a specific value, or use the number filters or text filters options to apply more advanced criteria.
Click OK to apply the filtering.
You can also use the Slicer feature on the Data tab to filter your data by using buttons that you can click. Slicers are especially useful when you have a large amount of data or multiple filters applied.
Conclusion
In this article, you have learned some of the basic and advanced formulas in Ms Excel, with examples in Telugu. You have also learned how to download a PDF file that contains all the formulas and examples in this article, so you can refer to it anytime you need. You have also learned how to sort and filter data in Excel to organize and analyze your data effectively. We hope that this article has helped you to improve your Ms Excel skills and knowledge. If you have any questions or feedback, please feel free to leave a comment below. Thank you for reading! d282676c82
https://www.porscha.co/group/porscha-co-group/discussion/6b88dc18-dea1-4873-b13c-5e0121d9d3e2
https://www.begym.com.br/group/grupo-nova-be-gym/discussion/9f06fad9-017c-4193-9106-8156f837da77
https://www.profeconcha.com/group/sowatscientists/discussion/06836472-7ecb-4142-8ae1-fbfeefcbb216