Excel final

A function that adds a group of values, and then divides the result by the number of values in a group.

AVERAGE

When creating a VLOOKUP or an HLOOKUP function, the one requirement is that the data in the table array is sorted in:

Ascending order

An Excel function that loks up values that are displayed vertically in a column is the

VLOOKUP function

A cell surrounded by a black border and ready to receive data is the:

active cell

The operator that requires each and eery one of the comparison criteria that you specify must be true is the:

and operator

The intersection of a column and a row.

cell

Another name for a cell reference

cell address

When you use a defined name in a formula, the result is the same as if you typed a:

cell reference

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

criteria

The command to find and select specific text, formatting, or type of information within a workbook quickly is:

find

An equation that performs mathematical calculations on values in a worksheet.

formula

The amount charged for the use of borrowed money

interest

A word or string of characers that represents a cell, a range of cells, a formula, or a constant value is a defined:

name

A constant value consisting of only numbers.

number value

A chart that shows the relationship of each part to a whole.

pie

A value that originates in a worksheet cell and that is represented in a chart by a data marker is a data

point

The total amount that a series of future payments is worth now

present value

Another term or present value

principal

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

record

In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to.

relative cell reference

The page formatting that reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify is:

scaling

The labels along the lower border of the workbook window that identify each worksheet are the:

sheet tab

To organize data in a particular order is to:

sort

Another name for a worksheet

spreadsheet

A worksheet where totals from other worksheets are displayed and summarized is a:

summary sheet

A series of rows and columns with related data that is managed independently from toher data is a:

table

When a cell containing data is active, anything you type will

take the place of the existing data

A predesigned set of colors, fonts, lines, and fill effects that look good together is a:

theme

The future value at the end of a loan is typically:

zero

What will happen if you press Ctrl + ` (grave accent)?

The worksheet will display formulas instead of results

A single piece of information that is stored in every record

field

The type of cell reference that refers to cells by their fixed position in a worksheet is:

absolute

The feature that generates and extends values into adjacent cells based on the values of selected cells.

auto fill

A chart type that displays trends over time is a __ chart.

bar

The intersection of a column and a row

cell

The graphic representation of data in a worksheet

chart

A format that changes the appearance of cell based on a condition

conditional format

Text or numbers in a cell that are not a formula.

constant value

Conditions that you specify in a logical function

criteria

Information such as numbers, text, dates or times of day that you type into a cell.

data

An organized collection of facts related to a specific topic

database

Numbers sorted from highest to lowest are sorted in:

descending order

A predefined formula that performs calculations by using specific values in a particular order or structure.

function

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

what-if-analysis

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

what-if-analysis

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.

wildcard

An Excel file that contains one or more worksheets

workbook

An Excel workbook consists of multiple "pages" represented by tabs at the bottom of the Excel window. These are called

worksheets or sheets

Loans are typically made for a period of

years

If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell D3?

The formula will change to =SUM(A3:C3).

A vertical group of cells in a worksheet.

column

A horizontal group of cells in a worksheet.

row

A function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false.

IF

A function that determines the largest value in a range

MAX

A function that finds the middle value that has as many values above it in the group as are below it.

MEDIAN

A function that determines the smallest value in a range

MIN

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

PMT function

A predefined formula that adds all the numbers in a selected range

SUM

The process of arranging data in a specific order based on the value in each field is called.

sorting

To insert a new row in a worksheet, select __________, and then click the Insert button.

the row below where the row is to be inserted