Home » Computers for IT Officers » Computer Awareness for Bank Exams – MS-Office|Shortcut keys

Computer Awareness for Bank Exams – MS-Office|Shortcut keys

Computer Awareness for Bank Exams

Computer Awareness for Bank Exams

Important Notes on MS-Office and Shortcut Keys.

1. Shortcut buttons for the menu commands are available on the standard toolbar.

2. The minimize/maximize button is present on upper right corner of the word window.

3. Option from the ‘File’ menu that allows you to change the paper size
Page setup.

4. The paragraph Alignment uses the default alignment as Left alignment.

5. The command used to prevent the previous action Undo.

6. The backspace key deletes the character to the left of the cursor.

7. The default spacing in a word document is single.

8. To insert a page break in a document.

  • Select “insert”, select “Break” and click on the page break option.

9. To change the horizontal alignment such that the text is justified:
Select the text you want to be justified; click on the “justified” icon on the formatting toolbar.

10. What is the shortcut key to move the cell pointer to the first cell of the worksheet?
Ctrl + Home.

11. The text that you want to appear at the top and/or bottom of all pages must be given in  Header and Footer.

12. A location for selection of text that you name for reference purpose.

13. To insert the current date and time.
Select “insert”; select “Date and Time”.

14. To view two parts of a word document simultaneously:
Select “Windows”; select “Ruler”.

15. The intersection of a row and a column in a table is called the cell.

16. To split cells in a table: Select the cells; select “table”; select “split cell”; select the number of rows and columns to split into; click “OK”.

17. The feature that enables the user to search for a particular word in a document.
Press Ctrl+F and type the word.

18. What is the maximum length of the document file name?
Up to 256 characters.

19. A word underlined with a wavy red line indicates the spelling mistake.

20. A location or selection of text that you name for reference purpose

21. The shape of the character in the text depends on the choice of Font.
MS Excel.

22. What is the default extension of the workbook in MS-Excel?

23. What is the maximum count of rows in MS-excel?

24. What is the maximum count of columns in MS-excel?

25. How many numbers of default sheets whenever we open a workbook in Ms-excel?

Windows, MS-Office Shortcut Keys:

Start + E    è   to open Explorer.

Start + P    è to open program menu.

Start –I-F   è to open Find window.

Start – S – P  è to Open Printer Window.

Start – S – C  è to Open Control Panel.

Start – R  è To Open Run window.

Start – H è to open the help window.

Start – D è to open document window.

Esc è to discard current action.

Ctrl + Alt + Del è to restart computer.

Ctrl + K è for inserting Hyperlink.

F1 è To open help.

F2 è to modify cell.

F5/ Ctrl +G è to open go to the window.

F5 è to view slide show in PowerPoint.

F7 è to check spelling and grammar.

F10 è to activate or deactivate menu bar.

F12 è to open save as window.

Alt +F4 è to close current application.

Alt + Spacebar è to activate Restore window.

Alt + Tab è to shift between application.

Alt + D è to go to design view of the application.

Alt + F è to open the file menu.

Alt + E è to open Edit menu.

Alt + V è to open view menu.

Alt + I + R è to insert a new row.

Alt + I + C è to insert the new column.

Alt + I + W è to insert a new worksheet.

Alt + I + B è to insert a page break.

Alt + O è to open format menu.

Alt + W è to open window menu.

Right Click + F è to format cell.

Right Click + M è to insert/delete comments.

Right Click + E è to edit comments.

Right Click + H è to hide Comments.

Right, Click + O è to show comments.

Ctrl + A  è to select all.

Ctrl + B  è to bold the selected data.

Ctrl + C  è to copy data.

Ctrl + D  è to duplicate slide, to open font preferences window.

Ctrl + E  è for center alignment.

Ctrl + O  è to open existing files.

Ctrl + N  è to add new document/sheet.

Ctrl + S  è to save the document.

Ctrl + T è create a hanging indent.

Ctrl + F è to find typed data.

Ctrl + P  è to print data.

Ctrl + V  è to paste data.

Ctrl + X  è to cut data.

Ctrl + Y  è to redo current action.

Ctrl + Z  è to undo current action.

Ctrl + H  è to Replace.

Ctrl + I  è to convert the selected data to italic.

Ctrl + J è aligns the selected text or line to justify.

Ctrl + K è insert a link.

Ctrl + L è aligns the selected text or selected text to the left of the screen;

Ctrl + U  è to underline.

Ctrl + L  è  For left alignment.

Ctrl + R  è for right alignment.

Ctrl + Shift + F è to change font.

Ctrl + Shift + P  è to change font size.

Ctrl + Shift + *  è view or hide non printing characters.

Ctrl +]  è to increase font size.

Ctrl + [  è to decrease font size.

Ctrl + Page Up  è to go to the previous sheet.

Ctrl + Page Down è to go to Next Sheet.

Ctrl + M  è to insert a new slide.

Ctrl + left arrow  è moves the cursor one word to the left side.

Ctrl + right arrow è moves the cursor one word to the right side.

Ctrl + up arrow è moves to the beginning of the line or paragraph.

Ctrl + down arrow è moves the cursor to the end of the paragraph.

Ctrl + End è deletes the word to the right of the cursor.

Check Also

Computer Questions for Bank Exams – SBI Clerks 2016

Computer Questions for IBPS Bank Exams 2018

Computer Questions for Bank Exams – SBI Clerks 2016. 1. Whenever we have to give …

DBMS Questions and Answers

DBMS Questions and Answers – Normal Forms

Short Notes on Normalization: The process of organizing data model to efficiently store data and …

IBPS IT Officer Syllabus

IBPS IT Officer Syllabus

IBPS IT Officer Syllabus  (IBPS Specialist Officers CWE – 2016) IBPS Specialist Officers Exam as …