-
active cell
Area in which you can enter data, surrounded by a heavy border
-
apostrophe
Used to enter a number as text
-
auto fill options
Button that allows you to copy values with or without formatting, or the format only
-
autocalculate area
Status bar command used to obtain a total, average, or other information about numbers in a range
-
AutoCorrect feature
Automatically corrects capital letters, replaces commonly misspelled words
-
automatically updated properties
Properties that include system file properties
-
bold
Used to make it stand out from the rest
-
cancel box
Cancels an entry by clicking
-
-
colon
Placed between the starting value and ending value when defining a range
-
destination area
Paste area
-
document information panel
Contains areas where you can view and enter document properties
-
document properties
The details about a file
-
embedded chart
Chart that is drawn on the same worksheet as the data
-
Excel Help
Get answers to questions
-
-
fill handle
Small black square located in the lower right corner of active cell
-
folder
A specific location on a storage medium
-
font
Defines appearance and shape of letters and numbers
-
font color
Defines the color of characters
-
font size
Specifies the size of characters
-
font style
Indicates how the characters are emphasized
-
format
How you make a worksheet easier to read and understand
-
home
Key that selects the cell at the beginning of a row with the active cell
-
in-cell editing
Changing contents in the cell
-
insert mode
Excel inserts the character and moves all characters to the right
-
insert tab
Includes commands that allow you to insert various objects
-
insertion point
Blinking vertical line that indicates where next character typed will display
-
keyword
A word or phrase that further describes a document
-
left-aligned
The text value cell entry is positioned in the far left of a cell
-
legend
Identifies each bar in a chart
-
line chart
Chart used to illustrate changes in data over time
-
merging cells
Creating a single cell by combining two or more cells
-
metadata
Document properties
-
number
0 1 2 3 4 5 6 7 8 9 + - () , / . $ % E e
-
overtype mode
Excel overtypes the character to the right of the insertion point
-
page down
Key that selects the cell down one worksheet window from the active cell
-
page up
Key that selects the cell up one worksheet window from the active cell
-
pie chart
Chart used to show the contribution of each piece of data to the whole
-
point size
10/72 of an inch
-
range
A series of two or more adjacent cells in a column or row
-
relative reference
What each adjusted cell reference is called
-
requirements document
Document which includes a needs statement, a source of data, and a summary of calculations
-
right-aligned
The numeric value cell entry is positioned in the far right of a cell
-
-
splitting a merged cell
Unmerging a cell
-
standard properties
Properties that include author, title, and subject
-
SUM function
Adds all the numbers in a range of cells
-
surface chart
Chart used to compare data from three columns in a three-dimensional manner
-
text
Any set of characters containing letters, hyphens, or spaces
-
theme
A collection of cell styles and other styles that have common characteristics
-
to select a cell
To make a cell active
-
-
worksheet
Allows data easily to be summarized and charted
-
accounting number format
With the dollar sign to the left, inserts a comma every three positions
-
Addition
Arithmetic operator that adds contents of cells
-
arguments
The values that are used with a function
-
auto fill options
Button that gives options for how to fill cells following a fill operation
-
AVERAGE function
Sums numbers then divides by the number of values
-
best fit
The width of the column will increase or decrease so the widest entry will fit
-
blank cell
Contains the numerical value of zero
-
borders button arrow
Used to display the Borders list
-
circular reference
A formula in a cell that contains a reference back to itself
-
comma style
Displays two digits to left of decimal point and places a comma every three positions
-
condition
Made up of two values and a relational operator
-
conditional formatting
Applied formatting only when value meets specified condition
-
cooler colors
Colors like blue, green, and violet that tend to pull away from a reader
-
debugging
The process of finding and correcting errors
-
decrease decimal button
Instructs Excel to display fewer decimal places in a cell
-
Division
Arithmetic operator that divides contents of cell
-
Edit the Rule Description
An area that allows you to view and edit the rules for the conditional format
-
equal sign
Used to indicate the start a formula
-
Exponentiation
Arithmetic operator that raises to the power
-
fill color button arrow
Used to display the Fill Color gallery
-
fill handle
Small rectangle in lower-right corner of a cell that is used to copy formulas
-
fixed dollar sign
Displays a dollar sign in the far left of the cell
-
floating dollar sign
Dollar sign that appears immediately to the left of the first digit
-
footer
Common content that prints on the bottom of each page
-
formula
Can be assigned to a cell and will display calculated result
-
formulas version
Version of a worksheet that allows you to display the actual formulas instead of the values
-
function
A prewritten formula built into Excel
-
header
Common content that prints on the top of each page
-
hiding cells
Technique used to hide data that is sensitive or not relative
-
insert options
Lists formatting options following an insertion of cells, rows, or columns
-
landscape orientation
A printout is printed such that its width is greater than its length
-
margins
Are the portions of a printed page outside the main body
-
MAX function
Displays the highest value for a range of values
-
MIN Function
Displays the lowest value for a range of values
-
Multiplication
Arithmetic operator that multiplies
-
Negation
Arithmetic operator that makes a number negative
-
normal view
Default view in Excel
-
order of operation
Negation, percentages, exponentiations, multiplication, division, addition, subtraction
-
page layout view
Allows you to create or modify a worksheet while viewing how it will look in printed format
-
paste options
Specifies how moved or pasted items should appear
-
percent style button
Instructs Excel to display a value as a percentage by multiplying by 100 and rounding
-
Percentage
Arithmetic operator that multiplies by 0.01
-
pixel
Dot on screen that contains color
-
point mode
Select cells and create formulas with the mouse, rather then typing a cell reference
-
range finder
Used to find which cells are referenced in a formula
-
rows
Typically contain item analogous to items in a list
-
spell checker
Used to check worksheet for spelling errors
-
Subtraction
Arithmetic operator that subtracts contents of cells
-
theme
A predetermined set of colors, fonts, chart styles, cell styles, and fill effects
-
trace error button
Lists error checking options following the assignment of an invalid formula to a cell
-
values version
Version of a worksheet that shows the results of the formulas you have entered
-
warmer colors
Colors like red and orange that tend to reach toward a reader
-
absolute cell reference
Both column and row references remain the same when you copy the cell
-
category names
Identifies the slices in a pie chart
-
chart sheet
A chart that resides completely on a separate sheet of paper
-
Copy button
Copies the contents and format of a selected range, and places the copy on the Office Clipboard
-
copy cells
Fill destination area, do not create a series
-
ctrl
Key pressed to copy a selection and not recognize as a series
-
cut command
Command used to cut a cell or a range of cells
-
data series
Data that determines the size of the slices in a pie
-
date stamp
Shows the date a workbook was created or the period it represents
-
decrease indent
Button used to move the contents if a cell to the left three spaces
-
delete
Command used to remove cells and data from the worksheet
-
drag and drop
Using the mouse to copy cells
-
enter
Key that can be used in place of the Paste button
-
-
exploded pie chart
A Pie chart with one or more pieces that are offset
-
fill formatting only
Fill destination area using format of source area
-
fill handle
Used to copy a cell, range of cells, and create a series
-
fill months
Fill destination area with series of months
-
fill series
Fill destination area with series using format of source area
-
fill without formatting
Fill destination area with contents without formatting
-
format painter
Can be used to quickly format a cell by copying a cell's format to another cell or range of cells
-
format symbol
Excel immediately displays it with assigned format
-
freeze the titles
Shows titles no matter where you scroll
-
goal seeking
To determine the value of a cell on which the formula depends
-
-
greater than or equal to
>=
-
horizontal split bar
Bar going across the middle of the screen
-
if function
Assigning a value based on a logical test
-
increase indent
Button used to move the contents if a cell to the right three spaces
-
INSERT cells command
Used to insert a cell or range of cells
-
-
-
mixed cell reference
Cell with only one dollar sign before the column or row
-
move chart button
Used to display a dialog box that will move a chart to a different sheet
-
nested if
if function within an if function
-
-
NOW function
Function that will display the current system date and time
-
number sign
Formula error messages always begin with this
-
Office Clipboard
Place in computers memory to collect itemsoffsettingSetting off from the rest so it stands out
-
Paste button
Copies the newest item on the Office Clipboard to the destination area
-
paste options button
Immediately displays when you click the Paste button
-
pie chart
Used to show the relationship of proportion of parts to a whole
-
range finder
Used to ensure correctness in your formulas by checking them
-
relative cell reference
When copied to another cell, the cell references are adjusted to reflect the new location
-
rotating text
1 degree to 90 degrees on alignment sheet
-
sensitivity analysis
A what-if analysis
-
shrink to fit
Sizing entries down to fit in a cell
-
sparkline chart
Provides a simple way to show trends and variations in a range of data within a single cell
-
splitting
Breaking the Excel window into 4 panes
-
underline
Format the underlines only the characters in a cell, not the entire cell
-
vertical split bar
Bar going up and down the middle of the window
-
zoom in
To magnify the appearance of a worksheet or chart
-
zoom out
To shrink the appearance of a worksheet or chart
-
zoom slider
On status bar, used to make entries more readable
|
|