facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Excel Copying and Pasting Test

Free Online Microsoft Excel Tests
Excel 2010 - Entering Data

* Using the Fill Handle
* Drag and Drop
* Undo and Redo
* Entering Data

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Excel Copying and Pasting Test

1) Which of the following represents the first action you should perform in order to copy and paste text or numbers in Excel?
a) Select the cell or cells that contain the content you wish to copy.
b) Select the cell or cells where you wish to insert the copied content.
c) Go to the Clipboard group on the Ribbon and press the Copy button to initialize the copy and paste function.
d) Press the Paste button to initialize the copy and paste function.

2) Which of the following is NOT a paste option in Excel?
a) Paste values – pastes the values of the copied cells only.
b) Keep source formatting – pastes the copied cells in the same format as what the originals are formatted in.
c) Paste zeros – replaces copied text with zeros containing the same number of decimals as the originals.
d) Paste link – pastes a link to the cell containing the original value.

3) What does the fill handle allow you to do?
a) Fill empty cells with grey shading to indicate they are not in use.
b) Complete sentences, words and numbers in cells.
c) Move the contents of a cell by dragging it to a new position, upwards or downwards.
d) Copy the contents of a cell by dragging the crosshair downwards, to the left, right or upwards.

4) The shortcut key combination for cutting and pasting data in a cell is:
a) Control + X to cut and then control + V to paste.
b) Control + V to cut and then control + C to paste.
c) Control + C to cut and then control + P to paste.
d) Control + X to cut and then control + XX to paste.

Question 5 - Excel Tests
            Entering Data - Copying and Pasting Test


5) Study the two icons circled in orange above.  Which of the following best describes their function?

a) Go to previous selection, go to next selection.
b) Undo previous actions, redo previous action.
c) Go back to previous column, move forwards to the next column.
d) Undo one action, undo many actions at once.


Question 6 - Excel Tests
            Entering Data - Copying and Pasting Test

6)Which action did you not perform if the Paste button is greyed out and you cannot press it - as pictured in the image above?

a) It is not possible to copy and paste the numbers or text you wish to perform this function for.
b) You have not selected the cells where you wish to paste the content.
c) You have selected too many cells to copy and paste and need to select one cell at a time.
d) You have not copied anything or you have pressed the Escape key before pasting.

7) Select the correct sequence for cutting and pasting the contents of a cell or cells:
a) Select the content you wish to cut, move the cursor to where you wish to paste it and press the Paste button.
b) Press the Paste button, select the Cut option and move your cursor to where you wish to paste the content.
c) Press the Cut button, select the cells you wish to cut, press the Paste button.
d) Select the content you wish to cut, press the Cut button, move to where you wish to paste the content, press the Paste button.

Question 8 - Excel Tests
            Entering Data - Copying and Pasting Test

8) Study the image above.  What will happen if you hover your mouse button over the tiny square circled in orange in the image, you press and hold down your left mouse button whilst dragging downwards?

a) The word "Item:" will be copied down into all the cells you drag your mouse through.
b) The word "Item:" will be moved down into the cell to which you drag your mouse.
c) You will change the size of the cell making it bigger.
d) The word "Item:" will be copied.  You then need to move your mouse to where you wish to paste the content and press the Paste button.

9) How can you review a list of your last actions before undoing them or redoing them?
a) Keep pressing undo until you've seen all the actions you can undo and then press redo again.
b) Click the File button and select Recent.  This will display a list of your recent actions.
c) Press the down pointing arrow located next to the Undo and Redo buttons to view a list of previous actions.
d) Press the dialogue box launcher arrow in the right-hand corner of the Clipboard group to view a list of previous actions.

10) If I copy cells that contain formulas, but I want to paste the numbers only and not the formulas – how can I do this?
a) Use the Paste Option to keep the source formatting.
b) Use the Paste Option to paste values only.
c) Paste the cells and immediately delete any formulas the cell contains.
d) It is not possible to paste a cell without the formula.