Brainscape's Knowledge GenomeTM

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


See full index

Micro Comp Final > Final > Flashcards

Final Flashcards

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

A

Function

22
Q

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

A

Grouping

23
Q

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

A

Horizontal alignment

24
Q

The method of operations used for inserting new text within existing text in a document

A

Insert mode

25
Q

Text entered to identify the type of data contained in a row or column

A

Label

26
Q

The amount of white space between lines of text in a paragraph

A

Line spacing

27
Q

A feature that enables you to automatically combine cells and center the contents of the original far left cell in the new cell

A

Merge and center

28
Q

Combine multiple adjacent cells together to create one large cell

A

Merge

29
Q

The box at the far-left end of the formula bar that you can use to create and navigate to named ranges

A

Name box

30
Q

To use a function as an argument within another function

A

Nest

31
Q

Not adjacent, or not next to, each other

A

Noncontiguous

32
Q

Characters such as paragraph marks and tab symbols that are not printed in a document but that can be displayed on the screen

A

Nonprinting characters

33
Q

A graphic, picture, chart, shape, text box, or other element that can be inserted in a document

A

Object

34
Q

An identifying label assigned to a group of cells

A

Range name

35
Q

A block of cells in an Excel worksheet

A

Range

36
Q

A document summarizing an individual’s employment experience, education, and other information a potential employer needs to know

A

Resume

37
Q

To change the angle of the contents of a cell

A

Rotate

38
Q

A list of sequential numbers, dates, times, or text

A

Series

39
Q

Color or pattern used to fill the background of a cell

A

Shading

40
Q

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

A

Sizing handles

41
Q

Arrange the rows in a table or list of data in a new order according to the entries in one or more columns

A

Sort

42
Q

Divide one cell into multiple cells, either to create columns or horizontally to create rows

A

Split

43
Q

The location on a horizontal line to which the insertion point advances when you press the tab key

A

Tab stop

44
Q

The measurement of the space the insertion point advances when you press the tab key

A

Tab

45
Q

Set of coordinated colors, fonts, and effects that can be applied to office 2013 documents

A

Theme

46
Q

A listing of words with synonyms and antonyms

A

Thesaurus

47
Q

A row you can display below a table to calculate data in the columns above using a function you choose

A

Total row

48
Q

A work area for entering and calculating data made up of columns and rows separated by grid lines

A

Worksheet

49
Q

A feature that causes long cell entries to appear on multiple lines within a cell

A

Wrap text

Micro Comp Final (1 decks)

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