Question

Beginning in cell B21, complete the series of substitution values ranging from $35 to $45 in increments of $2.50 vertically down column B.

Answer 1

In order to complete the series of substitution values from $35 to $45 in increments of $2.50, follow these steps:

• Input $35 in B21.
• Highlight B21 to B26.
• Go to the Home tab.
• Go to the Editing ribbon.
• Click on Fill.
• Click on Series.
• Step Value = 2.50
• Stop Value = 45.
• Click Okay.

How can you complete a series of Substitution values?

First input the value you are to start with in the cell you are to start with. In this case that means putting $35 in Cell B21.

Highlight B21 to B26 and then go to the Home tab. Go to the Editing ribbon at the bottom right and click on Fill. Then go to Series and input the step value as 2.50 and the stop value as 45. Click okay and the range will appear.

Find out more on spreadsheet functions at brainly.com/question/1395170.