Intermediate Excel Test

As per spreadsheet image, we want to create a formula in cell J4 which will work out the commission due to Lorraine. The Commission rate is in Cell F1. We will want to copy down these formulas. From the list below which is the most effective formula.

As per spreadsheet image, we want to create an IF Function in cell I2 and copy ,which will output True if the commission is greater than or equal to 350 or leave the cells empty if not.
Pick the IF Function below which does this.

We want to create a VLOOKUP Function in cell D12, which will return the Wednesday sales figures for whatever sales person is entered into cell C12.
Which of the VLOOKUP Functions below is the best.

We need to create a SUMIF Function in cell G4,which will give us the total minutes played for whatever band is typed into Cell F4.
Which of the SUMIF Functions below is correct and the most effective.

I need to create a formula in D2 downwards which will only show loans from identifiers in column A beginning with US. Which of the formulas below do this successfully?

What number does Excel associate with the date 2 December 2014?

I have created a dropdown box in sheet1 like the image below.

I want to create the same dropdown list in sheet2, which of the statements below is True?

Because the cell in C12 is empty, the VLOOKUP Function in D12 is showing the #N/A Error message. How can we hide this error message. Which of the following will do this effectively?

I want to create a macro of a logo which I want to be able to place in different positions in various worksheets of various workbooks.
What much I make sure I do?

I have various conditional formats on my worksheet. I just need to delete one of them. How do I do this?

I have a value in cell A1 in Sheet1 worksheet and I have a value in cell A1 in sheet2 worksheet.

I want to create a formula in worksheet Sheet3 which will add them together.Which is the correct formula.