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

Description Key
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

 

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:

Share and Enjoy !

0Shares
0 0
September 3, 2019

0 responses on "Microsoft Excel Important Terms and Shortcut Keys of MS Excel"

Leave a Message

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

© 2021-22 Takshila Learning. All Rights Reserved.
Request Callback
close slider
For course & fee related queries, Leave your details and our counsellor will get back to you or Call us at 8800-999-280
  • This field is for validation purposes and should be left unchanged.