ShareChat
click to see wallet page
search
#💻కంప్యూటర్ నేర్చుకుందాం👈 #👩‍🎓GK & కరెంట్ అఫైర్స్ #👶కిడ్స్ ఎడ్యుకేషన్🎰 #📖ఎడ్యుకేషన్✍ #🤔క్విజ్‌‌‌‌లు & పొడుపు కథలు
💻కంప్యూటర్ నేర్చుకుందాం👈 - 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