Unit 3

Question 1

Data can be moved between _____, _____, _____ and one _____ to another.
When you cut or copy data, Excel places it on the _____, an area of _____ that _____ stores data.
You can then paste the data from the _____ into any new _____.

Answer 1

Cells, ranges, worksheets, workbooks

Clipboard, memory, temporarily

Clipboard, location

Question 2

Shortcut for cutting equals _____-__

Shortcut for pasting equals _____-__

Data that has been cut is not _____ from the _____ cell until it is _____ into another cell.

Answer 2

Control X

Control V

Removed, original, pasted

Question 3

The moving, dashed boundary around the cut cell, _____ that you have cut the cells data, and it’s now on the _____.

Answer 3

Indicates, clipboard

Question 4

For the sake of accuracy it is best to _____ data than to _____ it.

You can copy data with in a _____, between _____ or between _____ and among other _____.

You can copy all or _____ of a cells _____, or the _____ in a range of cells.

Answer 4

Copy, retype

Worksheet, worksheet, workbook, application

Part, content, contents

Question 5

To control what is being pasted use _____ _____. Click arrow of paste button to _____ the _____ _____ menu.

You can paste, for example, only the _____, the _____ & _____ or only the _____.

Answer 5

Display, paste options

Text, text, formatting, formatting

Question 6

Point to _____ _____ icons to see a _____ of the pasted _____ in the destination cell.

When you paste the copied cell, the _____ _____ button appears next to the _____ cell.

Answer 6

Paste special, results

Paste option, destinations

Question 7

You can click the _____ _____ button or press the _____ _____ to display the paste options _____ menu.

Answer 7

Paste option, control key, shortcut

Question 8

With Live Preview, Excel 2013, enables you to see the _____ of _____ _____ before you _____ them.

With Live Preview, when you point to an option in the list, that options _____ is shown on whatever data is _____ in the _____.

Answer 8

Results, posting options, apply

Formatting, selected, worksheet

Question 9

_____ _____ is also available for other _____ tasks, such as applying _____ and _____.

Answer 9

Live preview, formatting, fonts, styles

Question 10

Live Preview
A _____ appears, indicating that you’ve _____ the cell data to the _____.

As long as the _____ remains visible, you can paste _____ copy of the text in another _____

Answer 10

Marquee, copied, clipboard

Marquee, another, location

Question 11

_____ + _____ is a method of _____ or _____ data.

_____ = pointing to a cell, holding down the mouse button, then moving the _____ without _____ the mouse button.

Answer 11

Drag, drop, moving, copying

Dragging, pointer, releasing

Question 12

_____ = releasing the mouse button after the _____ reaches the _____ cell.

The term _____ often refers to the whole _____ + _____ procedure.

Answer 12

Dropping, pointer, destinations

Dragging, drag, drop

Question 13

To move contents of a cell by drag and drop method:

1. Select cell with _____ to be moved
2. _____ to border of the cell, the _____ changes to a _____-_____ arrow.
3. Drag to _____ cell. As you drag, a cell _____ shows where the _____ will go when you _____ the mouse button.
4. Release mouse button when the _____ reaches the _____ cell.

Answer 13

Contents
Point, pointer, four-headed
Destination, outline, data, release
Pointer, destination

Question 14

To copy cells content to another cell, do the same thing as moving contents except _____ + hold _____. The pointer will display __ ____, indicating the selected data will be _____. Drag to destinations cell, release the mouse button and release the _____ _____.

Answer 14

Press, control, + sign, copied, control key

Question 15

_____ _____ expands the functionality of copy/paste and cut/paste.

_____ _____ can hold multiple items. All items in the _____ are available to all open _____ _____ _____.

Answer 15

Office clipboard

Office clipboard, clipboard, Microsoft office applications

Question 16

With the Office clipboard you can _____ and _____ to copy several items from any _____ of Microsoft office applications to a _____ location. Then switch to a new _____ and _____ items from the _____, separately or all at once.

Answer 16

Collect, paste, combo, single, worksheet, paste, clipboard

Question 17

Use clipboard _____ _____ to view items on the clipboard. You can copy up to _____ items to the clipboard.

When you _____ the clipboard _____ _____, these items are not _____, however, the clipboard becomes _____ and the _____ clipboard is used instead to _____ and _____ the items.

Answer 17

Task pain, 24

Close, cleared, inactive, standard, copy, paste

Question 18

The _____ windows clipboard is _____ to the most _____ copied/cut item.

To open the clipboard task pane, click the _____ button in the _____-_____ corner of the _____ group.

Answer 18

Standard, Limited, recently

Arrow, bottom-right, clipboard

Question 19

The buttons in the clipboard task pane:
_____ _____ = _____ multiple items _____.
_____ _____ = _____ clipboard of _____ items.
_____ _____ = opens a menu of _____ _____ for the task pane

Answer 19

Paste all, pastes, simultaneously

Clear all, clears, all

Options arrow, display options

Question 20

A formula can contain_____, _____, _____ and _____.

The _____ are in a cell _____ the value to be _____.

You move _____ the same way as any other _____.

Answer 20

References, values, operators, functions

Formula, determines, displayed

Formulas, data

