DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CTRL +
|
|
|
CTRL + !
|
|
|
CTRL +-
|
|
|
CTRL + *
|
Detailed explanation-1: -The easiest way is to use the keyboard shortcut Ctrl + ‘. This shortcut will toggle the formulas on and off. If you want to see all the formulas in a sheet at once, you can use the shortcut Ctrl + Shift + ‘. This shortcut will highlight all the cells that contain formulas.
Detailed explanation-2: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).
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.
Detailed explanation-4: -Key Description Ctrl+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel.
Detailed explanation-5: -Ctrl+F6 in MS Excel 2007 is used to switches to the next workbook. It is useful when more than one workbook window is open.