Please enter your email:

1. What is a Macro?

 
 
 

2. What is the purpose of a Pivot Table

 
 
 

3. What does a VLOOKUP do?

 
 
 
 
 

4. Which is the correct structure for an IF statement

 
 
 
 

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

 
 

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

 
 

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

 
 

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

 
 

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

 
 

10. What is the purpose of the SUMIF formula

 
 
 
 

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

 
 
 
 

Question 1 of 11

Executrain