USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl + =
|
|
|
Ctrl + !
|
|
|
Shift +
|
|
|
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: -Toggle formulas on and off On your keyboard, typing the shortcut command Ctrl+‘, will toggle on (or show) the formulas. (Note that the ‘ in this shortcut is the grave accent mark, usually located to the left of the 1 key on your keyboard.) Typing the shortcut command Ctrl+‘ again will toggle off the formulas.
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: -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.