After inserting a column to the left of E, which statement is true?

After inserting a column to the left of E, which statement is true?

• A. A new blank column appears between D and E.
• B. Column E becomes column D.
• C. All data in E2:E14 moves to F2:F14.
• D. Only the header row moves.

Answer: (A)

When you insert a column to the left of a chosen column, a new blank column is added at that exact position and all existing columns shift to the right. So inserting to the left of E places a new empty column between D and E. That immediate change is the most visible and unambiguous result of the operation. After the insertion, the original E column moves one column to the right (to F), so its data would end up in F2:F14 as a consequence. The other statements describe outcomes that don’t match the direct effect: there’s no leftward move of E to D, not only the header moves, and while data does shift to the right, the key, immediate result of the insertion is the new blank column between D and E.

When you insert a column to the left of a chosen column, a new blank column is added at that exact position and all existing columns shift to the right. So inserting to the left of E places a new empty column between D and E. That immediate change is the most visible and unambiguous result of the operation. After the insertion, the original E column moves one column to the right (to F), so its data would end up in F2:F14 as a consequence. The other statements describe outcomes that don’t match the direct effect: there’s no leftward move of E to D, not only the header moves, and while data does shift to the right, the key, immediate result of the insertion is the new blank column between D and E.