Yogendra Pratap Mishra

1st:- Get back that tab you accidentally closed. If you want to get back a tab you closed, just press "Control" (or "Command" on Mac), plus "Shift," plus "T," and it will magically reappear. 2nd:-Only screenshot the part of the screen you want. If you only need to screenshot part of the screen, there's a simple way to do it for both Windows and Macs. For Mac: "Command," plus "Shift," plus "4" brings up the tool. Then you just drag the area you want. For Windows: Just go to "Start" and then "Snipping Tool." 3rd:-Easily repeat your last command in Excel. If you press the F4 button in Excel, it repeats the last command. Understand from Below given Example- you select a cell and highlight it yellow, you can then highlight any other selected cell(s) yellow by pressing F4." 4th:-Make a copy of a file by just dragging it. All you have to do to make a copy of ...

Past Perfect Continuous Tense Description- The past perfect continuous tense (also known as the past perfect progressive tense) shows that an action that started in the past continued up until another time in the past. The past perfect continuous tense is constructed using  had been + the verb’s present participle (root + -ing). Unlike the present perfect continuous, which indicates an action that began in the past and continued up to the present, the past perfect continuous is a  verb tense that indicates something that began in the past, continued in the past, and also ended at a defined point in the past. Kindly look the below given Example- He   had been drinking   milk out the carton when Mom walked into the kitchen.

Create a formula that refers to values in other cells_Features of that must known you. Select a cell. Type the equal sign =. Note:  Formulas in Excel always begin with the equal sign. Select a cell or type its address in the selected cell. Enter an operator. For example, – for subtraction. Select the next cell, or type its address in the selected cell. Press Enter. The result of the calculation appears in the cell with the formula. To see a formula When a formula is entered into a cell, it also appears in the  Formula bar. To see a formula, select a cell, and it will appear in the formula bar. Enter a formula that contains a built-in function Select an empty cell. Type an equal sign = and then type a function. For example, =SUM for getting the total sales. Type an opening parenthesis (. Select the range of cells, and then type a closing parenthesis). Press Enter to get the result.

File Management Tricks- Rename a file quickly  Right-clicking and selecting rename is not very efficient. Instead press F2 while a file is selected to change its name. To alter the name of another file, type Tab without deselecting the current file. On Macs, hitting Enter will rename (which may sound counter-intuitive to Windows users) while Cmd + O is used to open. Cloud backup important files  If you're working on a critical project, make sure you aren't backing up locally only. Services like  Dropbox ,  Google Drive , or  any  of the other popular cloud storage solutions will do the legwork for you in the background. Of course, you can also throw the files on a thumb drive or external HDD to be extra safe, but backing up to the cloud can be done seamlessly. Rename files sequentially in Windows or Mac  You actually don't need to download any programs to perform a batch file rename. Instead, you can select all the files you want to change, r...