In Excel 2016, if you want to insert 3 columns between column G and column H,…
2022
In Excel 2016, if you want to insert 3 columns between column G and column H, what should you do?
- A.
Select column G and right click and select insert for 3 times
- B.
Select column H and right click and select insert for three times
- C.
Select column E, F and G and right click and select insert for three times
- D.
Select column D, E and F and right click and select insert for three times
Attempted by 1423 students.
Show answer & explanation
Correct answer: B
Answer: Select column H and right-click and select Insert three times.
In Excel, a new column is inserted to the left of the selected column. To place new columns between G and H, the insertion must happen before column H. Therefore, selecting column H and inserting a column three times creates three new columns between G and H.