Please enter your email:

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

 
 

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

 
 

3. Which is the correct structure for an IF statement

 
 
 
 

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

 
 

5. What is the purpose of a Pivot Table

 
 
 

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

 
 

7. What is a Macro?

 
 
 

8. What does a VLOOKUP do?

 
 
 
 
 

9. What is the purpose of the SUMIF formula

 
 
 
 

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

 
 

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

 
 
 
 

Question 1 of 11