Please enter your email:

1. 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

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. Can the numbers in a Pivot Table be converted to show the percentage they make of the total?

Yes

4. 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”)

5. 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

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

Yes

7. 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

8. 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”)

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

Yes

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

True /1

False / 0

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

Yes

Question 1 of 11

Microsoft Excel Advanced Quiz