Advanced Excel Test
0 of 8 Questions completed
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 8 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Question 1 of 8
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.CorrectIncorrect
Question 2 of 8
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?CorrectIncorrect
Question 3 of 8
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.?CorrectIncorrect
Question 4 of 8
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?CorrectIncorrect
Question 5 of 8
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?CorrectIncorrect
Question 6 of 8
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?CorrectIncorrect
Question 7 of 8
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?CorrectIncorrect
Question 8 of 8
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.CorrectIncorrect