MICROCOMPUTERS 2 MIDTERM TERMS

WILDCARD

a character such as the asterisk (*) used to search a field when you are uncertain of the exact value or when you want to widen the search to include more records.

LEGEND

a chart element that identifies the pattens or colors that are assigned to the categories in the chart.

EMBEDDED CHART

a chart that is inserted into the same worksheet that contains the data used to create the chart.

ONE-VARIABLE DATA TABLE

a data table that changes the value in only one cell.

TWO-VARIABLE DATA TABLE

a data table that changes the value in two cells.

SOFTEN

a feature that decreases the clarity of an image, making it look fuzzy.

BORDER

a frame or outline added to a picture or clip art.

TREND LINE

a graphic representation of trends in a data series, such as a line sloping upward to represent increased sales over a period of months.

DATA SERIES

a group of related data points.

AUTOFILTER MENU

a menu of filtering commands that displays when you click one of the filter arrows in an Excel table.

COMMENT

a note that you can attach to a letter or word on a slide or to an entire slide.

REVIEWER

a person who inserts comments into a presentation to provide feedback.

TRIGGER

a portion of text, a graphic, or a picture on a slide that, when clicked, will play an audio or video file.

TEMPLATES

a predefined layout for a group of slides saved as a .ptox file.

TITLE AND CONTENT LAYOUT SLIDE MASTER

displays a logo on every slide that uses a title and only one column of bullet items.

.pptx

file extension for a PowerPoint presentation.

.potx

file extension for a PowerPoint template.

COMPATIBILITY CHECKER

identifies features that potentially are not supported by earlier versions of PowerPoint.

HANDOUT MASTER

includes the specifications for the design of presentation handouts.

GRIDLINES

lines in the plot area of a chart that aid the eye in determining plotted values.

MARK AS FINAL

makes a presentation file read-only and discourages others From making changes to it.

CHART ELEMENTS

objects that make up a chart.

GOAL SEEK

one of Excels what -if analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell---you can find the right input when you know the results you want.

FINANCIAL FUNCTION

predefined formulas that perform common definition in the first column by writing the involve a period of time such as months or years.

CAPTION

text that helps to identify or explain a picture or a graphic.

RATE

the Excel PMT function, the term used to indicate the interest rate for a loan.

Nper

the abbreviation for the number of time periods in various Excel functions.

INTEREST

the amount charged for the use of the borrowed money.

EXTRACT AREA

the area where you place the results when copying the results of a filter to another location in the worksheet.

PLAY ANIMATIONS

the button that displays next to the slide thumbnail in the slide/outline pane that , when clicked, will play an audio file or an animation.

ARRANGE ALL

the command that tiles all open program windows on the screen.

FREEZE PANES

the command to set the column and row headings so that they remain on the screen while you scroll to other parts of the worksheet.

CHART AREA

the entire chart and all of its elements

COMPARISON OPERATORS

the equal sign(=), greater than sign(>), or less than sign(<), used singly or in combinations to compare two values.

CSV FILE ( COMMA SEPARATED VALUES)

the file type that saves an Excel file so that there is a common between each cell and a paragraph return at the end of each row.

TAB DELIMITED TEXT FILE

the file type that saves an Excel file with tabs between each cell in a row and a paragraph return at the end of each row.

CROP HANDLES

the marks on a selected picture used to remove unwanted parts of a picture.

CROP TOOL

the mouse pointer used when removing areas of a picture.

ANIMATION

the pane used for adding and removing effects.

RECOLORING

the process of applying a stylized effect or hue to a picture.

WHAT- IF ANALYSIS

the process of changing the value in cells to see how those changes affect the outcome of formulas in the worksheet.

SCALE

the range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis.

QUERY

the term that refers to asking a question of the data in a database.

CRITERIA

the term used for conditions that you specify that must be matched for the record to be included in the search results.

EMBEDDED

the term used to describe audio or video files that are saved as part of the PP presentation.

LOOP

the term used to describe playing audio or video file repeatedly until it is stopped automatically.

BRIGHTNESS

the term used to describe the amount of light or white in a picture.

MITERED

the term used used to described corners of a border that are angled to form a square.

LINE WEIGHT

the thickness of line, measured in points.

PRESENT VALUE ( Pv)

the total amount that a series of future payments is worth now.

FUTURE VALUE (Fv)

the value at the end of the time periods in an Excel function: the cash balance you want to attain after the last payment is made- usually a zero for loans.

ARGUMENTS

the values that an Excel function uses to perform calculations or operations.

SPARKLINES

tiny charts that fit within a cell and give a visual trend summary alongside your data.

NEW FROM EXISTING

contains templates that you have saved in your chapter folder.

MY TEMPLATES

contains templates that you have saved on your computer in the default template folder.

SLIDE MASTER

contains various slide master layouts.

DATA TABLE

a range of cells that shows how changing certain values in your formula affects the results of those formulas, and which makes it easy to calculate multiple versions in one operation.

CHART SHEET

a separate worksheet used to display an entire sheet.

CELL STYLES

a set of formatting characteristics that you can apply to a cell.

FIELD

a single piece of information that is stored in every record.

DATA POINT

a single value in a worksheet represented by a data marker in a chart.

TRACK

a song on a Cd

OFFICE THEME SLIDE MASTER

a specific slide master that contains the design, such as the background , that displays on all slide layouts in the presentation.

COLUMN CHART

a type of chart that shows comparisons among related data.

LINE CHART

a type of chart that uses lines to show a trend over time.

PORTABLE DOCUMENT FORMAT (PDF)

a universal file format commonly associated with Adobe Reader.

XML PAPER SPECIFICATION ( XPS)

a universal file format commonly associated with Microsoft Viewer.

RECORD

all the categories of data pertaning to one person, place, thing, event, or idea.

SMARTART GRAPHIC

an Excel feature that provides a visual representation of your information and ideas.

PMT FUNCTION

an Excel function that calculates the payment for a loan based on constant payments and at a constant interest rate.

TEXT PANE

an optional area in which you can type the text for a SmartArt graphic in a list format.

TYPE ARGUMENT

an optional argument in the PMT function that assumes that the payment will be made at the end of each time period.

DATABASE

an organized collection of facts related to a specific topic.

PRINCIPAL

another term for present value.

HYPERLINK

colored, underlined text that when clicked, takes you to another location in the worksheet, to another file, to a Web page on the Internet or on your organizations intranet.