Basic Computer Knowledge Microsoft Office Excel

By | December 14, 2018

Microsoft Office Excel:- Ms Excel of Microsoft Office Excel is part of Microsoft Office Package. It is a spread sheet type of software to organize, manage, format, manipulate & calculate using formulas.

The file extension of Ms excel is .xls or .xlsx. The default file name of Microsoft Excel is Book1. A sheet is a contains of many cells. Intersection of Rows & columns create cells.

Below some useful shortcut keys of MS Excel:-

Shortcut Keys of MS-Excel and their Descriptions
Shortcut Keys Description
F2 Edit the selected cell.
F5 Go to a specific e.g., C6
F7 Spell chech selected text and/or document.
F11 Create chart.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + F1 Insert new worksheet.
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 + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + 5 Strike through 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/windows.
Ctrl + Page up Move between Excwl worksheets in the same Excel document.
Ctrl + Page down Move between Excwl 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 into cell currently selected.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Space Select entire column.
Shift + Space Select entire row.

 

Test Your Excel Knowledge Here:-

[wp_quiz id="6557"]

Leave a Reply

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