MS Excel question.
 

I want to create a new column that takes all the prices in Column D and marks them up 20%. How do i do this?

In column E write =D1 * 1.20

Copy that cell down tot he end of your list

Say you've got D1-D20 with numbers. In E1, type "=D1*1.2". Then copy and paste it to E2-E20. If there are a ton of rows, I think you can click on a dot in the lower right corner of the cell and drag it downward, or something like that, and they'll all fill in with E1's formula.

cool thanks, how do i make the values into dollars.

ie.
12.0825 = $12.08

Highlight the cells, right click, and hit format cells. Click the number tab and hit Currency.