Spreadsheet programs. MS Excel.

1. The values 11, 12 have been entered into cells A2 and A3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell A12, the program displays the result. The value of the cell A12 will be

A. 21

B. 11

C. 12

D. 20

E. 23

2. The values 11, 12 have been entered into cells H2 and H3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell H12, the program displays the result. The value of the cell H12 will be

A. 21

B. 11

C. 12

D. 20

E. 23

3. The values 10, 11 have been entered into cells A2 and A3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell A12, the program displays the result. The value of the cell A12 will be

A. 20

B. 11

C. 12

D. 21

E. 23

4. The values 21, 22 have been entered into cells A2 and A3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell A12, the program displays the result. The value of the cell A12 will be

A. 31

B. 21

C. 12

D. 30

E. 43

5. The values 11, 12 have been entered into cells A2 and B2 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it right to cell K2, the program displays the result. The value of the cell K2 will be

A. 21

B. 11

C. 12

D. 20

E. 23

6. The values 1, 3 have been entered into cells A2 and A3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell A12, the program displays the result. The value of the cell A12 will be

A. 21

B. 11

C. 12

D. 20

E. 23

7. The values 01.01.2017, 02.01.2017 have been entered into cells A2 and A3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell A12, the program displays the result. The value of the cell A12 will be

A. 11.01.2017

B. 10.01.2017

C. 01.11.2017

D. 10.10.2017

E. 11.11.2017

8. The value Jan has been entered into cells A2. When you click and hold the left mouse button on the drag handle of the cell and drag it down to the cell A12, the program displays the result. The value of the cell A12 will be

A. Nov

B. Jan

C. Feb

D. Mar

E. Dec

9. The value Mar has been entered into cells A2. When you click and hold the left mouse button on the drag handle of the cell and drag it down to the cell A12, the program displays the result. The value of the cell A12 will be

A. Jan

B. Nov

C. Feb

D. Mar

E. Dec

10. The value Feb has been entered into cells C2. When you click and hold the left mouse button on the drag handle of the cell and drag it down to the cell C12, the program displays the result. The value of the cell C12 will be

A. Dec

B. Nov

C. Jan

D. Feb

E. Mar

11. The value Feb has been entered into cells C2. When you click and hold the left mouse button on the drag handle of the cell and drag it left to the cell F2, the program displays the result. The value of the cell F2 will be

A. May

B. Nov

C. Jan

D. Feb

E. Mar

12. The values 2, 4 have been entered into cells A2 and A3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell A12, the program displays the result. The value of the cell A12 will be

A. 22

B. 11

C. 12

D. 20

E. 23

13. The values 10, 20 have been entered into cells A2 and A3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell A12, the program displays the result. The value of the cell A12 will be

A. 110

B. 101

C. 100

D. 102

E. 99

14. The values 1and 1,5 have been entered into cells A2 and A3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell A12, the program displays the result. The value of the cell A12 will be

A. 6

B. 5,5

C. 6,5

D. 11

E. 12

15. The values 10, 9 have been entered into cells A2 and A3 respectively. When you click and hold the left mouse button on the drag handle of these two cells and drag it down to cell A12, the program displays the result. The value of the cell A12 will be

A. 0

B. 1

C. 10

D. 9

E. 8

16. The values 10, 9 and 8 have been entered into cells A2, A3 and A4 respectively. When the formula =A2+A3+A4 is keyed into cell A5, the program automatically displays the result. The value of the cell A5 will be

A. 27

B. 7

C. 0

D. 9

E. 8

17. The values 10, 9 and 2 have been entered into cells A2, A3 and A4 respectively. When the formula =SUM(A2:A4) is keyed into cell A5, the program automatically displays the result. The value of the cell A5 will be

A. 21

B. 5

C. 0

D. 9

E. 26

18. The value 10 has been entered into cells A1. When the formula =A1/2 is keyed into cell B1 and the formula =SUM(A1:B1)*2 is keyed into cell C1 , the program automatically displays the result. The value of the cell C1 will be

A. 30

B. 100

C. 10

D. 15

E. 224

19. The value 10 has been entered into cells A1. When the formula =A1*2 is keyed into cell B1 and the formula =SUM(A1:B1)/2 is keyed into cell C1 , the program automatically displays the result. The value of the cell C1 will be

A. 15

B. 30

C. 100

D. 10

E. 224

