Column | MCQs

Explanation

To select an entire column in MS-EXCEL:

• Click the column heading letter.
• Press CTRL + Space Bar key.

Explanation

Explanation

Explanation

• This is the standard SQL syntax to drop a column from a table.
• The ALTER TABLE statement is used to modify the structure of a table, and the DROP COLUMN clause is used to delete a column.
• An example: ALTER TABLE MyTable DROP COLUMN MyColumn;

Explanation

To adjust a column width to fit its contents in Excel, you can:

Double-click the boundary to the right of the column heading.

This action automatically resizes the column width to match the longest entry in that column.

This ensuring that all data is visible without manually adjusting the width.

Explanation