Final Flashcards

(50 cards)

0
Q

The cell contains the cell pointer. There is a dark outline around the active cell

A

Active cell

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

A cell address in a formula that will not change when you copy the formula to another location

A

Absolute reference

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

Feature that temporarily performs the following calculations on a range of cells without the user having to enter a formula: AVERAGE, COUNT, MIN, MAX, or SUM

A

Auto calculate

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

A feature used to complete an entry based on previous entries made in the column containing the active cell

A

AutoComplete

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

A dot or symbol that marks an important line of information or designates items in a list

A

Bullets

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

The location of a cell in a worksheet as identified by its column letter and row number

A

Cell address

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

The intersection of a column and a row on a worksheet

A

Cell

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

Vertical series of cells in a table

A

Column

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

Personal business letter that you send with your resume when you apply for a job

A

Cover letter

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

A value, some text, or an expression that defines the type of content you want to see

A

Criterion

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

A style that displays dollar signs immediately preceding the number and includes a thousands separator

A

Currency format

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

A type of conditional formatting that creates filled background bars reflecting the relative value stored in each of the formatted cells

A

Data bars

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

The action of using a mouse to drag a selection from its original location and drop it in a new location

A

Drag–and–drop editing

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

A dot followed by three or four characters at the end of a file name, used to indicate the file type

A

File extension

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

A black box on the lower-right corner of the selected cell or range that you used to fill (copy) A series or formula

A

Fill handles

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

Hide nonmatching rows in a table or list of data according to the criterion or criteria you specify

A

Filter

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

The height of an uppercase letter in a font set

A

Font size

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

Text or graphics printed at the bottom of all pages in a document

A

Footer

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

An instruction Excel uses to calculate a result

A

Formula

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

A style of letter in which lines start flush with the left margin-that is without indents

A

Full – block

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

The name given to one of Excel’s predefined formulas

A

Function name

21
Q

Predefined formula that performs a specific calculation using the inputs you specify

22
Q

Worksheets that are selected as a unit; any action performed on this unit will affect all the worksheets in the group

23
Q

The position of text across a line in relation to the left and right margins

A

Horizontal alignment

24
The method of operations used for inserting new text within existing text in a document
Insert mode
25
Text entered to identify the type of data contained in a row or column
Label
26
The amount of white space between lines of text in a paragraph
Line spacing
27
A feature that enables you to automatically combine cells and center the contents of the original far left cell in the new cell
Merge and center
28
Combine multiple adjacent cells together to create one large cell
Merge
29
The box at the far-left end of the formula bar that you can use to create and navigate to named ranges
Name box
30
To use a function as an argument within another function
Nest
31
Not adjacent, or not next to, each other
Noncontiguous
32
Characters such as paragraph marks and tab symbols that are not printed in a document but that can be displayed on the screen
Nonprinting characters
33
A graphic, picture, chart, shape, text box, or other element that can be inserted in a document
Object
34
An identifying label assigned to a group of cells
Range name
35
A block of cells in an Excel worksheet
Range
36
A document summarizing an individual's employment experience, education, and other information a potential employer needs to know
Resume
37
To change the angle of the contents of a cell
Rotate
38
A list of sequential numbers, dates, times, or text
Series
39
Color or pattern used to fill the background of a cell
Shading
40
Small symbols around the edges of a selected object that you used to resize the object. Corner handles are around and side handles are square
Sizing handles
41
Arrange the rows in a table or list of data in a new order according to the entries in one or more columns
Sort
42
Divide one cell into multiple cells, either to create columns or horizontally to create rows
Split
43
The location on a horizontal line to which the insertion point advances when you press the tab key
Tab stop
44
The measurement of the space the insertion point advances when you press the tab key
Tab
45
Set of coordinated colors, fonts, and effects that can be applied to office 2013 documents
Theme
46
A listing of words with synonyms and antonyms
Thesaurus
47
A row you can display below a table to calculate data in the columns above using a function you choose
Total row
48
A work area for entering and calculating data made up of columns and rows separated by grid lines
Worksheet
49
A feature that causes long cell entries to appear on multiple lines within a cell
Wrap text