204k views
5 votes
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.

User Divided
by
5.4k points

1 Answer

6 votes

Answer:

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.

Step-by-step 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.

User Utiq
by
6.2k points