What is the CURRENCYCONVERT formula and how do I use it in Sheet for bulk conversions?

The CURRENCYCONVERT formula lets you convert currencies directly within Google Sheets. Syntax: =CURRENCYCONVERT(fromCurrency, toCurrency, amount, date). You can omit the amount or date if needed. Supports historical exchange rates and works seamlessly with cell references.