20. The value 10 has been entered into cells A1. When the formula =A1*2 is keyed into cell B1 and the formula =(A1+B1)/2 is keyed into cell C1 , the program automatically displays the result. The value of the cell C1 will be

A. 15

B. 30

C. 100

D. 10

E. 224

21. The value 10 has been entered into cells A1. When the formula =A1*2 is keyed into cell B1 and the formula =(A1-B1)/2 is keyed into cell C1 , the program automatically displays the result. The value of the cell C1 will be

A. -5

B. 5

C. 100

D. 10

E. -15

22. The value 10 has been entered into cells A1. When the formula =(-A1)*2 is keyed into cell B1 and the formula =(A1-B1)/2 is keyed into cell C1 , the program automatically displays the result. The value of the cell C1 will be

A. 15

B. 30

C. 100

D. 10

E. 224

23. The $ symbols used in the A1 cell reference tell Excel to only use the contents of that particular cell $A$1. This is known as

A. ‘Absolute Cell Referencing’.

B. ‘Total Cell Referencing’.

C. ‘Fixed Cell Referencing’.

D. ‘Complete Cell Referencing’.

E. ‘Relative Cell Referencing’.

24. Sometimes you are asked to print off the Formulae used within a spreadsheet. To do this,

A. click the Formulas tab and find the Show Formulas icon.

B. click the Insert tab and find the Show Formulas icon.

C. click the Formulas tab and find the Insert Function icon.

D. click the Formulas tab and find the Define Name icon.

E. click the Data tab and find the Show Formulas icon.

25. Sometimes you are asked to print off the Formulae used within a spreadsheet. To do this,

A. click the Formulas tab and find the Show Formulas icon.

B. click the View tab and find the Show Formulas icon.

C. click the Page Layout tab and find the Insert Function icon.

D. click the Formulas tab and find the Define Name icon.

E. click the Data tab and find the Show Formulas icon.

26. The formula =A3*C4+B1 is keyed into cell B2 then copied into cell D3. The value of the cell D3 will be

A. =C4*E5+D2;

B. =C3*E4+D1;

C. =C4*E4+$D$1;

D. =A3*C4+B1

E. =$A$3*C4+B1

27. The formula =$A$3*C4+B1 is keyed into cell B2 then copied into cell D3. The value of the cell D3 will be

A. =$A$3*E5+D2;

B. =C3*E4+D1;

C. =C4*E4+$D$1;

D. =A3*C4+B1

E. =$A$3*C4+B1

28. The formula =A3*$C$4+B1 is keyed into cell B2 then copied into cell D3. The value of the cell D3 will be

A. =C4*$C$4+D2;

B. =C3*E4+D1;

C. =C4*E4+$D$1;

D. =A3*C4+B1

E. =$A$3*C4+B1

29. The formula =A3*C4+$B$1 is keyed into cell B2 then copied into cell D3. The value of the cell D3 will be

A. =C4*E5+$B$1;

B. =C3*E4+D1;

C. =C4*E4+$D$1;

D. =A3*C4+B1

E. =$A$3*C4+B1

30. The formula =$A3*C4+B1 is keyed into cell B2 then copied into cell D3. The value of the cell D3 will be

A. =$A 4*E5+D2;

B. =C3*E4+D1;

C. =C4*E4+$D$1;

D. =A3*C4+B1

E. =$A$3*C4+B1

31. The formula =A$3*C4+B1 is keyed into cell B2 then copied into cell D3. The value of the cell D3 will be

A. =C $3*E5+D2;

B. =C3*E4+D1;

C. =C4*E4+$D$1;

D. =A3*C4+B1

E. =$A$3*C4+B1

32. The formula =A3*C4+$B1 is keyed into cell B2 then copied into cell D3. The value of the cell D3 will be

A. =C4*E5+$B 2;

B. =C3*E4+D1;

C. =C4*E4+$D$1;

D. =A3*C4+B1

E. =$A$3*C4+B1

33. The formula =A3*C4+B$1 is keyed into cell B2 then copied into cell D3. The value of the cell D3 will be

A. =C4*E5+D $1;

B. =C3*E4+D1;

C. =C4*E4+$D$1;

D. =A3*C4+B1

E. =$A$3*C4+B1

34. The use of bold on the spreadsheet helps to

A. emphasize the headings

B. correct errors

C. create a graph

D. hide information

E. create a chart

35. Which facility could be used to list the book titles in alphabetic order?

A. sort

B. find

C. search

D. Replace

E. Insert