Chapter 1 Flashcards

1
Q

Spread Sheet

A

An electronic file that contains a grid of columns and rows used to organize related data.

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

Worksheet

A

A single spreadsheet that typically contains descriptive labels numeric values, formula and graphical representation of data.

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

Workbook

A

A collection of one or more related worksheet.

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

Cell

A

Intersection of row and column.

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

Cell Address

A

Identified by its column letter first and than row number.

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

Text

A

Combination of letters, numbers, symbols and spaces not used in calculation.

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

Autofill

A

A feature that helps complete a sequence of words or values.

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

Autocomplete

A

Feature searches for and automatically displays any other label in the same column that matches the letter typed.

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

Values

A

Numbers that represent a quantity or a measurable amount.

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

Formula

A

Combines cell references, arithmetic operations, values and functions used in calculations.

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

Order of Operation

A

Rules that control the sequence in which arithmetic operations are performed.

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

Semi-Selection

A

A process of selecting a cell or range of cells for entering cell references as you create a formula.

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

Pointing

A

Used to select cell as you build the formula.

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

Range

A

Refers to a group of adjacent or contiguous cells in a worksheet.

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

Nonadjacent Range

A

Refers to groups of cell that are not adjacent.

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

Cell Style

A

A collection of format setting to provide a consistent appearance within a worksheet.

17
Q

Alignment

A

Refers to how data are positioned in the boundaries of a cell.

18
Q

Border

A

A line that surrounds a cell or a range of cell.

19
Q

Fill Color

A

A background colour that displays behind the data in a cell so that the data stands out.

20
Q

Number Format

A

Controls how values are displayed in a cell.