Create a formula that multiplies the salary in column C with the percentage (to be added) in column D and places the result in column E. Fill the whole column with that formula.

Assuming data input starts in the second row of the worksheet of the excel spreadsheet application, in the second cell of column E, input the formula "= C1 * D1". Then copy the formula down the column by dragging the right-bottom corner downward.

Explanation:

Microsoft Excel is a spreadsheet application used for statistical analysis of data. It provides several built-in formulas, graphs, and storage links to calculate, represent, and retrieve or store data to remote and local storage.

To make a dynamic formula, the equal to sign is typed before any column variable, then a short cut key combination or dragging the right-bottom corner to the end of the used worksheet can be used to copy formulas.