🔍 જાણવા જેવું, 📚સ્પર્ધાત્મક પરીક્ષાની તૈયારી Image & Post | ShareChat - VIKRAM

click to see wallet page

પ્રખ્યાત

VIKRAM PRAJAPATI - Author on ShareChat: Funny, Romantic, Videos, Shayari, Quotes

VIKRAM PRAJAPATI

436 એ જોયું

11 દિવસ પહેલા

#🔍 જાણવા જેવું #📚સ્પર્ધાત્મક પરીક્ષાની તૈયારી #🤔Exam સ્પેશ્યિલ 📝

🔍 જાણવા જેવું - Top 10 Excel Formulas 1 SUM =SUM(A1:A1O) Adds up the numbers in a range L 2.AVERAGE =AVERAGE(B1:B10) Calculates the average of a range 3.COUNT =COUNT(C1:C20) Counts the number of cells with numbers: 4If =IF(DI > 100, 'Yes' , 'No') Checks if a condition is met 5. VLOOKUP =VLOOKUP(E2, A1:C10, 2, FALSE) Looks up a value in a table =CONCATENATE(F1, 61) 6. CONCATENATE Joins text from multiple cells ७. MAX&MIN =MAX(H1:H|10)/=MIN(H1:H|10) Returns the highest / lowest value 8. TODAY =TODAY() Returns the current date 9. TRIM =TRIM(11) from Removes extra spaces text 10. LEগI =LEFT(J1, 5) Extracts the first 5 characters Top 10 Excel Formulas 1 SUM =SUM(A1:A1O) Adds up the numbers in a range L 2.AVERAGE =AVERAGE(B1:B10) Calculates the average of a range 3.COUNT =COUNT(C1:C20) Counts the number of cells with numbers: 4If =IF(DI > 100, 'Yes' , 'No') Checks if a condition is met 5. VLOOKUP =VLOOKUP(E2, A1:C10, 2, FALSE) Looks up a value in a table =CONCATENATE(F1, 61) 6. CONCATENATE Joins text from multiple cells ७. MAX&MIN =MAX(H1:H|10)/=MIN(H1:H|10) Returns the highest / lowest value 8. TODAY =TODAY() Returns the current date 9. TRIM =TRIM(11) from Removes extra spaces text 10. LEগI =LEFT(J1, 5) Extracts the first 5 characters - ShareChat