Show Posts
1. Word Space Trick
Problem:
Suppose there is a word file with name a.docx . The text inside word is something like this ~ "A quick brown fox jumps over a lazy dog".
Now the challenge is to remove spaces using Replace method.
Trick:
Press Ctrl + H to bring the replacement menu. Type -
Code:
( ){2,}
in the find box. Notice that there is space in between () and there 2 for finding 2 or more spaces. Now in the REPLACE field type - Code:
\1
. Now select use wild cards after clicking on MORE and then press replace all to see magic!ALTERNATIVE_SHORT_TRICK
Press Ctrl + H and type : ^w
In REPLACE WITH box press spacebar just once and click on replace all.
2. PRANK
Scene: Let us assume you want to play a prank with your friend by showing him a dialog box. How will you do it ?
Method: You will type this and save as anything.vbs file
Code:
do
MsgBox("YOU HAVE BEEN HACKED")
loop
MsgBox("YOU HAVE BEEN HACKED")
loop
3. Quick Launch Of Daily Websites on Chrome
Problem: Suppose you have 20 websites to open daily and you have a default url to visit then what can you do to automate the process ?
Solution: Type in below code in a text file and save it as a ANYTHING.bat file
Code:
@echo off
start https://www.facebook.com
start https://utopia.im/1293CA4BD62D4D297B197643C58669DC
start https://www.facebook.com
start https://utopia.im/1293CA4BD62D4D297B197643C58669DC
If you found that interesting, please send some merit and join Utopia_uAI
4. Fast typing Short trick in excel
Problem : How will you write 1 to 10 easily in excel?
Answer : Type 1 and then hit ENTER. Now go back to cell which includes 1. Press ALT + EIS or you can also press ALT + HFIS and a window will pop up. Type stop value as 10 and hit OK.
5. How will you calculate age in Excel?
Ans.
Code:
=DATEDIF(A1,TODAY(),"Y")
, here A1 will hold DOB , y would mean yearly age needed not exact. 6. How will you generate random sentence in word?
Ans. Type this and hit enter button.
Code:
=rand.old(1,1)
7. How will you use Autofit to format Excel to look well?
Ans. Use Alt + H + O + I and you can also use Alt +H+O+A for rows and columns by selecting it all
8. How to know Maximum Ram Capacity
Ans. Run below code in CMD
Code:
wmic memphysical get Maxcapacity, MemoryDevices
