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