Home / Computer Awareness / MS Excel short cut Keys of Computer Awareness

MS Excel short cut Keys of Computer Awareness

MS Excel short cuts for IBPS PO and Clerk examination.Microsoft Excel provides lots of feature for record and storage type of data. It is a software program in Ms Office suite which enables the users to enter the data in the pre defined cells to form a record. The smallest individual unit of information in the Ms excel is called a cell. A group of cells form a record. The record can be related to anything like the employee details and the record of the purchase and sell of the goods and services of a company etc. A lot of details can be stored and manipulated in the MS Excel file and a group of MS Excel files are called the work Book. Thus a group of worksheets that contains different records make a workbook. These work sheets can be joined. There are several formulae which can manipulate these data easily and so it is widely used in industries. There are some of the functions and short cuts which are used in the program which the candidates must know.

MS Excel Short cuts for competitive examinations:

Key Functionality
F2 Edit the selected cell
F3 After a name has been created F3 will paste names
F5 Go to a specific cell. For example, C6
F7 Spell check selected text or document
F11 Create chart from selected data
Ctrl + Shift + ; Enter the current time
Ctrl + ; Enter the current date
Alt + Shift + F1 Insert new worksheet
Shift + F3 Open the Excel formula window
Shift + F5 Bring up search box
Ctrl + A Select all contents of the worksheet
Ctrl + B Bold highlighted section
Ctrl + I Italic highlighted section
Ctrl + K Insert link
Ctrl + U Underline highlighted section
Ctrl + 1 Change the format of selected cells
Ctrl + 5 Strike through highlighted section
Ctrl + P Bring up the print dialogue box to begin printing
Ctrl + Z Undo last action
Ctrl + F3 Open Excel Name Manager
Ctrl + F9 Minimize current window
Ctrl + F10 Maximize currently selected window
Ctrl + F6 Switch between open work books or windows
Ctrl + Page up Move between Excel work sheets in the same Excel document
Ctrl + page down Move between Excel worksheets in the same Excel document
Ctrl + Tab Move between two or more open Excel document
Alt + = Create a formula to sum all of the above cells
Ctrl + ’ Insert the value of the above cell into cell currently selected
Ctrl + Shift + ! Format number in comma format
Ctrl + Shift + $ Format number in currency format
Ctrl + Shift + # Format number in date format
Ctrl + Shift + % Format number in percentage format
Ctrl + Shift + ^ Format number in scientific format
Ctrl + Shift + @ Format number in time format
Ctrl + Arrow key Move to the next selection on text
Ctrl + Space Select entire column
Shift + Space Select entire row
Ctrl + – Delete the selected column or row
Ctrl + shift + = Insert a new column or row
Ctrl + Home Move to cell A1
Ctrl + ~ Switch between showing Excel formulas or their values in cells

General Awareness And GK For Banking

Computer Awareness For Banking

Latest Banking Jobs 

How To Prepare For Interview

Leave a Reply

Your email address will not be published. Required fields are marked *