Correct option is B
To insert three new columns between
G and
H in Excel 2016:
1. Select
column H (the column to the right of where the new columns should appear).
2. Right-click and choose
Insert three times.
3. This shifts column H and all subsequent columns to the right, creating three empty columns between G and H.
Important Key Points:
1.
Insertion of multiple columns requires repeating the insert action for each new column or selecting the exact number of columns to insert beforehand.
2. Selecting the column where new columns will be inserted ensures proper placement.
3. Keyboard shortcut: Press
Ctrl + Shift + "+" after selecting the required column.
Knowledge Booster:
· Selecting columns
E, F, and G or others (as per options) does not affect columns G and H.
· You can also use the Excel ribbon: Go to
Home → Insert → Insert Sheet Columns.
· Efficient column insertion is vital when managing large datasets in Excel.