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