Microsoft Excel - Advanced

Please enter your email:

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

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

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

Yes

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

Yes

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

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

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

Yes

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

True /1

False / 0

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

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

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

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

Yes

Question 1 of 12