-->

Tuesday, December 16, 2014

MS EXCEL Basics, Shortcut Keys and Important Points

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS.
It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
The intersection of a row and column is called a Cell.
The cell in which we are currently working is known as Active Cell.
Microsoft Excel's native file formats are denoted either by a .xls or .xlsx file extension.
A Worksheet is made of columns and rows, wherein columns run Vertically and rows run Horizontally.
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

Key
Description
F2
Edit the selected cell
F5
Go to a specific cell
F7
Spell check selected text and/or document
F11
Create chart
Ctrl + Shift + ;
Enter the current time
Ctrl + ;
Enter the current date
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 selection
Ctrl + I
Italic highlighted selection
Ctrl + U
Underline highlighted selection
Ctrl + P
Bring up the print dialog box to begin printing
Ctrl + Z
Undo last action
Ctrl + F9
Minimise current workbook
Ctrl + F10
Maximise currently selected workbook
Ctrl + F6
Switch between open workbooks/window
Ctrl + page up
Move between Excel worksheet 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 files
Alt + =
Create a formula to sum all of the above cells
Ctrl + ’
Insert the value of the above cell



No comments:

Post a Comment