Advertisement

40 terms

Workbook

a file with one or more worksheets or spreadsheets

Worksheet

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

Cell

the intersection of a column and a row on a worksheet; the basic unit of 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

Value

a number entered in the worksheet

Fill series

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

Active Cell

The cell in the worksheet in which you can type data

Alignment

How the data is positioned within the cell either horizontally and vertically

Sum Function (AutoSum)

a built-in spreadsheet formula that adds a range of 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

Chart

A graphical representation of spreadsheet data

Cell Pointer

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

Cell Range

refers to a group of adjacent cells that are rectangular in shape, such as A4:A16.

Column

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

Delete

remove data from of document

Entry Bar

a toolbar on the excel window that shows the text or the equation assign to a cell

Fill Down

A command used to copy data to cells in a column below the original cell.

Fill Right

A command used to copy data to cells in a row to the right of the original cell.

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

Format

arranging the shape, size, type, appearance, or general makeup of a cell or document

Formula Results

The value resulting from the processing of an arithmetic equation

Formula

An equation that calculates a new value from values currently in a spreadsheet

Functions

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

Insert rows and columns

used to add a row or column in a worksheet.

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,.

Line Chart

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

Mathematical Operators

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

Max Function

A function that returns the maximum value of the values in a range.

Min Function

A function that returns the minimum value in the range.

Page Orientation

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

Portrait

The default page orientation; , page is taller than it is wide

Print Range

The pages or range of a document that you specify should be printed.

Protect Cells

The spreadsheet command that locks cells so data cannot accidentally be changed

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

Rows and Columns

The structure units of a spreadsheet matrix