Question

On the Projected Sales (Next Year) worksheet, what action should be taken to add a new column named "3% Increase" projecting sales with a 3% increment?

a) =Sales * 1.03 in the first cell of the new column.
b) Insert a column and use the formula =Sales * 1.03.
c) Copy the Sales column, paste it in a new column, and apply a 3% increase formula.
d) Use the "Add Column" option in the Data tab and input the formula =Sales * 1.03.

Answer 1

To add a new column named '3% Increase' projecting sales with a 3% increment on the Projected Sales (Next Year) worksheet, you should insert a column and use the formula =Sales * 1.03.

Step-by-step explanation:

To add a new column named '3% Increase' projecting sales with a 3% increment on the Projected Sales (Next Year) worksheet, the correct action to take is option b) 'Insert a column and use the formula =Sales * 1.03.'