Advanced Excel Test

In the spreadsheet below, I want to create a formula in cell G2 that will bring back the product name of whatever Trace No I put in cell F2.
Which of the formulas below will do this in the most effective manner.

In relation to the question one above, I am not happy using the column number for Products in my formula.
I want to make my formula completely dynamic in case extra columns are added to the list. Which of the formulas below will achieve this?

In cell J2 of the spreadsheet below, we want to create a function which will tell the revenue figure for the product sold (cell I2) by the salesperson in cell H2.
Which of these formulas achieve this.?

Similar to the question above, but this time, we want to count in cell K2 the number of sales a particular salesperson sold of a particular product.
Which of these formulas achieve this?

I want to use a SUMPRODUCT Function in cell J7 to work out the value of my portfolio, as in the spreadsheet below.
Which Function below will do this effectively?

I want Excel to move dynamically from cell A1 down three rows, then to move across four columns and add that value and the value below.
The answer needs to be displayed in cell A7. Which formula below will do this?

In the spreadsheet below, a business owner charges a different price for the apples he sells, depending on the quantity you buy.
He wants to create an nested IF Function in cell B9 to automatically work out the price for any quantity ordered. The ordered amount is put in cell A9. Which of the below IF Function would do this?

In relation to question 7 above, what would the Function be if he wanted to use cell references for the price breaks instead of using 500,1200 and 2000 and cell references for all the different prices.