EXCEL FUNCTION KEYS

Ms Excel

Spreadsheets, files and memos are necessary documents in most businesses. Until computers became part of the typical business office, these types of records were created on paper and stored in metal filing cabinets. Today, these records are created using computer software programs such as Microsoft Word or Excel and filed electronically.Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes. Excel can store and calculate the data as directed using existing or new data.

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 into cell currently selected.
Ctrl + Arrow key	Move to next section to text
Ctrl + Space	Select entire column
Shift +Space	Select entire row

CS_COMPLETE SUCCESS

144-C MODEL TOWN, PHAGWARA, NEAR ELECTICITY BOARD, PUNJAB - 144401