Microsoft Excel – Advanced

Please enter your email:

1. What should the [Range_Lookup] in a VLOOKUP be, to return you an EXACT match from the table


2. Can you combine more than 1 IF Statement together in a single cell


3. Can you have the data in a Pivot Table display the sum and average of the numbers?


4. What is the purpose of the SUMIFS formula


5. Can the numbers in a Pivot Table be converted to show the percentage they make of the total?


6. Which is the correct structure for a IF statement


7. What is the correct structure of the IFERROR formula?


8. What is the purpose of the SUMIF formula


9. What does a VLOOKUP do?


10. What is a Macro


11. Can another formula e.g. AVERAGE be used inside a IF statement?


12. What is the purpose of a Pivot Table


Question 1 of 12