Excel Test Question

1.       ALL TEXT IN CAPITAL LETTER

2.       TEXT ALIGNMENT IN CENTER

3.       PHOTO IN COMMENT

4.       MULTIPAL RECORD COPY AND PAST IN SINGLE CLICK

5.       ROW KO FAREEZ KARNA HAI

6.       SHRINK TO FIT

7.       SUPERSCRIPT

8.       Text Direction

9.       Text Fit in Single Cell

10.   One Coloum DOB setting

11.   One Coloum DD-MM-YYYY TT:HH setting

12.   Text Hidden

13.   Highlight >33 above marks

14.   Highlight duplicate Value

15.   Row and Coloum insert using with shortcuts keys

16.   Row and coloum size default fitting

17.   Row and coloum hidden

18.   Row and coloum Move

19.   Make a series 1 to 100 (date ki series bannai hai )

20.   Sheet password protected

21.   3 year data name wise calculation

22.   Make a chart

23.   Selected data filter

24.   Make a hayperlink

25.   Selected area print

26.   title for every page

27.   2 pages data in one page fit

28.   Heading and guide line print

29.   Define name to any value

30.   Calculation using shortcuts key

31.   Data trace Calculation area

32.   Shorts

33.   Advance filter

34.   Text to colum

35.   Make a table of value 200,174,156,140

36.   3 year data add using in same sheet each name

37.   One coloum leave all sheet protect

38.   Row freeze

39.   Make a micro

40.   3 open sheet save in one file when I required I can open all file

41.   Sheet one to data sheet 2 par

42.   Data horizontal to vertical paste

43.   Leave one row blank

44.   Blank cell highlight

45.   Blank cell fill (f5 and enter a+ctrl+enter)

46.   Remove duplicate value

47.   Data copy only visible not hidden

48.   DATA SELECT ONLY LISTED NAME WHO ENTER IN EXCEL (IF COLOUM HIDDEN )

49.   I have mobile no and I forget to enter +91 how enter +91 to each colum#@

50.   Protect one Colum in you Sheet