Josh wants to insert a column in an Excel table to add the values from two other columns. Which of the following methods can he use to insert a table column?
A) Click a column header and then click the Insert button on the Home tab.
B) Right-click a column header, click Format Cells on the shortcut menu, and then click Add New Column.
C) Click a column header, click the filter arrow, and then click Insert.
D) Double-click a column header and then click Insert on the shortcut menu.

Question

Quizplus · Accepted Answer

To insert a new column in an Excel table, the user can click on a column header (the letter at the top of the column), navigate to the Home tab, and click the Insert button. This will add a new column to the left of the selected column. Option B is incorrect because choosing "Format Cells" will only open a dialog box to edit the formatting of the selected cell(s). Option C is incorrect because clicking the filter arrow will only allow the user to filter the data in the column, not insert a new column. Option D is incorrect because double-clicking a column header will only select the whole column, not give the option to insert a new column.

Josh Wants to Insert a Column in an Excel Table