Spreadsheets Flashcards Preview

Career Prep > Spreadsheets > Flashcards

Flashcards in Spreadsheets Deck (54)
Loading flashcards...
1

A blinking vertical line that indicates where the next character typed will be placed.

Insertion Point

2

A cell reference that when copied reflects the row or column it has been copied to.

Relative Cell Reference

3

An error that occurs when a formula references the cell it is stored in.

Circular Reference

4

An Excel spreadsheet file.

Workbook

5

Area near the top of the worksheet window that displays the contents of the active cell.

Formula Bar

6

Cancels data entry and restores the original contents of the cell.

Esc Key

7

Cells that are next to each other.

Adjacent cells

8

Clicking a cell to place its reference in a formula.

Pointing

9

Data displayed in rows and columns.

Spreadsheet

10

Data in the form of a calendar date.

Date

11

Data in the form of a time (i.e., 12:30 PM).

Time

12

Data required by a function to perform calculations.

Argument

13

Enters data and then selects the next cell in the column.

Enter key

14

Enters data and then selects the next cell in the direction of the arrow key.

Arrow Keys

15

Enters data and then selects the next cell in the row.

Tab Key

16

Function that adds the values in a range of cells.

SUM

17

Function that adds the values of the cells in a range and divides the result by the number of cells in the range.

AVERAGE

18

Function that changes a value by rounding it to a specific number of decimal places.

ROUND

19

Letter at the top of the worksheet used to identify individual columns.

Column Letter

20

Located near the top of the worksheet window. Displays the cell reference of the active cell.

Name Box

21

Mathematical statement used to calculate a value. A formula must always begin with an equal sign. For example, =C5+D7+E8 is a formula.

Formula

22

Numeric data that is stored in a cell that can be used in calculations.

Value

23

Performs a calculation that results in a single value. The formula =SUM(B3:B8) contains the SUM function.

Function

24

Selection of two or more cells.

Range

25

Sheets in an Excel workbook used to present data in an organized format.

Worksheet

26

Solid lines that mark off the rows and columns in a worksheet.

Gridlines

27

Text stored in a cell that cannot be used in calculations.

Label

28

The bar separating the column letters at the top of the worksheet.

Boundary

29

The column letter and row number used to identify a cell, such as B3.

Cell Reference

30

The intersection of a row and column. Each cell can store a single item of data.

Cell