USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl + Space bar
|
|
|
Shift + Space bar
|
|
|
Ctrl + A
|
|
|
None of the above
|
Detailed explanation-1: -CTRL+Spacebar is the shortcut key used to select column. In Excel, hit Ctrl plus the Space Bar to select the entire column of your active or selected cells.
Detailed explanation-2: -CTRL+SPACEBAR Select the entire column. SHIFT+SPACEBAR Select the entire row. CTRL+A Select the entire worksheet. SHIFT+BACKSPACE With multiple cells selected, select only the active cell.
Detailed explanation-3: -To select an entire row, click the row number or press Shift+spacebar on your keyboard. To select an entire column, click the column letter or press Ctrl+spacebar.
Detailed explanation-4: -Press F5 or CTRL+G to launch the Go To dialog. In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box, then press OK. For example, in the Reference box, type B3 to select that cell, or type B1:B3 to select a range of cells.
Detailed explanation-5: -To select all cells on a worksheet, use one of the following methods: Click the Select All button. Press CTRL+A. Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing CTRL+A selects the current region.