MICROSOFT EXCEL SHORTCUT KEYS

MICROSOFT EXCEL SHORTCUT KEYS

1. F2 Edit the selected cell
2. F3 After a name has been created F3 will paste names
3. F5 Go to a specific cell. For example, C6
4. F7 Spell check selected text or document
5. F11 Create chart from selected data
6. Ctrl + Shift + ; Enter the current time
7. Ctrl + ; Enter the current date
8. Alt + Shift + F1 Insert new worksheet
9. Shift + F3 Open the Excel formula window
10. Shift + F5 Bring up search box
11. Ctrl + A Select all contents of the worksheet
12. Ctrl + B Bold highlighted section
13. Ctrl + I Italic highlighted section
14. Ctrl + K Insert link
15. Ctrl + U Underline highlighted section




16. Ctrl + 1 Change the format of selected cells
17. Ctrl + 5 Strike through highlighted section
18. Ctrl + P Bring up the print dialogue box to begin printing
19. Ctrl + Z Undo last action
20. Ctrl + F3 Open Excel Name Manager
21. Ctrl + F9 Minimize current window
22. Ctrl + F10 Maximize currently selected window
23. Ctrl + F6 Switch between open work books or windows
24. Ctrl + Page up Move between Excel work sheets in the same Excel
document
25. Ctrl + page down Move between Excel worksheets in the same Excel
document
26. Ctrl + Tab Move between two or more open Excel document
27. Alt + = Create a formula to sum all of the above cells
28. Ctrl + ' Insert the value of the above cell into cell currently
selected
29. Ctrl + Shift + ! Format number in comma format
30. Ctrl + Shift + $ Format number in currency format
31. Ctrl + Shift + # Format number in date format
32. Ctrl + Shift + % Format number in percentage format
33. Ctrl + Shift + ^ Format number in scientific format
34. Ctrl + Shift + @ Format number in time format
35. Ctrl + Arrow key Move to the next selection on text
36. Ctrl + Space Select entire column
37. Shift + Space Select entire row
38. Ctrl + - Delete the selected column or row
39. Ctrl + shift + = Insert a new column or row
40. Ctrl + Home Move to cell A1
41. Ctrl + ~ Switch between showing Excel formulas or their values in
cells
For more articles visit http://cracksbipo.blogspot.com

http://i-phone5c.blogspot.com

http://patelbassar.blogspot.com

http://thegkgarden.blogspot.com

http://microcontrollergarden.blogspot.com


http://microcontroller.tk

MICROSOFT WORD SHORTCUT KEYS

MICROSOFT WORD SHORTCUT KEYS

1. Ctrl + Backspace Deletes word to the left of cursor
2. Ctrl + End Moves the cursor to the end of the documents
3. Ctrl + Home Moves the cursor to the beginning of the document
4. Ctrl + Spacebar Reset highlighted text to the default font
5. Ctrl + 1 Single-space lines
6. Ctrl + 2 Double-space lines
7. Ctrl + 5 1.5-line spacing
8. Ctrl + Alt + 1 Changes text to heading 1
9. Ctrl + Alt + 2 Changes text to heading 2
10. Ctrl + Alt + 3 Changes text to heading 3
11. Alt + Ctrl + F2 Open new document
12. Ctrl + F1 Open the task pane
13. Ctrl + F2 Display the print preview
14. Ctrl + Shift + > Increases the highlighted text size by one
15. Ctrl + Shift + < Decreases the highlighted text size by one
16. Ctrl + Shift + F6 Opens to another open Microsoft Word Document
17. Ctrl + Shift + F12 Prints the document
18. F1 Open help
19. F4 Repeat the last action performed (Word 2000+)
20. F5 Open the find, replace, and go to the window in Microsoft Word
21. F7 Spellcheck and grammar check selected text or document
22. F12 Save as
23. Shift + F3 Change the text in Microsoft word from uppercase to
lowercase or a capital letter at the beginning of the every word
24. Shift + F7 Runs a Thesaurus check on the word highlighted
25. Shift + F12 Save
26. Shift + Enter Create a soft break instead of new paragraph
27. Shift + Insert Paste
28. Shift + Alt + D Insert the current date
29. Shift + Alt + T Insert the current time
30. Click ,hold and drag Selects text from where you click and hold to
the point you drag and let go
31. Double-click If double-click a word, selects the complete word
32. Triple click Selects the line or paragraph of the text the mouse
triple-clicked
For more articles visit http://cracksbipo.blogspot.com

http://i-phone5c.blogspot.com

http://patelbassar.blogspot.com

http://thegkgarden.blogspot.com

http://microcontrollergarden.blogspot.com


http://microcontroller.tk

Chemistry General knowledge questions

1. Gun Powder is a mixture of ______ ?
Answer: Sulphur, Carbon and Nitre

2. Which is the only liquid nonmetal ?
Answer: Bromine

3. The first metal used by man was _____ ?
Answer: Copper

4. Which is the Most abundant Noble gas in the air ?
Answer: Argon

5. Which metal is present in Insulin ?
Answer: Zinc

6. Which metal is present in human tears ?
Answer: Zinc

7. Which metal is present in chlorophyll ?
Answer: Magnesium

8. Which metal is present in Sindur (the sacred material of Hindus) ?
Answer: Lead

9. Which metal is present in hemoglobin ?
Answer: Iron

10. Which is the Alkali metal used in photovoltaic cell ?
Answer: Cesium
For more articles visit http://cracksbipo.blogspot.com

http://i-phone5c.blogspot.com

http://patelbassar.blogspot.com

http://thegkgarden.blogspot.com

http://microcontrollergarden.blogspot.com


http://microcontroller.tk

Important Computer Gk Questions

1. What is the name of Encyclopedia stared by Google ?
Answer: Knol

2. Who is the Father of super computer ?
Answer: Seymour Cray

3. Who is the father of Indian Super Computer ?
Answer: Vijay Bhatkar

4. Which is the India's First Super Computer ?
Answer: PARAM 8000

5. Which is worlds Fastest super Computer ?
Answer: Titan (IBM Sequoia is now in second place)

6. Which Company is known as Big Blue ?
Answer: IBM

7. Who is the first computer programmer ?
Answer: Ada King

8. Who built Mechanical analog computer ?
Answer: Lord Kelvin

9. Who wrote the book Business @ the speed of thought ?
Answer: Bill Gates

10. Who is the Father of Cellular Phone ?
Answer: Martin Cooper

11. What is the full form of CAD ?
Answer: Computer Aided Design *

12. Where is the first Cyber Police Station in India ?
Answer: Bangalore *

13. Where is the first Cyber Police Station in kerala ?
Answer: Pattom (Thiruvananthap uram) *

14. Where is the first Cyber Police Station in Asia ?
Answer: Singapore *

15. Where is the first Cyber Post office in India ?
Answer: Chennai
For more articles visit http://cracksbipo.blogspot.com

http://i-phone5c.blogspot.com

http://patelbassar.blogspot.com

http://thegkgarden.blogspot.com

http://microcontrollergarden.blogspot.com


http://microcontroller.tk