Please enter your email:

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

Yes

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

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

Yes

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

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

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

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

Yes

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

Yes

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

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

True /1

False / 0

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

Question 1 of 11

Microsoft Excel Advanced Quiz