k204 excel practical questions and answers all correct

k204 excel practical questions and answers all correct COUNT( ) counts numeric data MIN( ) minimum MAX( ) maximum AVERAGE( ) average COUNTA( ) counts all non-empty cells COUNTIF( ) counts if it meets the criteria SUMIF( ) sum if it meets the criteria ROUND( ) round to however many decimal spaces INT( ) round to nearest whole integer PMT( ) calculates payment amount PPMT( ) payment amount in each period IPMT( ) interest amount in each period FV( ) future value of an investment PV( ) present value of an investment NPER( ) number of periods for an investment RATE( ) interest rate per period of an investment TODAY( ) todays date DATEDIF( ) startdate, enddate, unit in Y M or D IF( ) test, if true, if false AND( ) all criteria is true OR( ) if at least one is true MATCH( ) number indicating the position of the lookup value match array single row or single column