Bis 104

Paragraph

...

Absolute Cell Reference

A cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied

Copy

A command that duplicates a selection and places it on the Clipboard

SmartArt

A designer-quality visual representation of your information that you can create by choosing from among many different layouts to effectively communicate your message or ideas.

AutoCorrect

A feature that corrects common spelling errors as you type, for example, changing teh to the

Function

A predefined formula—a formula that Excel has already built for you—that performs calculations by using specific values in a particular order.

Thesaurus

A research tool that provides a list of synonyms

Footer

A reserved area for text or graphics that displays at the bottom of each page in a document

Header

A reserved area for text or graphics that displays at the top of each page in a document

Drag and Drop

A technique by which you can move, by dragging, selected text from one location in a document to another.

Workbook

An Excel file that contains one or more worksheets

Table

An arrangement of information organized into rows and columns

Formula

An equation that performs mathematical calculations on values in a worksheet.

Relative Cell Reference

In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to

Sheet Tab

On the Office Ribbon, the name of each activity area in the Office Ribbon.

Bullet

Text symbols such as small circles or check marks that precede each item in a bulleted list.

Layout

The Access view in which you can make changes to a form or to a report while the object is open

Paste

The action of placing text or objects that have been copied or moved from one location to another location

Chart

The graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers

Alignment

The placement of text or objects relative to the left and right margins.

Worksheet

The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.

Range

Two or more selected cells on a worksheet that are adjacent or nonadjacent; because the range is treated as a single unit, you can make the same changes or combination of changes to more than one cell at a time.