Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Excel > Unit 3 > Flashcards

Unit 3 Flashcards

1
Q

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 _____.

A

Cells, ranges, worksheets, workbooks

Clipboard, memory, temporarily

Clipboard, location

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Shortcut for cutting equals _____-__

Shortcut for pasting equals _____-__

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

A

Control X

Control V

Removed, original, pasted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Indicates, clipboard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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.

A

Copy, retype

Worksheet, worksheet, workbook, application

Part, content, contents

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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 _____.

A

Display, paste options

Text, text, formatting, formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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.

A

Paste special, results

Paste option, destinations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Paste option, control key, shortcut

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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 _____.

A

Results, posting options, apply

Formatting, selected, worksheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

Live preview, formatting, fonts, styles

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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 _____

A

Marquee, copied, clipboard

Marquee, another, location

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

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

A

Drag, drop, moving, copying

Dragging, pointer, releasing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

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

A

Dropping, pointer, destinations

Dragging, drag, drop

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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.
A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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 _____ _____.

A

Press, control, + sign, copied, control key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

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

A

Office clipboard

Office clipboard, clipboard, Microsoft office applications

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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.

A

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

17
Q

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.

A

Task pain, 24

Close, cleared, inactive, standard, copy, paste

18
Q

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.

A

Standard, Limited, recently

Arrow, bottom-right, clipboard

19
Q

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

A

Paste all, pastes, simultaneously

Clear all, clears, all

Options arrow, display options

20
Q

A formula can contain_____, _____, _____ and _____.

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

You move _____ the same way as any other _____.

A

References, values, operators, functions

Formula, determines, displayed

Formulas, data

21
Q

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.

A

Formula, several, retyping

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

22
Q

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.

A

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

23
Q

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 _____.

A

Formulas, reviews, formulas

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

24
Q

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

By _____ Excel uses _____ cell _____ in formulas.

A

References, worksheet, specifies, location

Default, relative, references

25
Q

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.

A

References, formula, references, relation

Adjusts, references, formula

26
Q

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.
A

Fill handle, pointer, + sign

Drag, adjacent

Auto fill

27
Q

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.

A

Connection, original

Connection, link, source, destination, link command

Source, linked

28
Q

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 _____ _____.
A

Destinations

Right, paste special, paste link

29
Q

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.

A

Display, results

Formula, auditing, show

Control, ‘

Print

30
Q

_____ references are the Excel _____.

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

A

Relative, default

Formula, retain, references, absolute

31
Q

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. __ _____ __

A

Change, formula, undesired, invalid, #VALUE!

32
Q

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

The _____ command _____ the most recent actions.

A

Undo, control Z

Undo, reverses

33
Q

_____ 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 __ __.

A

Absolutely, reference

Absolute,$, column letter, row #, $A$2, adjust

Cursor, reference, F4

34
Q

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

A

Row, column, range, inserted, deleted

35
Q

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 _____.
A

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

36
Q

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.

A

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

37
Q

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.

A

Specify, inserted, above
Left
Multiple, simultaneously, equal

38
Q

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
A

Cell, delete, right, shortcut

Shift, adjacent

Excel (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions