How to make an excel work book make an exchange rate?

to keep A1 constant, make the formula read =B2*$a$1 (the $ sign tells excel to fix that part of the formula (row & column), for example if you wanted to keep column a constant, the formula would be $a1, or to keep the row constant, a$1)