This provides the users with the opportunity to get an initial picture about various MS-Excel Functions. You will find many questions, accompanied by their video-solutions about Microsoft Excel functions. Watching the videosolutions will allow you to get a good idea concerning the skills that you have and assess your level. The videosolutions are classified into categories so as to let you focus wherever you believe there is some skill shortage. This is how there is almost no time wasted in repe
ating the parts that you are already familiar with. The full version is known as TEST4U and constitutes a complete self-study, interactive guide, available since 2003, with more than 700.000 satisfied users. The candidates can access the full training package in order to be able to respond successfully to Certification Examinations not only for MS-Excel, but also for MS-Word, MS-PowerPoint, MS-Access, Internet & Windows for the Basic or the Advanced level of Microsoft-Certiport Exams, ECDL-ICDL Exams, e.tc. TEST4U is available for PCs only, because it requires the existence of the installed applications of the respective MS-Office suite in order to cooperate adequately. We encourage you to test your skills at the TEST4U Demo at https://www.test4u.eu/en/download-demo, in order to practice and prepare for the Exams.Functions included: Error SolvingVALUE, ISERROR, IFERROR, ISFORMULA, ISTEXT, ISBLANK, ISERR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, FORMULATEXTText functions FIND, EXACT, SEARCH, REPLACE, SUBSTITUTE, TEXT, CHAR, T(), REPT, PROPER, UPPER, LOWER, CONCATENATE, LEFT, MID, TRIM, RIGHTMathematical FunctionsABS, CEILING, EXP, FLOOR, INT, LN, MOD, PI, ROUND, PI,MROUND, PRODUCT, RAND, RANDBETWEEN, ROUND, ROUNDDOWN, ROUNDUP, SQRT, ABS, SUBTOTAL, SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQLogical functionsAND, IF, OR, IF, NOTDate and Time functionsDATE, DATEDIF, TODAY, HIDDEN, DATEVALUE, DAY, DAY, MONTH, YEAR, DAYS, DATEDIF, NETWORKDAYS, EDATE, EOMONTH, NETWORKDAYS, NOW, TIMEVALUE, TODAY, WEEKDAY, WORKDAY, WORKDAY.INTLLookup functionsCELL, CHOOSE, HLOOKUP, INDEX, INDEX, MATCH,, INDIRECT, ISREF, INDIRECT, LOOKUP, MATCH, SUM, OFFSET, VLOOKUPFinancial FunctionsACCRINT, ACCRINTM, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMPRINC,CUMIPMT, DB, DDB, DISC, DOLLARDE, DOLLARFR, DURATION, EOQ, FV, INTRATE, IPMT, IRR, LOGNORM.DIST,LOGNORM.INV, MDURATION, MIRR, NPER, NPV, PMT, PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RAND, NORM.INV, RATE, RECEIVED, SLN, SLOPE,INTERCEPT, STDEV.S, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, VDB, WEIBULL.DIST, XIRR, XNPV, YIELD, YIELDDISC, YIELDMATStatistical functionsAVERAGE, AVERAGEIF, AVERAGEIFS, BINOM.DIST, BINOM.INV, BINOM.INV, RAND, CORREL, CORRELATION, COEFFICIENT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, COVAR, COVARIANCE, COVARIANCE.S, COVARIANCE.P, DAVERAGE, DCOUNT, DMIN, DMAX, DSUM, EXPON.DIST, HYPGEOM.DIST, LARGE, MEDIAN, MODE, MIN, NEGBINOM.DIST, NORM.DIST, NORM.INV, PERCENTILE, PERCENTILE.EXC, PERCENTILE.INC, POISSON.DIST, QUARTILE, QUARTILE.INC, QUARTILE.EXC, RANK, SMALL, STDEV, STDEVP,STDEV.P, STDEV.S, SUM, MAX, COUNT, TREND, TRIMMEAN, GEOMEAN, VAR, VAR.S, VAR.P, VARPArray FormulasFREQUENCY, SUM,LARGE, TRANSPOSECube FunctionsCUBEKPIMEMBER, CUBEVALUE, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBESETCOUNT, CUBEVALUE
... moreless ...