Question 21

When the same _____ is needed in _____ locations, copy it to those locations, instead of _____ it in each cell.

If you move a _____ from one _____ to _____, the calculation that was performed at the _____ _____ will be performed at the _____ _____ . Any _____ made in the _____ will remain the same.

Answer 21

Formula, several, retyping

Formula, location, another, first location, new location, references, formula

Question 22

For most screen components you can use the _____ _____ button to display a _____ menu. A _____ menu provides a _____ list of commands _____ to the screen _____ you right-clicked.

Answer 22

Right mouse, short cut, short cut, short, related, element

Question 23

You can copy and paste _____ to _____ them. _____ are copied the same way as other data.

Any _____ in the formula are _____ to reflect the new location of the copied _____. This is different from _____ formulas, which _____ it’s _____ cell _____.

Answer 23

Formulas, reviews, formulas

References, I just did, formula, moving, routines, original, references

Question 24

A _____ identifies a cell or range of cells in a _____, it _____ a cells _____ in a worksheet.

By _____ Excel uses _____ cell _____ in formulas.

Answer 24

References, worksheet, specifies, location

Default, relative, references

Question 25

When Excel checks the _____ in a _____ you write, it sees those _____ in _____ to the location of the formula. Excel _____ relative cell _____ when you copy a _____ to a new location.

Answer 25

References, formula, references, relation Adjusts, references, formula

Question 26

Using auto fill to copy a formula: 1. Select cell to copy. 2. Point _____ _____ until _____ changes to a __ _____. 3. _____ fill handle over _____ cell to which you want to copy the formula. * use _____ options when copying.

Answer 26

# Fill handle, pointer, + sign Drag, adjacent Auto fill

Question 27

Once data has been copied and pasted, there is no _____ between the _____ (or source) range and the destinations cell. You may maintain a _____ or a _____ between _____ and _____ ranges by using the paste _____ _____. Then when the _____ changes so will the data in the _____ cell.

Answer 27

Connection, original Connection, link, source, destination, link command Source, linked

Question 28

Paste data with a link to source: 1. Select range to be copied. 2. Click copy 3. Select _____ range 4. _____ click and choose _____ _____, then click _____ _____.

Answer 28

Destinations Right, paste special, paste link

Question 29

You can _____ the formulas in a worksheet rather than their _____. Two ways to display formulas in the worksheet: 1. On _____ tab, in formula _____ group, click _____ formulas. 2. Press _____ + __ (accent grave) You can _____ displayed formulas.

Answer 29

Display, results Formula, auditing, show Control, ' Print

Question 30

_____ references are the Excel _____. When you want to copy a _____ but want to _____ it’s original cell _____ use _____ references or _____ references.

Answer 30

Relative, default Formula, retain, references, absolute

Question 31

If a formula refers to a cell that should not _____ when copied, the copied _____ will produce _____ results when you paste it, thus creating an _____ formula. Ex. __ _____ __

Answer 31

Change, formula, undesired, invalid, #VALUE!

Question 32

You can undo a mistake by clicking the _____ button on the quick access tool bar or press _____+__. The _____ command _____ the most recent actions.

Answer 32

Undo, control Z Undo, reverses

Question 33

_____ references won’t change cell _____ when copied. To create a _____ reference, insert a __ in front of both the _____ _____ and the _____ _____. Ex. __ __ __ __. Excel will not _____ the reference. Or, you can put the _____ at the end of the cell _____ and press __ __.

Answer 33

Absolutely, reference Absolute,$, column letter, row #, $A$2, adjust Cursor, reference, F4

Question 34

A _____, _____ and a _____ of cells can be _____ or_____ from a workbook.

Answer 34

Row, column, range, inserted, deleted

Question 35

Inserting cells: 1. Select the _____ where you want to _____ the cells. (Do not use the fill handle while dragging). 2. In the _____ group of the _____ tab, click _____ to display a menu. 3. Choose _____ cells to open the _____ dialog box. 4. Specify whether you want to _____ cells or _____ an entire row or column, and click OK. Shifting cells _____ is the _____.

Answer 35

Range, insert Cells, home, insert Insert, insert Shift, insert, down, default

Question 36

Inserting rows and columns: 1. Select row or column where you want to insert a row or column. Click _____ if you want the _____ row or column. 2. Do either of the following: A. _____-click the selected area to _____ a _____ menu, and choose _____. Or B. Click _____ and choose insert _____ rows or insert _____ columns.

Answer 36

Header, and tire Right, display, shortcut, insert Insert, sheet, sheet

Question 37

When you insert a row or a column, you don’t have to _____ where to _____ the cells. A new row is inserted _____ the selective row. A new column will be inserted to the _____ of the selected column. If you want to insert _____ rows and columns _____ select the number of rows and columns that _____ the number of rows and columns you want to insert.

Answer 37

Specify, inserted, above Left Multiple, simultaneously, equal

Question 38

Deleting cell ranges: 1. Select range you want to delete. 2. In _____ group click _____. You can also _____-click the selection and choose _____ from the _____ menu. 3. Specify where to _____ the _____ cell. 4. Click OK

Answer 38

Cell, delete, right, shortcut | Shift, adjacent