Please enter your email:

1. What is the purpose of a Pivot Table

2. What is the purpose of the SUMIF formula

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

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

5. Which is the correct structure for a IF statement

6. What is a Macro

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

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

9. What is the purpose of the SUMIFS formula

10. What does a VLOOKUP do?

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

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

Question 1 of 12

CONTACT US

Your Name* Your Email* Your Message* Comments This field is for validation purposes and should be left unchanged.