Unit 3 Flashcards
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 _____.
Cells, ranges, worksheets, workbooks
Clipboard, memory, temporarily
Clipboard, location
Shortcut for cutting equals _____-__
Shortcut for pasting equals _____-__
Data that has been cut is not _____ from the _____ cell until it is _____ into another cell.
Control X
Control V
Removed, original, pasted
The moving, dashed boundary around the cut cell, _____ that you have cut the cells data, and it’s now on the _____.
Indicates, clipboard
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.
Copy, retype
Worksheet, worksheet, workbook, application
Part, content, contents
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 _____.
Display, paste options
Text, text, formatting, formatting
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.
Paste special, results
Paste option, destinations
You can click the _____ _____ button or press the _____ _____ to display the paste options _____ menu.
Paste option, control key, shortcut
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 _____.
Results, posting options, apply
Formatting, selected, worksheet
_____ _____ is also available for other _____ tasks, such as applying _____ and _____.
Live preview, formatting, fonts, styles
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 _____
Marquee, copied, clipboard
Marquee, another, location
_____ + _____ is a method of _____ or _____ data.
_____ = pointing to a cell, holding down the mouse button, then moving the _____ without _____ the mouse button.
Drag, drop, moving, copying
Dragging, pointer, releasing
_____ = releasing the mouse button after the _____ reaches the _____ cell.
The term _____ often refers to the whole _____ + _____ procedure.
Dropping, pointer, destinations
Dragging, drag, drop
To move contents of a cell by drag and drop method:
- Select cell with _____ to be moved
- _____ to border of the cell, the _____ changes to a _____-_____ arrow.
- Drag to _____ cell. As you drag, a cell _____ shows where the _____ will go when you _____ the mouse button.
- Release mouse button when the _____ reaches the _____ cell.
Contents
Point, pointer, four-headed
Destination, outline, data, release
Pointer, destination
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 _____ _____.
Press, control, + sign, copied, control key
_____ _____ expands the functionality of copy/paste and cut/paste.
_____ _____ can hold multiple items. All items in the _____ are available to all open _____ _____ _____.
Office clipboard
Office clipboard, clipboard, Microsoft office applications
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.
Collect, paste, combo, single, worksheet, paste, clipboard
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.
Task pain, 24
Close, cleared, inactive, standard, copy, paste
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.
Standard, Limited, recently
Arrow, bottom-right, clipboard
The buttons in the clipboard task pane:
_____ _____ = _____ multiple items _____.
_____ _____ = _____ clipboard of _____ items.
_____ _____ = opens a menu of _____ _____ for the task pane
Paste all, pastes, simultaneously
Clear all, clears, all
Options arrow, display options
A formula can contain_____, _____, _____ and _____.
The _____ are in a cell _____ the value to be _____.
You move _____ the same way as any other _____.
References, values, operators, functions
Formula, determines, displayed
Formulas, data
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.
Formula, several, retyping
Formula, location, another, first location, new location, references, formula
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.
Right mouse, short cut, short cut, short, related, element
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 _____.
Formulas, reviews, formulas
References, I just did, formula, moving, routines, original, references
A _____ identifies a cell or range of cells in a _____, it _____ a cells _____ in a worksheet.
By _____ Excel uses _____ cell _____ in formulas.
References, worksheet, specifies, location
Default, relative, references
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.
References, formula, references, relation
Adjusts, references, formula
Using auto fill to copy a formula:
- Select cell to copy.
- Point _____ _____ until _____ changes to a __ _____.
- _____ fill handle over _____ cell to which you want to copy the formula.
* use _____ options when copying.
Fill handle, pointer, + sign
Drag, adjacent
Auto fill
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.
Connection, original
Connection, link, source, destination, link command
Source, linked
Paste data with a link to source:
- Select range to be copied.
- Click copy
- Select _____ range
- _____ click and choose _____ _____, then click _____ _____.
Destinations
Right, paste special, paste link
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.
Display, results
Formula, auditing, show
Control, ‘
_____ references are the Excel _____.
When you want to copy a _____ but want to _____ it’s original cell _____ use _____ references or _____ references.
Relative, default
Formula, retain, references, absolute
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. __ _____ __
Change, formula, undesired, invalid, #VALUE!
You can undo a mistake by clicking the _____ button on the quick access tool bar or press _____+__.
The _____ command _____ the most recent actions.
Undo, control Z
Undo, reverses
_____ 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 __ __.
Absolutely, reference
Absolute,$, column letter, row #, $A$2, adjust
Cursor, reference, F4
A _____, _____ and a _____ of cells can be _____ or_____ from a workbook.
Row, column, range, inserted, deleted
Inserting cells:
- Select the _____ where you want to _____ the cells. (Do not use the fill handle while dragging).
- In the _____ group of the _____ tab, click _____ to display a menu.
- Choose _____ cells to open the _____ dialog box.
- Specify whether you want to _____ cells or _____ an entire row or column, and click OK. Shifting cells _____ is the _____.
Range, insert
Cells, home, insert
Insert, insert
Shift, insert, down, default
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.
Header, and tire
Right, display, shortcut, insert
Insert, sheet, sheet
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.
Specify, inserted, above
Left
Multiple, simultaneously, equal
Deleting cell ranges:
- Select range you want to delete.
- In _____ group click _____. You can also _____-click the selection and choose _____ from the _____ menu.
- Specify where to _____ the _____ cell. 4. Click OK
Cell, delete, right, shortcut
Shift, adjacent
