This is Excel Homework.

Type the number one in cell "A1", and have A2 through A5 be populated with a function which returns the value of the cell above it plus one. Type the value ten in cell D2. Type a function in cell B1 which takes the value to the left of the cell and multiplies it by the value of D2, and then drag the function down through B5. The formula should automatically update to include whichever cell is to the left of the target, but not move the reference to cell D2. It should look something like the image below, where the black numbers are typed in directly, and the green and blue numbers are automatically calculated from one function each. Your submission does not need to be color coded 1. L12 10 20 30 40 50 2 2 10 4 4