Tuesday, 24 March 2015

Ms - Excel Exercises – Functions 2015



Type the following functions in Ms Excel starting with an equal sign and fill the answers here.
A.
1.       ABS(-1.45)     ____________            2.         INT(3.67)_________________
3.       MOD(14,3)     ____________            4.         QUOTIENT (26, 3) __________
5.       INT (RAND ()*3)       ________        6.         ROUND (12.345, 2) __________
7.       SQRT (25)       ____________            8.         TRUNC (12.345, 2) __________
9.       AND (-2>-3, 4>0)       ________        10.       OR (4>4, -3>-2)          _________
11.     NOT (0=0)      ____________            12.       AND (OR (1>0, 3<2), 3<>1) ______
13.     "34"&"56"       ____________            14.       IF (4>2,"ABC","BBQ")          ______


B.
1.         CHAR (65)     ____________         2.         CODE ("a")     ______________
3.       CONCATENATE ("A","B") ___        4.         EXACT ("A","a")       __________
5.       ISBLANK ("B")         _________     6.         LEFT ("1234", 2)        __________
7.         LEN ("1Ab_35")         _________  8.         LOWER ("JF&*AB") ______
9.       MID ("abcde", 2, 3)    _________    10.       PROPER ("abc bbq")  ______
11.     RIGHT ("1234", 2)     _________    12.       TEXT (123.4534,"0.00") ______
13.     TRIM (" a  b  c ")        _________   14.       UPPER("12ah*&")     __________
15.     VALUE("13.56")        _________    16.       VALUE("1 1/2")         __________


C.

A
B
C
D
1

ENG
CHI
MATH
2
PETER
3
5
4
3
MARY
4
6
3
4
JOHN
2
2
5
5
ANN
2
1


           






  1.        SUM(B2:B5)  ________________      2.  MAX(B2:B5)  ________________
  3.       AVERAGE(D2:D4) ___________       4.  COUNT(A1:D5)   ____________
  5.       COUNTA(A1:D5) ____________      6.  COUNTBLANK(A1:D5) ________
  7.       SUMIF(B2:C5,">2") _________         8.  SUMPRODUCT(B2:B4,C2:C4) ______
  9.       SUMSQ(B2:B4) ____________        10.  COUNTIF(B2:C5,"2") _________
 11.      LARGE(B2:B4,2) ___________         12.   SMALL(B2:B4,1)  ____________
13.      RANK(5,B2:C5) ___________          14.   RANK(3,B2:D3,1)  _____________

Propellerads