TAMU ISTM 210 Exam 2 Excel || Most Recent Exam Actual Complete Real Exam Questions With Correct Answers (Verified Answers) Already Graded A+ | Newest Exam | Just Released!!

TAMU ISTM 210 Exam 2 Excel || Most Recent Exam 2026-
2027 Actual Complete Real Exam Questions With Correct
Answers (Verified Answers) Already Graded A+ | Newest
Exam | Just Released!!




Counta( - ANSWER -count not blank cells


ave - ANSWER -average of #


Sum( - ANSWER -sum of #


function wizard - ANSWER -1. insert or select inputs for the
function 2. description of function and argument 3. function
result based on input


max( - ANSWER -largest number


Min( - ANSWER -smallest #


rate( - ANSWER -interest rate earned


Effect( - ANSWER -annual % rate for interest


NPER( - ANSWER -# of payments


PMT( - ANSWER -payment amount

, PV( - ANSWER -Current value


FV( - ANSWER -future value


Boolean logic - ANSWER -Based on true-or-false
comparisons


If( - ANSWER -flexible formulas, accepts 3 arguments


nesting in if - ANSWER -when you put another if in the false


countif( - ANSWER -# of cells that within a specific rage that
contain a specific
value


Sumif( - ANSWER -total for a set of # that match a criterion


Averageif( - ANSWER -Average for a set of # that match a
criterion


VLOOKUP - ANSWER -used when there are more than two
columns in the
array (lookup
table).


HLOOKUP - ANSWER -Looks for a value in the top row of a
table or array of
values and returns the value in the same column for a
row you specify