CQS CH 4 and 5 Quiz Terms

wildcard

a character, for example, the asterisk or question mark, 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

freeze panes

a command that enables you to select one or more rows or columns and freeze them into place; the locked rows and columns become separate panes

find

a command that fins and selects specific text or formatting

go to

a command that moves to a specific cell or range of cells that you specify

go to special

a command that moves to cells that have special characteristics, for example, to cells that are blank or to cells that contain constants, as opposed to formulas

one-variable data table

a data table that changed the value in only one cell

two-variable data table

a data table that changes the values in two cells

table array

a defined range of cells, arranged in a column or a row, used in a VLOOKUP or HLOOKUP function

cell styles

a defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading

sort dialog box

a dialog box in which you can sort data based on several criteria at once, and which enables a sort by more than one column or row

autofilter menu

a drop-down menu from which you can filter a column by a list of values, by a format, or by criteria

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

same as present value

comparison operators

symbols that evaluate each value to determine if it is the same (=), greater than, less than, or in between a range of values as specified by the criteria

hyperlink

text or graphics that, when clicked, take you to another location in the worksheet, to another file, or to Web page on the internet or on your organization's intranet

Nper

the abbreviation for number of time periods in various excel functions

interest

the amount charged for the use of borrowed money

active area

the area of the worksheet that contains data or has contained data-it does not include any empty cells that have not been used in the worksheet

split

the command that enables you to view separate parts of the same worksheet on your screen; splits the window into multiple resizable panes to view distant parts of the worksheet at the same time

arrange all

the command that tiles all open program windows on the screen

subtotal command

the command that totals several rows of related data together by automatically inserting subtotals and totals for the selected cells

and comparison operator

the comparison operator that requires each and every one of the comparison criteria to be true

or comparison operator

the comparison operator that requires only one of the two comparison criteria that you specify to be true

.xlsx file name extension

the default file format used by excel 2010

scaling

the group of commands by which you can reduce the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify

extract area

the location to which you copy records when extracting filtered rows

scope

the location within which a defined name is recognized without qualification-usually either to a specific worksheet or to the entire workbook

sort

the process of arranging data in a specific order based on the value in each field

what-if analysis

the process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet

extracting

the process of pulling out multiple sets of data for comparison purposes

detail data

the subtotaled rows that are totaled and summarized; typically adjacent to and either above or to the left of the summary data

additive

the term that describes the behavior of a filter when each additional filter that you apply is based on the current filter, and which further reduces the number of records displayed

ascending

the term that refers to the arrangement of text that is sorted alphabetically from A to Z, numbers sorted from lowest to highest, or dates and times sorted from earliest to latest

descending

the term that refers to the arrangement of text that is sorted alphabetically from Z-A, numbers sorted from highest to lowest, or dates and times sorted from latest to earliest

present value (Pv)

the total amount that a series of future payments is worth now; also known as principal

compound critera

the use of two or more criteria on the same row-all conditions must be met for the records to be included in the results

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 payments is made-usually zero for loans

arguments

the values excel uses to perform calculations or operations

PMT function

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

custom list

a sort order you can define

list

1. A series of rows that contain related data that you can group by adding subtotals 2. A category of SmartArt graphics used to show non-sequential information

extract

1. To decompress, or pull out, files from a compressed form. 2. The location to which you copy the records is the extract area, and is commonly placed below the table of data. Using this technique you can extract- pull out- multiple sets of data for comparison projects

PDF (Portable Document Format)

a file format that creates an image that preserves the look of your file, but that cannot be easily changed; a popular format for sending documents electronically, because the document will display on most computers

tab delimited text file

a file type in which tabs separate cells; this type of file can be readily exchanged with various database programs

CSV (comma separated values) file

a file type in which the cells of each row are separated by commas; also referred to as a comma delimited file

XPS (XML Paper Specification)

a file type that provides an accurate visual representation of a document across applications and platforms

comma delimited file

a file type that saves the contents of the cells by placing commas between them and an end-of paragraph mark at the end of each row; also referred to as CSV

text file

a file type that separates the cells of each row with tab characters

advanced filter

a filter that can specify three or more criteria for a particular column, apply complex criteria to two or more columns, or specify computed area

compound filter

a filter that uses more than one condition-and one that uses comparison operators

custom filter

a filter with which you can apply complex criteria to a single column

lookup functions

a group of excel functions that look up a value in a defined range or cells located in another part of the workbook to find a corresponding value

HTML (Hypertext Market Language)

a language Web browsers can interpret when you save a worksheet as a Web page

validation list

a list of values that are acceptable for a group of cells; only values on the list are valid and any value not on the list considered invalid

panes

a portion of a worksheet window bounded by and separated from other portions by vertical and horizontal bars

theme

a predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied to your entire document or to specific items

filtering

a process in which only the rows that meet the criteria display; rows that do not meet the criteria are hidden

query

a process of restricting records through the use of criteria conditions that will display records that will answer a question about the data

data table

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

field

a specific type of data such as name, employee number, or social security number that is stored in columns

data validation

a technique by which you can control the type of data or the values that are entered into a cell by limiting the acceptable values to a defined list

major sort

a term used to refer to the first sort level in the sort dialog box

name

a word or string of characters in excel that represents a cell, range of cells, a formula, or a constant value; also referred to as a defined name

defined name

a word or string of characters in excel that represents a cell, range of cells, a formula, or a constant value; also referred to as simply a name

record

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

criteria range

an area on your worksheet where you define the criteria for the filter, and which indicates how the displayed records are filtered

HLOOKUP

an excel function that looks up values that are displayed horizontally in a row

VLOOKUP

an excel function that looks up values that are displayed vertically in a comlumn

criteria

conditions you specify in a logical function

rate

in excel PMT function, the term used to indicate the interest rate for a loan

goal seek

one of excel's what-if analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell-fine the right input when you know the result you want

financial functions

pre-built formulas that perform common business calculations such as calculating a loan payment on a vehicle or calculating how much to save each month to buy something; commonly involve a period of time such as months or years