Which action inserts a new column using the Insert option in the Excel Ribbon?

Which action inserts a new column using the Insert option in the Excel Ribbon?

• A. View tab, Split.
• B. Home tab, Cells group, Insert Arrow, Insert Sheet Columns.
• C. Home tab, Cells group, Delete, Delete Sheet Columns.
• D. Review tab, New Comment.

Answer: (B)

In Excel, adding a new column is done from the Home tab, inside the Cells group, by using the Insert control and choosing Insert Sheet Columns. This path explicitly adds a column to the worksheet, placing the new column to the left of the currently selected column. The other options don’t insert columns: using the View tab with Split changes how the sheet is viewed, Delete removes columns, and New Comment adds a note.

In Excel, adding a new column is done from the Home tab, inside the Cells group, by using the Insert control and choosing Insert Sheet Columns. This path explicitly adds a column to the worksheet, placing the new column to the left of the currently selected column. The other options don’t insert columns: using the View tab with Split changes how the sheet is viewed, Delete removes columns, and New Comment adds a note.