Please enter your email:
1. What is the purpose of a Pivot Table
2. Can another formula e.g. AVERAGE be used inside a IF statement?
3. Can the numbers in a Pivot Table be converted to show the percentage they make of the total?
4. What does a VLOOKUP do?
5. Can you combine more than 1 IF Statement together in a single cell
6. What is a Macro
7. What should the [Range_Lookup] in a VLOOKUP be, to return you an EXACT match from the table
8. Which is the correct structure for a IF statement
9. Can you have the data in a Pivot Table display the sum and average of the numbers?
10. What is the correct structure of the IFERROR formula?
11. What is the purpose of the SUMIF formula
Question 1 of 11