Profile Photo

Microsoft Excel Important Terms and Shortcut Keys of MS Excel

Microsoft Excel Important Terms and Shortcut Keys of MS Excel

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

DescriptionKey
Edit the selected cellF2
Go to a specific cellF5
Spell check selected text and/or documentF7
Create a chartF11
Enter the current timeCtrl + Shift + ;
Enter the current dateCtrl + ;
Open the Excel insert function windowShift + F3
Bring up Find and Replace box.Shift + F5
Select all contents of the worksheetCtrl + A
Bold highlighted selectionCtrl + B
Italic highlighted selectionCtrl + I
Underline highlighted selectionCtrl + U
Bring up the print dialog box to begin printingCtrl + P
Undo the last actionCtrl + Z
Minimize current workbookCtrl + F9
Maximize currently selected workbookCtrl + F10
Switch between open workbooks/windowCtrl + F6
Move between Excel worksheet in the same Excel document.Ctrl + page up
Move between Excel worksheets in the same Excel documentCtrl + Page Down
Move between two or more open Excel filesCtrl + Tab
Create a formula to sum all of the above cellsAlt + =
Insert the value of the above cell into the cell currently selected.Ctrl + ’
Move to the next section to textCtrl + Arrow key
Select entire columnCtrl + Space
Select entire rowShift + 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

 

Microsoft Excel Important Terms and Shortcut Keys of MS Excel Microsoft Excel Important Terms and Shortcut Keys of MS Excel Microsoft Excel Important Terms and Shortcut Keys of MS Excel Microsoft Excel Important Terms and Shortcut Keys of MS ExcelMicrosoft Excel Important Terms and Shortcut Keys of MS Excel

Follow us on Blogarama

Call us: 8800999280/83/84 or fill the form for any other details:

October 15, 2018

No comments, be the first one to comment !

    Leave a Reply

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

    © 2015-19 Takshila Learning. All Rights Reserved.
    Request Callback
    close slider
    Send us a Message

    Login