FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To delete a column in a worksheet, you can select the column header and use which of the following shortcut keys?
A
Ctrl+Plus sign (+)
B
Ctrl+Slash (/)
C
Ctrl+Hyphen (-)
D
Ctrl+Asterisk (*)
Explanation: 

Detailed explanation-1: -Detailed Solution. If you want a shortcut to delete a cell/row/column in Excel, first select that cell/ entire row/entire column, then press “Ctrl” followed by the minus button “-” (all at the same time) on your keyboard.

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. 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-3: -Ctrl + Shift + Delete-This shortcut will delete the selected cells, column, or row and shift the remaining cells down or right. Alt + Delete-This shortcut will delete the selected cells, column, or row and all cells to the left or above.

There is 1 question to complete.