Microsoft Excel - Advanced

Please enter your email:

1. What is the purpose of the SUMIFS formula

Sums the numbers

Sums the numbers IF there are any

Sums the numbers based on a criteria

Sums multiple columns of numbers based on different criteria’s

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

Yes

3. 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 possibly variables in a formula

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

True /1

False / 0

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. Which is the correct structure for a IF statement

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

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

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

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

7. What is the purpose of the SUMIF formula

Sums the numbers

Sums the numbers IF there are any

Sums the numbers based on a criteria

Sums multiple columns of numbers based on different criteria’s

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

Yes

9. Can another formula e.g. AVERAGE be used inside a IF statement?

Yes

10. 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 A ERROR, “Cannot divide by 0”)

11. What is a Macro

The method used to consolidate 2 sheets of data

A hight level of protection

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

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

Yes

Question 1 of 12