47 terms

Excel Chapter 1

Use this to practice learning the vocabulary terms for Microsoft Office Excel Chapter 1.
STUDY
PLAY

Terms in this set (...)

autocalculate area
Located on the middle of the status bar and cal be used in place of a calculator.
text
Any set of characters containing a letter, hyphen, or space.
enter box
Completes the cell entry when clicked.
cancel box
Completely cancels the entry of a cell.
autocorrect feature
Corrects common mistakes when you complete a text entry in a cell.
sum function
Provides a convenient means to accomplish addition of numbers.
range
A series of two or more adjacent cells in a column or row or a rectangular group of cells.
copy area (source)
The cell being copied.
destination area (paste)
The range of cells receiving the copy.
relative reference
Each adjusted cell reference.
fill handle
The easiest way to copy from one cell formula to another by locating the small black square located in the lower right corner of the heavy border around the active cell.
format
To emphasize certain entries on a worksheet to be easier to read and look more professional.
font
In Excel, defines appearance and shape of the letters, numbers, and special characters. The default is set to Calibri, black, 11 points.
font size
Specifies the size of characters on the screen.
point size
How a font size is grouped by a measurement system. Each one is 1/72 of an inch in height.
font style
Indicates how characters are formatted, including bold, italics, regular, or underlined.
bold
An entry in a cell to emphasize or make it stand out from the rest of the worksheet.
splitting a merged cell
An alternative to merging cells by clicking the Merge & Center button within a merged cell.
embedded chart
The 3-D column chart that is drawn on the same worksheet as the data.
y-axis
The scale along the vertical axis of the chart on the basis of the values in the worksheet.
x-axis
Entries in the topmost row of the range as the title for the horizontal axis.
legend
Small box to the right of the column chart that identifies each bar in the chart.
hard copy/printout
A printed version of the worksheet.
in-cell editing
To edit the contents of a cell by double clicking in the cell and using the insertion point to make changes.
insret mode
As you type a character, Excel inserts the character and moves all the characters to the right of the typed character by one position to the right.
over-type mode
Replacing characters to the right of the insertion point as you type.
requirement document
Includes a needs statement, source of data, summary of calculations, and any other special requirements for the worksheet, such as charting and Web support.
to select a cell
To make a cell active by using the mouse to move the block plus sign mouse pointer to the cell and then click.
number
In Excel, can contain only the following characters: 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e. Excel interprets any other entry as text.
font color
Defines the color of the characters, including 60 different choices from the color palette.
theme
A collection of cell styles and other styles that have common characteristics, such as color scheme and font type. The default is Office.
merging cells
Involves creating a single cell by combining two or more selected cells.
snaps
A way to align the edge of the chart area to the worksheet gridlines by holding the ALT key and dragging the sizing handles.
document properties
A way to help organize and identify your files and shows the details about a file.
metadata
Another word for document properties and can include such information as project author, title, or subject.
keywords
Words or phrases that further describe the document. Example: class name or worksheet topic.
Standard properties
One of the 5 types of document properties that includes author, title, and subject.
automatically updated properties
One of the 5 types of document properties that includes a file system such as date you create or change a file, statistics, and file size.
document information panel
Contains areas where you can view and enter document properties.
edit mode
When there is an error, this displays the active cell entry in the formula bar and a flashing insertion point in the active cell.
category axis
Also known as the x-axis or the horizontal axis.
green computing
Reducing the environmental waste generated when using a computer.
marquee
A moving border that surrounds a range of cells.
paste area
Another name for destination area that receives the copied information.
save
A name for storing a document permanently to one or a variety of storage medium(s).
source area
Another name for the copy area that copies information.
value axis
Also known as the y-axis or the vertical axis.