Please enter your email:

1. What does a VLOOKUP do?

 
 
 
 
 

2. What is the purpose of a Pivot Table

 
 
 

3. Can another formula e.g. AVERAGE be used inside an IF statement?

 
 

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

 
 

5. Which is the correct structure for an IF statement

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 

9. What is a Macro?

 
 
 

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

 
 

11. What is the purpose of the SUMIF formula

 
 
 
 

Question 1 of 11