Microsoft Excel – Advanced

Please enter your email:

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

 
 

2. What is a Macro

 
 
 

3. What is the purpose of a Pivot Table

 
 
 

4. Which is the correct structure for a IF statement

 
 
 
 

5. What does a VLOOKUP do?

 
 
 
 
 

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

 
 

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

 
 

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

 
 
 
 

9. What is the purpose of the SUMIFS formula

 
 
 
 

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

 
 

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

 
 

12. What is the purpose of the SUMIF formula

 
 
 
 

Question 1 of 12