Highlight the two cells A2:A3 and copy down until you reach the value 30 000. To create the sequence, point your cursor at the bottom right corner of the highlighted range. The shape of the cursor changes to thin plus sign. Release your cursor when you reach the desired value. In this case, the value 30 000 is reached in cell A12.
In cell B1 type the heading "Rental Cost, C".Revenue, R | Rental Cost, C |
---|---|
0 | 20000 | 3000 | 20450 | 6000 | 20900 | 9000 | 21350 | 12000 | 21800 | 15000 | 22250 | 18000 | 22700 | 21000 | 23150 | 24000 | 23600 | 27000 | 24050 | 30000 | 24500 |