Name: Score:
72 Multiple choice questions
Term 1 of 72
DMIN
sums the values of cells in the field that meet the criteria
displays the smallest value in the field that meets the criteria
counts cells with values in the field (column) that meet the criteria
total number of payments over the life of the transaction
Definition 2 of 72
picture of a full or partial computer screen inserted as an object in a worksheet
database
error alert
hyperlink
screenshot
Definition 3 of 72
object created in VBA programming code for display in a workbook
userform
DAVERAGE
hyperlink
smart art
,Definition 4 of 72
interest rate for the time period
DMIN
rate
alt text
link
Term 5 of 72
mean absolute deviation (MAD)
summarizes the data and displays a result on the consolidated sheet
calculation that uses two excel functions, ABS and AVERAGE
application that runs in a window separate from excel
a programming language foe enhanced commands and features in excel
Term 6 of 72
DMAX
counts cells in the field that are not empty that meet the criteria
argument is the amount saved or invested each period
displays the smallest value in the field that meets the criteria
displays the largest value in the field that meets the criteria
, Term 7 of 72
nested function
function within a function
a choice in the record macro dialog box
function, service, or action for an oject
simple subtraction formula
Term 8 of 72
mark as final
function within a function
to set a read-only file property
payments or receipts
rules applied to data as it is entered
Definition 9 of 72
argument is the amount saved or invested each period
nper
pmt
button
.xltm
72 Multiple choice questions
Term 1 of 72
DMIN
sums the values of cells in the field that meet the criteria
displays the smallest value in the field that meets the criteria
counts cells with values in the field (column) that meet the criteria
total number of payments over the life of the transaction
Definition 2 of 72
picture of a full or partial computer screen inserted as an object in a worksheet
database
error alert
hyperlink
screenshot
Definition 3 of 72
object created in VBA programming code for display in a workbook
userform
DAVERAGE
hyperlink
smart art
,Definition 4 of 72
interest rate for the time period
DMIN
rate
alt text
link
Term 5 of 72
mean absolute deviation (MAD)
summarizes the data and displays a result on the consolidated sheet
calculation that uses two excel functions, ABS and AVERAGE
application that runs in a window separate from excel
a programming language foe enhanced commands and features in excel
Term 6 of 72
DMAX
counts cells in the field that are not empty that meet the criteria
argument is the amount saved or invested each period
displays the smallest value in the field that meets the criteria
displays the largest value in the field that meets the criteria
, Term 7 of 72
nested function
function within a function
a choice in the record macro dialog box
function, service, or action for an oject
simple subtraction formula
Term 8 of 72
mark as final
function within a function
to set a read-only file property
payments or receipts
rules applied to data as it is entered
Definition 9 of 72
argument is the amount saved or invested each period
nper
pmt
button
.xltm
