USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl + ‘
|
|
|
Ctrl +
|
|
|
Ctrl + Tab
|
|
|
Ctrl + =
|
Detailed explanation-1: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).
Detailed explanation-2: -Showing all formulas in all cells 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-3: -To use this shortcut, simply hold down the Ctrl key and then press the semicolon key, and it will instantly add the current date. Similarly, if you need to add the current time, you can use the Ctrl+Shift+; shortcut. Just hold down the Ctrl and Shift keys, then press the semicolon key.
Detailed explanation-4: -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-5: -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.