Theme 4 Evaluation Test: FUNCTIONS

There is only one correct answer to each question. Click on the answer you consider to be correct.

Answer all the questions and click on the Revise button to see the answers.

If you click on Restore you will be able to repeat the evaluation.

1. If we click on the button on the toolbar we will access the Insert function... dialog box directly .
a) True.

b) False.

2. To introduce a function we need to always use the Insert function dialog box.
a) True.

b) False.

3. A function can have other functions added to it.
a) True.

b) False.

4. A function always starts with a "=" sign.
a) True.

b) False.

5. If a function exists to perform an operation we always use it.
a) True.

b) False. .

6. Which of the following formulas is NOT correct?.

a) =SUM(A1:F5)

b) =B23/SUM(A1:B5)

c) =MAXIMUM(A1:D5)

d) =AVERAGE(A1:B5;D1:E5)


7. If we click on the button..
a) The Insert function dialog box will appear.

b) The SUM function appears directly in the cell.

c) Any of the first two options.

d) Neither of the options.

8. If we want to add the A1:B3 range.
a) The correct function would be =SUM(A1:B3)

b) The correct function would be =+(A1:B3)

c) Any of the first two options.

d) Neither of the options.

9. I we want to deduct B1 from A1:...
a) The correct function would be =DEDUCT(A1;B1).

b) The correct function would be =-(A1:B1).

c) Neither of the functions.

10. In the Insert function dialogue box, what does the lcon serve for.?
a) To show the assistant that helps to insert the selected function.

b) To show help on the operation that performs the function by selecting it and what its syntax is.

c) To put you in contact (through the internet) with Microsoft technical service to offer you more datailed and precise information on the selected function.

11. The NOW () function returns...
a) The actual system date.

b) The actual system time.

c) Both answers are correct.

d) Neither answer is correct.

12. The DAYS360() function returns...
a) The number of days from the beginning of the year till the actual date.

b) Calculates the number of days between dates.

c) Both answers are correct.

d) Neither answer is correct.

13. The TODAY() function returns...
a) The actual system date.

b) The actual system time.

c)Both answers are correct.

d) Neither answer is correct.


14. The function PROPER() returns...
a) Our name.

b) Converts the first letter to uppercase and the rest to lowercase.

c) Both answers are correct.

d) Neither answer is correct.

15. The SUM operater predates the MULTIPLY option..
a) True.

b) False.

16. How many types of references exist?.
a) 1.

b) 2.

c) 3.

d) 4.

17.The reference that Excel uses by default is...
a) The absolute reference.

b) The relative reference.

c) There is no default reference, it needs to be indicated.

18. Which of the following functions form part of the financial functions?.
a) PMT , IPMT and EXP.

b) PMT , IPMT , PPMT and COS.

c) PMT , IPMT , PPMT and PV.

d) PMT , IPMT and PI.




   

Ev. Page.
4.1

Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.