M S EXCEL-2010- EFFICIENCY TEST

M S EXCEL-2010  EFFICIENCY TEST

01. TEST 01 (SUM & AVERAGE)

02. TEST 02 (MINIMUM & MAXIMUM)

03. TEST 03 (SUM & PERCENTAGE)

04. TEST 04 (SUM & COUNT)

05. TEST 05 (SUM, AVERAGE, MAX, MIN, COUNT)

06. TEST 06 (PROPER, UPPER, LOWER)

07. TEST 07 (ROUND, ROUND DOWN, ROUND UP)

08. TEST 08 (SUMIF, SUMIFS)

09. TEST 09 (COUNTIF, COUNTIFS, COUNTA, COUNTBLANK)

10. TEST 10 (IF)

11. TEST 11 (CONCATENATE)

12. TEST 12 (TRIM & LEN)

13- TEST 13 (LEFT, RIGHT, MID, LEFT+RIGHT)

---------------------------------------------------

01 M S EXCEL BASIC CLASS

02 M S EXCEL BASIC CLASS