How do you insert a column to the left of column E?

How do you insert a column to the left of column E?

• A. Home tab, Cells group, Delete, Delete Sheet Columns.
• B. Data tab, Data Tools, Text to Columns.
• C. Home tab, Cells group, Insert arrow, Insert Sheet Columns.
• D. Review tab, Protect Sheet.

Answer: (C)

To insert a column to the left of E, first select column E. Then go to the Home tab, in the Cells group click the Insert dropdown arrow and choose Insert Sheet Columns. Excel will insert a new blank column immediately to the left of the selected column. The other options don’t perform column insertion: one deletes columns, one splits text into columns, and one protects the sheet.

To insert a column to the left of E, first select column E. Then go to the Home tab, in the Cells group click the Insert dropdown arrow and choose Insert Sheet Columns. Excel will insert a new blank column immediately to the left of the selected column. The other options don’t perform column insertion: one deletes columns, one splits text into columns, and one protects the sheet.