# Like this study set? Create a free account to save it.

### Worksheet

the area for entering and calculating data made up of columns and rows separated by gridlines (light gray lines),); also called a spreadsheet

### Formula bar

as you enter data into a cell, it simultaneously appears in the formula bar, which is located above the worksheet. Formula will still be visible in this after after formula results appear in the cell

### Cell Reference

the location of a cell in a worksheet as identified by its column letter and row number, also known as the cell address or cell name

### Label

text in the first row or column of a worksheet that identifies the type of data contained there

### Fill series

a list of sequential numbers, dates, times, or text that is generated when data is copied to adjacent cells

### Average Function

sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range

### Cell Pointer

cross-shaped pointer that appears inside the outlined cell when the mouse is over the cell.

### Column

appears vertically in a worksheet and is identified by letters at the top of the worksheet window

### Find and Replace

a feature that scans a document, searches for occurrences of specific text, symbols or formatting, and allows a user to replace it with new text, symbols or formatting

### Functions

Predefined spreadsheet formulas built into the software that enable you to perform simple calculations, as well as, complex calculations easily.

### Landscape

The orientation of a page where the width is greater than the height; printing a document where it is wider than it is tall,.

### Mathematical Operators

symbols used in mathematical operations: + for addition, - for subtraction, * for multiplication, / for division, and ^ for exponentation

### Page Orientation

Refers to the position in which a page is arranged either vertically or horizontally

### Relative Cell Reference

The ability of a spreadsheet to change a cell or range reference to automatically adjust to the new location in a worksheet when the formula is copied

### Row

In a spreadsheet the row is the horizontal group of cells. Rows are named with numbers, i.e. 1,2,3.

### Sort

To arrange a list of data alphabetically (text) or numerically (numbers), in ascending or descending order

### Speadsheet

A computer application that produces worksheets arranged in columns and rows and performs mathematical calculations