Theme 5 Evaluation Test. MANIPULATING CELLS

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. Adjacent cells can not be selected.
a) True.

b) False.

2. The CAPS LOCK key is used to extend or reduce the selected range.
a) True.

b) False.

3. When we click on the identifier of a column, all the cells that contain data in this column are selected.
a) True.

b) False.


4. When you are situated in the bottom right corner of the selected range, the mouse pointer converts to a black cross which allows us to copy the range to any position.
a) True.

b) False.

5. Various cells can be selected using the keyboard.
a) True.

b) False.

6. Column A and row 1 cannot be selected at the same time.
a) True.

b) False.

7. What is the maximum amount of objects that can be copied to the clipboard.
a) 5.

b) 25.

c) There is no determined number, but it depends rather on the size of each object.

8. We can copy a range of cells to the clipboard within the same sheet with the key...
a) Ctrl.

b) Caps lock (shift).

c) Alt.

d) Ctrl+C.

9. A button exists which permits us to select the whole sheet.
a) True.

b) False.

10. When we select a range of cells, all the slected cells appear marked in a different color.
a) True.

b) False.

11. When we select a range, the CTRL and the SHIFT keys have the same use.
a) True.

b) False.

12. If we clic on cell A4 while maintaining the CTRL tab depressed...
a) Only cell A4 is selected.

b) Cell A4 is added to a previous selection.

c) Either of the first two options.

d) Neither of the options.

13. When we clic on cell D4:
a) Cell D4 is added to a previous selection.

b) The selection is extended till cell D4.

c) Neither of the options.

14. With which of the following buttons can we select the type of paste to perform?
a)

b)

c)

15. To show the clipboard in case it does not appear...
a) ... go to the Tools menu and select Clipboard.

b) ... go to the Edit menu and select Office clipboard.

c) ... go to the View menu, select the Toolbar, and activate the Clipboard option.

16. A cell can be moved to another sheet using the mouse.
a) True.

b) False.

17. The Paste operation...
a) ...leaves the information contained in the clipboard in the place where we are situated.

b) ...moves the selected information to the clipboard.

c) Neither of the options.

18. The difference between the Cut option from the Edit menu and the button on the toolbar is.
a) With the button on the toolbar we do not need to paste.

b) There is no difference, they are equal.

c) If we use the button of the toolbar to cut, we need to paste with the button on the toolbar.


19. Various cells can be moved at the same time...
a) ... only using the clipboard

b) ... using the clipboard or the mouse.

c) Various cells cannot be moved at the same time.

20. With the help of the... key we can move a range of cells to another worksheet.
a) Ctrl.

b) Caps lock (Shift).

c) Alt.

d) None of the answers




   

Ev. Page.
5.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.