The controller for Sales has asked you for the latest Sales Data by region. To provide that information, you must first convert the Sales Data from local currency to the company's functional currency. Perform the following steps to make the necessary conversions:

On the Sales Data sheet, in cell H$2,$ enter a formula to calculate the total sales for Argentina. Use absolute column and relative row references for the cell range.

Copy the formula created in H $2$ to the remaining rows in column H $.$

On the Sales Data sheet, in cell I$2,$ enter a formula to convert the local currency to the functional currency. Use absolute cell references. For this cell, multiply H $2$ by the Argentine Peso rate on the Exchange Rate sheet in C$3.$

Repeat the previous step for the remaining empty cells in that column. Use the appropriate rate from column C on the Exchange Rate sheet.

On the Region sheet, in cell $C3,$ enter a formula to calculate total sales in the functional currency. Use the defined name AMER.

Repeat the previous step for cells C$4$:C$5$ using APAC and EUR defined names.

On the Sales Data sheet, in cell $H2,$ enter a formula to calculate the total sales for Argentina. Use absolute column and relative row references for the cell range.

Copy the formula created in H $2$ to the remaining rows in column H $.$

On the Sales Data sheet, in cell $12,$ enter a formula to convert the local currency to the functional currency. Use absolute cell references. For this cell, multiply H $2$ by the Argentine Peso rate on the Exchange Rate sheet in C$3.$

Repeat the previous step for the remaining empty cells in that column. Use the appropriate rate from column C on the Exchange Rate sheet.

On the Region sheet, in cell C$3,$ enter a formula to calculate total sales in the functional currency. Use the defined name AMER.

Repeat the previous step for cells C$4$:C$5$ using APAC and EUR defined names.