How can we help?

You can also find more resources in our Help Center.

40 terms

Final Exam Review Spring 2013

Review for Final Exam
STUDY
PLAY
Date
may be entered as static or to update each time the document is opened.
Tableader
inserted with a tab stop, may be dots or lines; it leads the eye to the next tab stop
Defaulttabstop
inserted on the ruler every .5 inches
Endnote
Used to document a source. Found on the last page of a document.
Columnformatting
vertical blocks that may be formatted differently
Header
Text that is printed at the top of each page unless formatted to print differently on the first page.
Margins
The white region around the text on a page. Margins must be the same for all pages in a document.
Pagination
How a document is divided into pages.
Tabstop
Specifies a location within a line of text; all default tab stops are removed to the left of the set tab stop.
Graphic
resized by clicking on the corner handle of the image
Linetool
press the line button, click and drag; hold the CTRL key to drag a straight line
Wordart
words turned into a graphic image
Adjacentcells
Cells that are next to each other
Cellreference
The column letter and row number that identify a cell, such as B3. These do not have to be keyed in uppercase letters
Formula
Mathematical statement used to calculate a value. A formula must always begin with an equal sign.
Columns
Vertical part of the worksheet grid identified by the letters A to Z and AA to XFD
Conditionalformatting
Formatting that is applied to a cell when a specified condition is met
Label
Text stored in a cell that cannot be used in calculations
Namebox
Displays the cell reference of the active cell. Located at the top of the worksheet
Activecell
The cell displayed with a bold border. Must be active in order to make changes in the cell.
Relativecellreference
A cell reference that reflects the row or column it has been copied to
Absolute
the type of Cell Reference that does not change when copied because a dollar sign has been placed in front of both the column letter and row number, such as $A$5.
IF
the function that is used to make a decision based on a comparison
Ascendingorder
In order from lowest to highest. Also called alphabetical order when the data is text and chronological order when the data is times or dates
SUM
Function that adds the values in a range of cells
Presentation
collection of data and information that is to be delivered to a specific audience
Thumbnail
miniature pictures of slides in a presentation
Slide
a single image composed of text, graphics, or other images.
Layout
controls how text and other objects appear on a slide
Insertionpoint
a blinking cursor which indicates where your next entry will start
cell
The intersection of a row and column
line spacing
Used to change the amount of space between lines of text in a paragraph
data series
A set of related numerical data plotted on a chart
data labels
identifies each value in the data series
category labels
Text displayed on the x-axis
legend
Corresponds to the category labels in a pie chart and series names in other chart types
PMT
Function that calculates the periodic payment for an installment loan
SUM
Function that adds the values in a range of cells
AVERAGE
Function that adds the values in a range of cells and then divides the result by the number of cells in the range.
ROUND
Changes a value by rounding it to a specific number of decimal places