MS EXCEL Basics, Shortcut Keys and Important Points

• ◄◄ Back to Computer Awareness Section
• Practice Questions

►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.

You can also see the Microsoft Office Basics And Shortcuts Keys For Competitive Exams

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