Final Exam Review Spring 2013

40 terms by cmask

Create a new folder

Advertisement Upgrade to remove ads

Review for Final Exam

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set