Question

Starting in cell E4. Complete the series of substitution values ranging from 2% to 6.5% at increments of .50% vertically down column E

Answer 1

There are several ways to enter a formula in Excel; one of these ways is by using an auto generated formula

The formula in cell E5 is = E4 + 5

From the complete question, we have the following highlights.

• Cell E4 represents the initial cell, with a value of 50
• Cell E5 to E20 will be auto generated by substitution with an increment of 5

So, the steps are as follows:

• Write 50 in cell E4
• Write =E4 + 5 in cell E5
• Drag the content of cell E5 downward, then stop at cell E20

Read more about Excel formulas at:

https://brainly.com/question/1285762