EXCEL

Area in which you can enter data, surrounded by a heavy border

Used to enter a number as text

Button that allows you to copy values with or without formatting, or the format only

Status bar command used to obtain a total, average, or other information about numbers in a range

Automatically corrects capital letters, replaces commonly misspelled words

Properties that include system file properties

Used to make it stand out from the rest

Cancels an entry by clicking

The x-axis

Placed between the starting value and ending value when defining a range

Paste area

Contains areas where you can view and enter document properties

The details about a file

Chart that is drawn on the same worksheet as the data

Get answers to questions

Saved workbook

Small black square located in the lower right corner of active cell

A specific location on a storage medium

Defines appearance and shape of letters and numbers

Defines the color of characters

Specifies the size of characters

Indicates how the characters are emphasized

How you make a worksheet easier to read and understand

Key that selects the cell at the beginning of a row with the active cell

Changing contents in the cell

Excel inserts the character and moves all characters to the right

Includes commands that allow you to insert various objects

Blinking vertical line that indicates where next character typed will display

A word or phrase that further describes a document

The text value cell entry is positioned in the far left of a cell

Identifies each bar in a chart

Chart used to illustrate changes in data over time

Creating a single cell by combining two or more cells

Document properties

0 1 2 3 4 5 6 7 8 9 + - () , / . $ % E e

Excel overtypes the character to the right of the insertion point

Key that selects the cell down one worksheet window from the active cell

Key that selects the cell up one worksheet window from the active cell

Chart used to show the contribution of each piece of data to the whole

10/72 of an inch

A series of two or more adjacent cells in a column or row

What each adjusted cell reference is called

Document which includes a needs statement, a source of data, and a summary of calculations

The numeric value cell entry is positioned in the far right of a cell

Copy area

Unmerging a cell

Properties that include author, title, and subject

Adds all the numbers in a range of cells

Chart used to compare data from three columns in a three-dimensional manner

Any set of characters containing letters, hyphens, or spaces

A collection of cell styles and other styles that have common characteristics

To make a cell active

The y-axis

Allows data easily to be summarized and charted

With the dollar sign to the left, inserts a comma every three positions

Arithmetic operator that adds contents of cells

The values that are used with a function

Button that gives options for how to fill cells following a fill operation

Sums numbers then divides by the number of values

The width of the column will increase or decrease so the widest entry will fit

Contains the numerical value of zero

Used to display the Borders list

A formula in a cell that contains a reference back to itself

Displays two digits to left of decimal point and places a comma every three positions

Made up of two values and a relational operator

Applied formatting only when value meets specified condition

Colors like blue, green, and violet that tend to pull away from a reader

The process of finding and correcting errors

Instructs Excel to display fewer decimal places in a cell

Arithmetic operator that divides contents of cell

An area that allows you to view and edit the rules for the conditional format

Used to indicate the start a formula

Arithmetic operator that raises to the power

Used to display the Fill Color gallery

Small rectangle in lower-right corner of a cell that is used to copy formulas

Displays a dollar sign in the far left of the cell

Dollar sign that appears immediately to the left of the first digit

Common content that prints on the bottom of each page

Can be assigned to a cell and will display calculated result

Version of a worksheet that allows you to display the actual formulas instead of the values

A prewritten formula built into Excel

Common content that prints on the top of each page

Technique used to hide data that is sensitive or not relative

Lists formatting options following an insertion of cells, rows, or columns

A printout is printed such that its width is greater than its length

Are the portions of a printed page outside the main body

Displays the highest value for a range of values

Displays the lowest value for a range of values

Arithmetic operator that multiplies

Arithmetic operator that makes a number negative

Default view in Excel

Negation, percentages, exponentiations, multiplication, division, addition, subtraction

Allows you to create or modify a worksheet while viewing how it will look in printed format

Specifies how moved or pasted items should appear

Instructs Excel to display a value as a percentage by multiplying by 100 and rounding

Arithmetic operator that multiplies by 0.01

Dot on screen that contains color

Select cells and create formulas with the mouse, rather then typing a cell reference

Used to find which cells are referenced in a formula

Typically contain item analogous to items in a list

Used to check worksheet for spelling errors

Arithmetic operator that subtracts contents of cells

A predetermined set of colors, fonts, chart styles, cell styles, and fill effects

Lists error checking options following the assignment of an invalid formula to a cell

Version of a worksheet that shows the results of the formulas you have entered

Colors like red and orange that tend to reach toward a reader

Both column and row references remain the same when you copy the cell

Identifies the slices in a pie chart

A chart that resides completely on a separate sheet of paper

Copies the contents and format of a selected range, and places the copy on the Office Clipboard

Fill destination area, do not create a series

Key pressed to copy a selection and not recognize as a series

Command used to cut a cell or a range of cells

Data that determines the size of the slices in a pie

Shows the date a workbook was created or the period it represents

Button used to move the contents if a cell to the left three spaces

Command used to remove cells and data from the worksheet

Using the mouse to copy cells

Key that can be used in place of the Paste button

=

A Pie chart with one or more pieces that are offset

Fill destination area using format of source area

Used to copy a cell, range of cells, and create a series

Fill destination area with series of months

Fill destination area with series using format of source area

Fill destination area with contents without formatting

Can be used to quickly format a cell by copying a cell's format to another cell or range of cells

Excel immediately displays it with assigned format

Shows titles no matter where you scroll

To determine the value of a cell on which the formula depends

>

>=

Bar going across the middle of the screen

Assigning a value based on a logical test

Button used to move the contents if a cell to the right three spaces

Used to insert a cell or range of cells

<

<=

Cell with only one dollar sign before the column or row

Used to display a dialog box that will move a chart to a different sheet

if function within an if function

<>

Function that will display the current system date and time

Formula error messages always begin with this

Place in computers memory to collect itemsoffsettingSetting off from the rest so it stands out

Copies the newest item on the Office Clipboard to the destination area

Immediately displays when you click the Paste button

Used to show the relationship of proportion of parts to a whole

Used to ensure correctness in your formulas by checking them

When copied to another cell, the cell references are adjusted to reflect the new location

1 degree to 90 degrees on alignment sheet

A what-if analysis

Sizing entries down to fit in a cell

Provides a simple way to show trends and variations in a range of data within a single cell

Breaking the Excel window into 4 panes

Format the underlines only the characters in a cell, not the entire cell

Bar going up and down the middle of the window

To magnify the appearance of a worksheet or chart

To shrink the appearance of a worksheet or chart

On status bar, used to make entries more readable