multiple choice
which of the following is not a comparison operator < > & <>
&
what value will the MAXA function return if given the values. -.02, -.07, -.09 and NA 0 NA -.09 #name
0
when using the 1900 date systen, the date 1/1/1900 is equivilent to what number 0 1 -1 .1
1
which of the following functions should be used to insert the current date and time in a cell =TODAY() =CURRENT() =NOW() =DATE()
=NOW()
what function would most efficiently accomplish the same thing as =(b5+c5+d5+e5+f5)/5 =sum(b5:f5) =average(b5:f5) =median(b5:f5) =count(b5:f5)
=average(b5:f5)
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5? APR Periodic interest rate loan amount number of payment periods
Periodic interest rate
which functions is best utilized to preform a lookup when the lookup array and return array are in different tables within the workbook LOOKUP VLOOKUP HLOOKUP XLOOKUP
XLOOKUP
what is the keyboard shortcut to create an absolute reference f2 f3 f4 ALT
f4
When you start to type =AV, what feature displays a list of functions and defined names? function screen tip formula autocomplete insert function dialog box function arguments dialog box
formula autocomplete
If the function =XLOOKUP(H13,C4:C10,B4:B10,"Item Not Found",1,1) is used, what will happen if an exact match is not found? the function will return the value #NA the function will return to the next larger item the function will return to the next smaller item the function will preform a wildcard match
the function will return to the next smaller item