# Computer Terminology

### 20 terms by puppychow89

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

### F2

The function key used to edit the contents in a cell.

### Worksheet

In Excel, a page composed of columns and rows that create cells at their intersection, you type data and formulas into cells

### Formula Bar

This bar shows the formula, or text in a cell.

### Calculator operator

symbols that indicate what type of calculation to perform on the cells, ranges, or values.

### Reference operator

Mathematical calculations which enable you to use ranges in calculations.

### Formula

A set of instructions used to perform one or more numeric calculations, such as adding, multiplying, or averaging, on values or cells.

### Complex formula

Is one that uses more than one arithmetic operator.

### Function ( related to creating a formula)

A special, predefined formula that provides a short cut for a commonly used calculation, for example, SUM(for calculating a total) or COUNT(for counting items in a list).

### Absolute reference

a reference that does not change when you copy the formula (requires a \$ sign in front of both the column letter and the row number of the cell address).

### Workbook

A collection of related worksheets contained within a single Excel file

computer program that performs calculations and presents numeric data.

the location of a cell, expressed by cell coordinates

### Cell

The intersection of a column and row in a worksheet, datasheet, or table.

### Name Box

most are of the formula bar that shows the cell reference or name of the active cell.

### Label

Descriptive text or other information that identifies spreadsheet rows, columns, or chart data, but are not included in calculations.

### Formula Prefix

used to start a formula, such as an equal sign

### *

The symbol that is used for multiplying.

### /

The symbol that is used for division.

### +

The symbol that is used for adding.

### -

The symbol that is used for subtraction.

Example: