If you’re working on your accounts and you need to convert all your overseas expenses into the currency you file your tax returns in, you need to know the exchange rate for the date of every expense.

You can find the Average of a value by selecting the cell below or to the right of values that you want to Average. Then go to the Editing Group, select the Auto-Sum Tool. You will see a drop-down ...