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
Q

Operand

A

A number or cell reference used in a formula

25
Q

Operator

A

A symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/).

26
Q

Order of operation

A

The mathematical rules used for calculating the value of a formula.

27
Q

Pie chart

A

A chart that shows the relationship of a part to a whole.

28
Q

Range

A

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
Q

Relative cell reference

A

Cell reference that adjusts to a new location when copied or moved.

30
Q

Row

A

A horizontal group of cells in a worksheet identified by numbers

31
Q

Sort

A

To arrange a list of words or numbers in ascending or descending order.

32
Q

Spreadsheet

A

A grid of rows and columns containing numbers, text, and formulas used to perform calculations.

33
Q

Sum

A

Adds all of the numbers in a range of cells.

34
Q

Value

A

Numeric characters that can be sued in a calculation.

35
Q

What-if-analysis

A

Process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet.

36
Q

Workbook

A

A collection related worksheets

37
Q

Worksheet

A

The workspace made up of columns and rows where data is entered create an electronic spreadsheet.