Microsoft Excel Important Terms and Shortcut Keys of MS Excel
Microsoft Excel is an electronic spreadsheet application developed by Microsoft that is used for analyzing, sharing and managing information for accounting purpose performing mathematical calculations, budgeting, billing, etc.
A Cell in MS Excel is the intersection of a row and column where you can write data.
Active Cell in MS Excel is the cell in which you are currently working.
Ms-Excel consists of worksheets. A Worksheet is a collection of rows and columns, wherein columns run vertically and rows run horizontally.
Workbook It contains several worksheets. By default, there are three worksheets in a workbook.
.xls or .xlsx is the extension of Microsoft Excel.
Up to Excel 2003, the standard amount of columns has been 256 and 65,536 rows.
Excel 2007 onwards, the maximum number of rows per worksheet increased to 1,048,576 and the number of columns increased to 16,384.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter named columns to organize data manipulations like arithmetic operations.
The letter and number of the intersecting column and row is the Cell Address.
Short cut key to insert a new worksheet in MS-Excel is ALT + Shift + F1 + or F11.
Sheet tab is the tab at the bottom of the worksheet window that displays the name of the worksheet.
A Microsoft Office document that contains one or more worksheets is known as a Workbook.
Shortcut Keys of MS-Excel
|Edit the selected cell||F2|
|Go to a specific cell||F5|
|Spell check selected text and/or document||F7|
|Create a chart||F11|
|Enter the current time||Ctrl + Shift + ;|
|Enter the current date||Ctrl + ;|
|Open the Excel insert function window||Shift + F3|
|Bring up Find and Replace box.||Shift + F5|
|Select all contents of the worksheet||Ctrl + A|
|Bold highlighted selection||Ctrl + B|
|Italic highlighted selection||Ctrl + I|
|Underline highlighted selection||Ctrl + U|
|Bring up the print dialog box to begin printing||Ctrl + P|
|Undo the last action||Ctrl + Z|
|Minimize current workbook||Ctrl + F9|
|Maximize currently selected workbook||Ctrl + F10|
|Switch between open workbooks/window||Ctrl + F6|
|Move between Excel worksheet in the same Excel document.||Ctrl + page up|
|Move between Excel worksheets in the same Excel document||Ctrl + Page Down|
|Move between two or more open Excel files||Ctrl + Tab|
|Create a formula to sum all of the above cells||Alt + =|
|Insert the value of the above cell into the cell currently selected.||Ctrl + ’|
|Move to the next section to text||Ctrl + Arrow key|
|Select entire column||Ctrl + Space|
|Select entire row||Shift + Space|
Takshila Learning offers bank exams coaching as per aspirant’s requirement:
- Offline, online and live classes for SBI / IBPS PO, Clerk RRB exams.
- Basic & Advanced packages are available.
- Complete study material (PDF format)
- Online Test Series with performance analysis.
- Faculty Support
- Latest Exam Alerts & analysis
- Current affairs in Hindi
Register with Takshila Learning & stay updated..!
Follow us on a Social media