Advanced Excel Test
Quiz Summary
0 of 8 Questions completed
Questions:
Information
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:
Results
Results
0 of 8 Questions answered correctly
Your time:
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)
Categories
 Not categorized 0%
 1
 2
 3
 4
 5
 6
 7
 8
 Current
 Review
 Answered
 Correct
 Incorrect

Question 1 of 8
1. Question
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
2. Question
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
3. Question
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
4. Question
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
5. Question
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
6. Question
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
7. Question
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
8. Question
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