Saturday 17 June 2017

Complete List of MS Excel-Word-Power Point Shortcut Keys


  1. Ctrl+A - Select All 
  2. Ctrl+B - Bold 
  3. Ctrl+C - Copy 
  4. Ctrl+D - Fill Down 
  5. Ctrl+F - Find 
  6. Ctrl+G - Goto 
  7. Ctrl+H - Replace 
  8. Ctrl+I - Italic 
  9. Ctrl+K - Insert Hyperlink 
  10. Ctrl+N - New Workbook 
  11. Ctrl+O - Open 
  12. Ctrl+P - Print 
  13. Ctrl+R - Fill Right 
  14. Ctrl+S - Save 
  15. Ctrl+U - Underline 
  16. Ctrl+V - Paste 
  17. Ctrl W - Close 
  18. Ctrl+X - Cut 
  19. Ctrl+Y - Repeat 
  20. Ctrl+Z - Undo 
  21. F1 - Help 
  22. F2 - Edit 
  23. F3 - Paste Name 
  24. F4 - Repeat last action 
  25. F4 - While typing a formula, switch between absolute/relative refs 
  26. F5 - Go to 
  27. F6 - Next Pane 
  28. F7 - Spell check 
  29. F8 - Extend mode 
  30. F9 - Recalculate all workbooks 
  31. F10 - Activate Menubar 
  32. F11 - New Chart 
  33. F12 - Save As 
  34. Ctrl+: - Insert Current Time 
  35. Ctrl+; - Insert Current Date 
  36. Ctrl+" - Copy Value from Cell Above 
  37. Ctrl+’ - Copy Formula from Cell Above 
  38. Shift - Hold down shift for additional functions in Excel’s menu 
  39. Shift+F1 - What’s This? 
  40. Shift+F2 - Edit cell comment 
  41. Shift+F3 - Paste function into formula 
  42. Shift+F4 - Find Next 
  43. Shift+F5 - Find 
  44. Shift+F6 - Previous Pane 
  45. Shift+F8 - Add to selection 
  46. Shift+F9 - Calculate active worksheet 
  47. Shift+F10 - Display shortcut menu 
  48. Shift+F11 - New worksheet 
  49. Shift+F12 - Save 
  50. Ctrl+F3 - Define name 
  51. Ctrl+F4 - Close 
  52. Ctrl+F5 - XL, Restore window size 
  53. Ctrl+F6 - Next workbook window 
  54. Shift+Ctrl+F6 - Previous workbook window 
  55. Ctrl+F7 - Move window 
  56. Ctrl+F8 - Resize window 
  57. Ctrl+F9 - Minimize workbook 
  58. Ctrl+F10 - Maximize or restore window 
  59. Ctrl+F11 - Inset 4.0 Macro sheet 
  60. Ctrl+F1 - File Open 
  61. Alt+F1 - Insert Chart 
  62. Alt+F2 - Save As 
  63. Alt+F4 - Exit 
  64. Alt+F8 - Macro dialog box 
  65. Alt+F11 - Visual Basic Editor 
  66. Ctrl+Shift+F3 - Create name by using names of row and column labels 
  67. Ctrl+Shift+F6 - Previous Window 
  68. Ctrl+Shift+F12 - Print 
  69. Alt+Shift+F1 - New worksheet 
  70. Alt+Shift+F2 - Save 
  71. Alt+= - AutoSum 
  72. Ctrl+` - Toggle Value/Formula display 
  73. Ctrl+Shift+A - Insert argument names into formula 
  74. Alt+Down arrow - Displayy AutoComplete list 
  75. Alt+’ - Format Style dialog box 
  76. Ctrl+Shift+~ - General format 
  77. Ctrl+Shift+! - Comma format 
  78. Ctrl+Shift+@ - Time format 
  79. Ctrl+Shift+# - Date format 
  80. Ctrl+Shift+$ - Currency format 
  81. Ctrl+Shift+% - Percent format 
  82. Ctrl+Shift+^ - Exponential format 
  83. Ctrl+Shift+& - Place outline border around selected cells 
  84. Ctrl+Shift+_ - Remove outline border 
  85. Ctrl+Shift+* - Select current region 
  86. Ctrl++ - Insert 
  87. Ctrl+- - Delete 
  88. Ctrl+1 - Format cells dialog box 
  89. Ctrl+2 - Bold 
  90. Ctrl+3 - Italic 
  91. Ctrl+4 - Underline 
  92. Ctrl+5 - Strikethrough 
  93. Ctrl+6 - Show/Hide objects 
  94. Ctrl+7 - Show/Hide Standard toolbar 
  95. Ctrl+8 - Toggle Outline symbols 
  96. Ctrl+9 - Hide rows 
  97. Ctrl+0 - Hide columns 
  98. Ctrl+Shift+( - Unhide rows 
  99. Ctrl+Shift+) - Unhide columns 
  100. Alt or F10 - Activate the menu 
  101. Ctrl+Tab - In toolbar: next toolbar 
  102. Shift+Ctrl+Tab - In toolbar: previous toolbar 
  103. Ctrl+Tab - In a workbook: activate next workbook  
  104. Shift+Ctrl+Tab - In a workbook: activate previous workbook 
  105. Tab - Next tool 
  106. Shift+Tab - Previous tool 
  107. Enter - Do the command 
  108. Shift+Ctrl+F - Font Drop Down List 
  109. Shift+Ctrl+F+F - Font tab of Format Cell Dialog box 
  110. Shift+Ctrl+P - Point size Drop Down List

Biryanis prove that India is World's Undenable Biryani Capital

LUCKNOWI AWADHI BIRYANI

It is also known as the purest form of biryani and tops the biryani hierarchi, Tari and Raita.

 

MURSHIDABAD SHAHI BIRYANI

It is unique due to the use of potato for substituting half the meat.


 

HYDRABADI DUM BIRYANI

It is extremely spicy and pungent, is considered the richest of all biryanis and if you love spices, It is just perfect.


DELHI DILPASAND BIRYANI

Saffron flavoured eggs, stuffed in fried qualis, further stuffed in marinated meat.



 

KOLKATA KACHCHI BIRYANI

It is mildly spicy, the usual serving consists of rice, which has saffron and rose water along with other ingredients along with "Kosha Chicken", a boiled egg and a boiled potato, rice thereby giving it all the distinct flavours from various ingredient along with Raita.


Tuesday 13 June 2017

SACHIN TENDULKAR TO 51 RECORD BOOK

1)  Most ODIs runs- 18426

 

2)  Most Test runs - 15921

 

3)  Most number of test played - 200

 

4)  Most number of ODIs played - 463

 5)  Most ODI Hundreds - 49

 

6)  Most Test Hundreds - 51

 

7)  Most ODI Fifties - 68

 

8)  Most Test Fifties - 96

 

9)  Most Test nineties - 10

 

10) Most ODI nineties - 18

 

11)  Most Test Fours - 2058

 

12)  Most ODI Fours - 2016

13)  Fastest ODI 10000 Runs - 259 Innings

 

14)  Most numbers of run in world cup history - 2278

 

15)  Most World Cup appearance -6 (1992 to 2011)

16)  Most Runs in a single World Cup - 673 runs in 2003

 

17)  Most International Centuries - 100 Centuries

 

18)  Most Number of Centuries in world Cup history - 06

 

19)  Most Man of the Match Awards - 62

 

20)  Most Man of the Sereis Awards - 17

 

21)  Fastest Test 10000 Runs - 195 Innings

 

22)  Longest One day Career Span - 22 years 91 days

 

23)  Most ODI runs in 1998 one calendar year - 1894

 

24)  Most ODI Hundreds in a Calendar year - 09 (1998)

 

25)  Most Test Hundreds in a calendar uear - 07 (2010)

 

26)  First batsmen to score a Double hundred in ODIs - Vs South Africa

 

27)  Most Scoring 1000 test runs in a calendar year - 6 Times 

      (i.e, 1997-1000, 1999-1088, 2001-1003, 2002-1392, 2008-1063, 2010-1562)

28)  Most 150+ score in Test Cricket - 20 times

 29)  Most runs in test Away from home - 8705

 

30)  Most centuries in test Away from home - 29

 

31) Most Test Centuries before he turned 20 years of age - 05

 

32) Most opend the innings in ODI Cricket - 340 times

 

33)Most overall runs in international Cricket (ODIs+Test+Twenty20) - 34074

 

34)Most 200 runs partnership in ODIs matches - 6 times

35) Sachin, along with Sourav ganguly, hold the world record for the maximum number of runs scored for an opening partnership - 6609

6609 runs in 136 matches ( 21 Centuries, 23 Fifties)

36) Sachin, along with Rahul Dravid, hold the world record for the highest partnership in ODI Matches - 331 runs for 2nd Wicket  (Vs New Zealand in 1999, Hyderabad)

37)Most Consecutive ODI appearance - 185 ODIs (b/w 1990-1998)

 

38)Most Test runs in fourth innings

 

39) Most runs in Average in single world cup - 87.16 (1996 WC)

 

40) Most Number of 50+ scores in ODIs - 145 ( 49 centuries, 96 Fifties)

 

41) Is the only Player with five score of 150 or more in ODIs

42) Is the only player to have made 3 Score of 175 or more in ODIs


 

43) Tendulkar top Scored for india on 129 occasion - most such occasion for any Player in ODIs



 

44) Most ODIs, centuries by any Player against a particular country - 09 Vs AUSTRALIA


 

45) He is the only Player to be in top 10 ICC batsmen ranking for 10 year in test.

 

46) Most number of Man of the Match awards by any Player against a particular country - 12 times Vs AUSTRALIA


 

47) The only Player ever to cross the 14000, 15000, 16000, 17000, 18000 run marks in ODIs

48) Tendulkar has scored over 1000 ODIs run in against all major cricketing nation.


 

49) Most number of Stadium appearance - 90 different grounds

 

50) Most Scored runs in boundaries (Fours) in ODI cricket - 2016*4 = 8064 runs

 

51) Most Scored runs in boundaries (Fours) in Test Cricket - 2058*4 = 8232

 

Handsome Man In Hotel With Boss

A handsome man went into a hotel and asked to see the boss. When the boss came, the story began. The client : Is room 39 empty? The boss:...