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 include additional adjacent worksheet columns or rows using the mouse, drag the ____ up, down, left, or right to select the range that you want to include in the table.
A
resize handle
B
arrow
C
fill
D
None of the above
Explanation: 

Detailed explanation-1: -To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

Detailed explanation-2: -Add one row, column, or cell Right-click the row, column, or cell. From the menu that appears, select Insert 1 left, right, above or below.

Detailed explanation-3: -Select the cell with the formula, and hover the mouse cursor over a small square at the lower right-hand corner of the cell, which is called the Fill handle. As you do this, the cursor will change to a thick black cross. Hold and drag the fill handle down the column over the cells where you want to copy the formula.

Detailed explanation-4: -Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off. To do that, press the Scroll Lock key (labeled as ScrLk) on your keyboard.

There is 1 question to complete.