FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -To show formulas in all cells press CTRL+‘ (that little mark is the grave accent mark key). When the formulas are visible, print your worksheet as you normally would. To switch back to showing formula results in all cells, press CTRL+‘ again.

Detailed explanation-2: -To use this shortcut, simply hold down the Ctrl key and then press the semicolon key, and it will instantly add the current date.

Detailed explanation-3: -Ctrl+F6 switches to the next workbook window when more than one workbook window is open. F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range. Ctrl+F7 performs the Move command on the workbook window when it is not maximized.

Detailed explanation-4: -Shift + F7. “Shift + F7” opens the “Research” task pane in your excel workbook. It provides the same output as you get by navigating to “Review” Tab on top of excel ribbon and then clicking on “Research” button.

Detailed explanation-5: -To search for a specific value in a worksheet, press Ctrl + F on your keyboard. This will open the Find and Replace dialog box. Enter the value you’re looking for in the Find what field, and then click the Find All button. Excel will highlight all of the cells that contain the value you’re searching for.