Join 60,000+ competitive exam aspirants
In MS Excel, which option allows you to insert a new column between column B and C?
Right-click on Column C header → Insert
Use "Clear Contents" option
Right-click on Column B header → Delete
Select Column C → Press Delete
Right-click on Column C header → Insert
To insert a new column in MS Excel, users must select the column to the right of where the new column is desired and use the Insert command. Right-clicking the header of column C and selecting 'Insert' shifts existing columns to the right, creating a blank column at position C.
To insert a new column in MS Excel, users must select the column to the right of where the new column is desired and use the Insert command. Right-clicking the header of column C and selecting 'Insert' shifts existing columns to the right, creating a blank column at position C.
The development of spreadsheet software traces back to VisiCalc (1979), the first spreadsheet program for personal computers, which set the standard for grid-based data management used in modern government administrative databases.
Excel inserts new columns to the left of the currently selected column header.
Keyboard shortcut for inserting a column is Ctrl + Shift + + (Plus sign).
Columns in Excel are identified by alphabetic headers, while rows are identified by numeric headers.
Right-clicking the header of column C shifts the existing content of column C and all subsequent columns to the right.
Option B (Clear Contents) only removes the data within cells without deleting or shifting the column structure.
Option C (Delete) removes the existing column B permanently, shifting subsequent columns left, which is the opposite of the objective.
Option D (Delete key) only erases cell entries, maintaining the spreadsheet structure and layout.
A is correct — Right-clicking the column header C and selecting Insert shifts the current column C to the right, creating a new empty column in the C position.
In competitive exams, always distinguish between 'Deleting' (removing structure) and 'Clearing Contents' (removing only data). This distinction is also critical in database management systems (DBMS) when working with SQL commands like DROP vs DELETE.