Please enter your email:

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

True /1

False / 0

2. What does a VLOOKUP do?

Selects specific data for you

Returns only numbers from a specific code reference

Returns only text from a specific code reference

Returns information from a table based on a specific code reference

Looks for possible variables in a formula

3. What is a Macro?

The method used to consolidate 2 sheets of data

A high level of protection

A way of making Excel remember a set of commands to be repeated later

4. What is the purpose of a Pivot Table

To modify the original data

Create quick reports for extensive analysis

To move a table from one place to another

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

=IFERROR(6/0,”Cannot divide by 0″)

=IFERROR(6/0,Cannot divide by 0)

=IFERROR(“Cannot divide by 0”,6/0)

=IF(6/0, IS AN ERROR, “Cannot divide by 0”)

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

Yes

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

Yes

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

Yes

9. Which is the correct structure for an IF statement

=IF(F3>=40,Pass,Fail)

=IFSTATEMENT(F3>=40,”Pass”,”Fail”)

=IF(F3>=40,”Pass”,”Fail”)

=IF(F3>=,40,”Pass”,”Fail”)

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

Yes

11. What is the purpose of the SUMIF formula

Sums the numbers

Sums the numbers IF there are any

Sums the numbers in a column based on a criteria

Sums the numbers in a column based on different criteria’s

Question 1 of 11

Microsoft Excel Advanced Quiz