FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To select an entire column using the mouse, position the cell pointer ____ and then click the left mouse button.
A
On the bottom cell of the column
B
On the top cell of the column
C
On the column header
D
Anywhere in the column
Explanation: 

Detailed explanation-1: -Place the cursor at the column heading of one of the columns (say column D in this case) Click the mouse left key to select the column. Press and hold the Control key. With the Control key pressed, select all the other columns you want to select.

Detailed explanation-2: -Black Arrow Selects a whole column (vertical arrow) or row (horizontal arrow). You can select multiple columns or rows by clicking and dragging.

Detailed explanation-3: -Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space. Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space.

Detailed explanation-4: -You can also click anywhere in the table column, and then press CTRL+SPACEBAR, or you can click the first cell in the table column, and then press CTRL+SHIFT+DOWN ARROW. Note: Pressing CTRL+SPACEBAR once selects the table column data; pressing CTRL+SPACEBAR twice selects the entire table column.

There is 1 question to complete.
Previous
Next