In MS-Excel what do we drag or double-click for adjustment of the width of a column?

Question

Accepted Answer

The correct option is (2):
The correct feature used to adjust the width of a column in MS-Excel is the **Column marker**, which is also commonly referred to as the column boundary or separator. This marker is the thin vertical line located on the column header row, specifically positioned between the letter headings of two adjacent columns (for example, the line separating column 'A' from column 'B'). You can perform two key actions on this marker: first, clicking and dragging it to the left or right allows you to manually set the column to a precise, desired width. Second, double-clicking this marker activates the 'AutoFit Column Width' feature, which automatically and instantly adjusts the column size to be just wide enough to perfectly fit the longest data entry within any cell in that column.

The incorrect option is (1):
The **Cell pointer** refers to the thick, dark border that surrounds the currently selected cell, which is known as the Active Cell. Its primary and only function is to visually indicate which specific cell is currently selected and ready to receive data or a command. It is a navigational and input focus indicator, not a tool for modifying the structural dimensions of the column or row. Attempting to drag or double-click the cell pointer itself will not initiate any column width adjustment; such an action would, at most, result in selecting a range of cells or attempting to edit the active cell. Therefore, the cell pointer has no role in resizing columns.

The incorrect option is (3):
The **Fill handle** is the small, prominent black square located exclusively at the bottom right corner of the active cell. This feature is a powerful tool for quickly automating data entry and manipulation. Its purpose is to copy or extend the content, formula, or a sequential pattern (like a series of numbers or dates) from the active cell into adjacent cells. For instance, it is used to copy a formula down a column or to quickly generate a sequence like 'Jan, Feb, Mar'. Dragging or double-clicking the fill handle pertains entirely to duplicating or extending cell *content* and has no function for changing the structural *width* of a column.

The incorrect option is (4):
The **Formula bar** is the long, horizontal input area prominently located directly above the main worksheet grid, positioned next to the Name Box. Its fundamental purpose is to display and allow the user to view or edit the complete content, including complex formulas, of the active cell. Although it is an essential part of the Excel interface for data entry and modification, it serves purely as an editing and viewing component. It contains no interactive elements that permit dragging or double-clicking to physically modify the width of a column on the grid below it.