Best Offer for Books in Amazon

Showing posts with label how to use convert function in excel. Show all posts
Showing posts with label how to use convert function in excel. Show all posts

Friday, 22 November 2019



USING CONVERT FUNCTIONS
HOW TO CONVERT CM TO INCH
Normally Everybody knows that 1 CM = 0.393 inches, 1 Inch = 2.54 cm .
1 CM = 0.393 INCH
1 INCH = 2.54 CM
Now, Let us do How to convert Inches to CM
INCHES 1
convert to CM 2.54
to Convert Inch to CM    Write Below Function   
=CONVERT(B1,"in","cm")





How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.