# Function

1. The SUM function returns the value 10 instead of 14. Why the 4 is not included?

2. What is the result of the following formula?

3. The following formulae use the basic mathematics operator (+, -, *, /) and parentheses. Which of the following formulae returns 36?

4. We give a bonus of 200\$ for all the employees who have sold 20 units or more. Which formula do the job?

5. Which formula calculates the for each row the Total?

6. Which result returns the formula =DCOUNT(A1:E13,3,H1:H2)

7. Which functions can transform the text in uppercase?

8. How to write the DCOUNT function to return the following result?

9. What returns the function DSUM in this situation?

10. You want to plan a meeting for the companies in the cities of Manchester and Bristol with more than 20 employees.

How to write the formula?

11. Which formula returns the minimum time worked in the week?

12. What result returns the formula =VLOOKUP(F5,A2:D18,4,0)

13. Which answer(s) returns the average for each student?

14. Which Excel function returns the position of a value in a list?

15. How do you write a logical test to select hotels with a Fitness room, with 3 stars classification or more, and the price of the menu is less than 30?

16. What is the result returned by the SUMIFS function

17. This question concerns the position of dollars in a formula.

We want to construct a multiplication table by using the values in the headers, column A, and row 1.

How do you write the formula in B2 to stay on the row 1 and column A?

18. What is the result returned by the function DATE?

19. Which formula extracts the room number?

20. What is the result returned by the formula =DATE(B1,B2,1)-1

21. Which formula or tool can join the name and the first name?

22. Which formula returns the number of items where the quantity is greater or equal than 6?

23. How to return the product name according to the Product ID?

24. What is the result returned by the formula =VLOOKUP(F5,A2:D11,3,0) ?

25. Which Excel function removes the spaces before each name?

26. Which Excel function returns the position of the space in the text?

27. In this example, you have the different Vehicle Internal Numbers (VIN)

How to extract the VDS which is the characters between the 4 and 9 position?