Unit 3 Flashcards

0
Q

Active Cell

A

A selected worksheet cell that is ready for data entry.

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

Absolute Cell Reference

A

Cell reference that does not adjust to the new cell location when copied or moved.

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

Alignment

A

The position of data within a cell.

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

Argument

A

Value, cell reference, range, or text that acts as an operand in a function formula.

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

Ascending

A

Sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to least.

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

Auto Sum

A

A function that automatically adds the values in the cells directly above or to the left of the active cell.

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

Average

A

Returns the average (arithmetic means) of its arguments.

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

Cell

A

The space formed by the intersection of a row and a column; the basic unit of a worksheet

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

Cell Reference

A

A unique identifier for a cell which is formed by combining the cell’s column letter and row number.

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

Chart/graph

A

A graphic representation of values and their relationships: pie, line, column, bar, scattered.

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

Column

A

A vertical group of cells in a worksheet identified by letters.

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

Column chart

A

Chart that uses bars of varying height to illustrate values in a worksheet.

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

Count

A

Returns the number of cells in a range that contains numbers.

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

Descending

A

Sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest.

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

Fill

A

To copy a cell’s contents and/or formatting into an adjacent cell or range.

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

Format

A

Arranging the shape, size, type, and general makeup of a cell or group of cells.

16
Q

Formula

A

An equation that calculates a new value using values currently on a worksheet.

17
Q

Freeze

A

Keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls

18
Q

Function

A

A prewritten formula that makes it easy to perform common calculations

19
Q

Label

A

Alphanumerical text that will not be used in calculations

20
Q

Line chart

A

A chart that uses points connected by a line to illustrate values in a worksheet.

21
Q

Max

A

Returns the largest value in a set of values

22
Q

Min

A

Returns the smallest value in a set of values

23
Q

Mixed cell reference

A

A cell reference that contains both relative and absolute references.

24
Operand
A number or cell reference used in a formula
25
Operator
A symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/).
26
Order of operation
The mathematical rules used for calculating the value of a formula.
27
Pie chart
A chart that shows the relationship of a part to a whole.
28
Range
Selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon.
29
Relative cell reference
Cell reference that adjusts to a new location when copied or moved.
30
Row
A horizontal group of cells in a worksheet identified by numbers
31
Sort
To arrange a list of words or numbers in ascending or descending order.
32
Spreadsheet
A grid of rows and columns containing numbers, text, and formulas used to perform calculations.
33
Sum
Adds all of the numbers in a range of cells.
34
Value
Numeric characters that can be sued in a calculation.
35
What-if-analysis
Process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet.
36
Workbook
A collection related worksheets
37
Worksheet
The workspace made up of columns and rows where data is entered create an electronic spreadsheet.