FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The following buttons that can be used to shift the active cell are ____
A
enter key
B
tab key
C
Direction button
D
All wrong
Explanation: 

Detailed explanation-1: -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-2: -SHIFT+PAGE DOWN Extend the selection down one screen. SHIFT+PAGE UP Extend the selection up one screen. END+SHIFT+arrow key Extend the selection to the last nonblank cell in the same column or row as the active cell. END+SHIFT+HOME Extend the selection to the last used cell on the worksheet (lower-right corner).

Detailed explanation-3: -The correct answer is F2. F2 function key is used to edit the content of a cell in MS-Excel. To enter Edit mode, we can follow any of these steps: Double-click the cell that contains the data that you want to edit.

There is 1 question to complete.