INSTALL
ట్రెండింగ్ ఫీడ్
⃟≛⃝📚రాధ✮⃝📚
1.2K వీక్షించారు
•
2 రోజుల క్రితం
#💻కంప్యూటర్ నేర్చుకుందాం👈
#👩🎓GK & కరెంట్ అఫైర్స్
#👶కిడ్స్ ఎడ్యుకేషన్🎰
#📖ఎడ్యుకేషన్✍
#🤔క్విజ్లు & పొడుపు కథలు
4
11
కామెంట్
Your browser does not support JavaScript!
![💻కంప్యూటర్ నేర్చుకుందాం👈 - Microsoft Excel Formula Basic math Funcion Formula Example To ndd up the total =SUMIcell range) =$0|M(82:89) To add Individual Items =Valuel Value 2 =82C2 Subtract =Valuel Value 2 =82-02 Multiply EValuel Valuez =82 02 =Value1 / Value2 Divide 82/02 Exponents =Valuel Valuez =82*C2 Average =AVERAGEtcell rangel =AVERAGE(B2:B9] Median =MEDIANIcell rangel =MEDIAN(82:89) EMAX(cell ranse) -MAX(82:89) Max Min =MIN(cell rangel EMIN(B2.89) Simple formatting tricks Exampe Function Formula To chanse ೩ cell to' =PR0PER(A2) =PROPER(cell proper case To change a ccll ro =UPPER(A2) =UPPERIcell) upper case To change a cell to =LOWERIA2). =LOWERIcell lower case Conditional statements Exampte Eunction Formula =|F(82>69, "Pass", Fllogical test TCSUII If statement "Fail") the test anster Is true result tne Lest anstvler 1s 50 =EXACT(82, C२) EXACTIValuez value2l Exact Microsoft Excel Formula Basic math Funcion Formula Example To ndd up the total =SUMIcell range) =$0|M(82:89) To add Individual Items =Valuel Value 2 =82C2 Subtract =Valuel Value 2 =82-02 Multiply EValuel Valuez =82 02 =Value1 / Value2 Divide 82/02 Exponents =Valuel Valuez =82*C2 Average =AVERAGEtcell rangel =AVERAGE(B2:B9] Median =MEDIANIcell rangel =MEDIAN(82:89) EMAX(cell ranse) -MAX(82:89) Max Min =MIN(cell rangel EMIN(B2.89) Simple formatting tricks Exampe Function Formula To chanse ೩ cell to' =PR0PER(A2) =PROPER(cell proper case To change a ccll ro =UPPER(A2) =UPPERIcell) upper case To change a cell to =LOWERIA2). =LOWERIcell lower case Conditional statements Exampte Eunction Formula =|F(82>69, "Pass", Fllogical test TCSUII If statement "Fail") the test anster Is true result tne Lest anstvler 1s 50 =EXACT(82, C२) EXACTIValuez value2l Exact - ShareChat](https://cdn4.sharechat.com/bd5223f_s1w/compressed_gm_40_img_515445_e7f6125_1780201513583_sc.jpg?tenant=sc&referrer=pwa-sharechat-service&f=583_sc.jpg "💻కంప్యూటర్ నేర్చుకుందాం👈 - Microsoft Excel Formula Basic math Funcion Formula Example To ndd up the total =SUMIcell range) =$0|M(82:89) To add Individual Items =Valuel Value 2 =82C2 Subtract =Valuel Value 2 =82-02 Multiply EValuel Valuez =82 02 =Value1 / Value2 Divide 82/02 Exponents =Valuel Valuez =82*C2 Average =AVERAGEtcell rangel =AVERAGE(B2:B9] Median =MEDIANIcell rangel =MEDIAN(82:89) EMAX(cell ranse) -MAX(82:89) Max Min =MIN(cell rangel EMIN(B2.89) Simple formatting tricks Exampe Function Formula To chanse ೩ cell to' =PR0PER(A2) =PROPER(cell proper case To change a ccll ro =UPPER(A2) =UPPERIcell) upper case To change a cell to =LOWERIA2). =LOWERIcell lower case Conditional statements Exampte Eunction Formula =|F(82>69, \"Pass\", Fllogical test TCSUII If statement \"Fail\") the test anster Is true result tne Lest anstvler 1s 50 =EXACT(82, C२) EXACTIValuez value2l Exact Microsoft Excel Formula Basic math Funcion Formula Example To ndd up the total =SUMIcell range) =$0|M(82:89) To add Individual Items =Valuel Value 2 =82C2 Subtract =Valuel Value 2 =82-02 Multiply EValuel Valuez =82 02 =Value1 / Value2 Divide 82/02 Exponents =Valuel Valuez =82*C2 Average =AVERAGEtcell rangel =AVERAGE(B2:B9] Median =MEDIANIcell rangel =MEDIAN(82:89) EMAX(cell ranse) -MAX(82:89) Max Min =MIN(cell rangel EMIN(B2.89) Simple formatting tricks Exampe Function Formula To chanse ೩ cell to' =PR0PER(A2) =PROPER(cell proper case To change a ccll ro =UPPER(A2) =UPPERIcell) upper case To change a cell to =LOWERIA2). =LOWERIcell lower case Conditional statements Exampte Eunction Formula =|F(82>69, \"Pass\", Fllogical test TCSUII If statement \"Fail\") the test anster Is true result tne Lest anstvler 1s 50 =EXACT(82, C२) EXACTIValuez value2l Exact - ShareChat")