USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select the first column. Hold down Ctrl and press the right arrow on the keyboard.
|
|
|
Select the first column. Hold down Ctrl and drag the mouse cursor towards the right.
|
|
|
Select the first column. Hold down Shift and press the right arrow on the keyboard.
|
|
|
All of the above options are correct.
|
Detailed explanation-1: -Selecting multiple columns, especially if they run into the hundreds, can take a long time if you do this the manual way by using your mouse. What is a shortcut for quickly selecting a range of contiguous columns? Select the first column. Hold down Shift and press the right arrow on the keyboard.
Detailed explanation-2: -You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).
Detailed explanation-3: -The shortcut key to group rows in Excel is Alt + Shift + Right Arrow. To use this shortcut key, simply select the range of cells that you want to group together and then press Alt + Shift + Right Arrow on your keyboard. Excel will automatically group the data together.
Detailed explanation-4: -AutoSum is a fast, easy way to add up multiple values in Excel. You can access the AutoSum command from either the Home tab or the Formulas tab, but there is a keyboard shortcut that makes it even faster: Alt+=. To use this shortcut, simply hold down the Alt key, then press the equals sign on your keyboard.