Microsoft Excel - Important Terms and Shortcuts

October 19, 2015    

MICROSOFT EXCEL is the spreadsheet program that allows to organise the information in rows and columns or tables with added bonus of automatic mathematics/calculations with the help of formulas.It allows you to print detailed reports, charts and graphs.It forms the part of Microsoft Excel. The default extension of Excel files is xls.

It is developed by Microsoft for Microsoft Windows, iOS and Mac OS X.


ms excel
  • SPREADSHEET - It is computer application program that helps to maintain, organise and compare records in tabular form including graphs.
  • WORKBOOKS - Spreadsheet are saved in documents called Workbooks and is comprised of individual worksheets. The are three default workbooks 
  • WORKSHEETS - It is collection of cells to maintain the data.
  • CELLS - A cell is formed by intersection of row and column. The cell that is currently open and ready for editing is called the Active Cell. It will shown by a darker border around active cells.
  • CELL REFERENCE - It identifies the exact location of active cell. Eg - A5. The column is always the first letter in the cell reference followed  by the row number.
  • FORMULA BAR - It displays the contents of the active cell inculding any formulas.
  • The maximum rows are 1048576 and maximum number of columns are 16384.

TOOLBARS OF MS-EXCEL

  • STANDARD TOOLBAR - It contains the buttons to activate the commands frequently used by the user.

toolbar

  • FORMATTING TOOLBAR - It has the buttons to activate the different fonts and commands to format the paragraphs.

toolbar
  • STATUS BAR - Its shows the active worksheet.

FORMULAS

It is an expression or cell entry that performs some sort of calculations. It is always started with '=' sign,
DESCRIPTION
Subtraction
Multiplication
Exponential

MICROSOFT EXCEL SHORTCUTS

  • F2 - Edit the selected cell
  • F5 - Go to the specific cell
  • F7 - Spell check of Selected cell.
  • Ctrl + Shift + ; - Enter the current time
  • Ctrl + ; - Enter the current date
  • Alt + Shift + F1 - Insert New Worksheet
  • Shift + F3 - Open Excel Formula Window
  • Shift + F5 - Bring up Search Box
  • Ctrl + A - Select all contents if the worksheet
  • Ctrl + B - Bold Highlighted Selection
  • Ctrl + I - Italic Highlighted Selection
  • Ctrl + K - Insert Ink
  • 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 - Maximise current window
  • Ctrl + F10 - Maximise currently selected window
  • Ctrl + F6 - Switch between open workbooks/ windows
  • Ctrl + Page Down - Move between Excel Work Sheets in the same Excel document
  • Ctrl + Page Up - Move between Excel Work Sheets in the same Excel document
  • Ctrl + Tab - Move between two or more open Excel files
  • Alt  + = - Create a formula to sum all the above cells.
  • Ctrl + Shift + # - Format number in date format
  • Ctrl + Shift + % - Format number in percentage format
  • Ctrl + Shift + A - Format number in scientific format 
  • Ctrl + Shift + @ - Format number in time format
  • Ctrl + Arrow Key - Move to the next selection of text
  • Ctrl + Space - Select the entire column
  • Shift + Space - Select the entire row

This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at http://ift.tt/jcXqJW.



Microsoft Excel - Important Terms and Shortcuts 4.5 5 Yateendra sahu October 19, 2015 MICROSOFT EXCEL is the spreadsheet program that allows to organise the information in rows and columns or tables with added bonus of automa...


Related Post:

  • Daily Report: 19th February 2019
    Videos Uploaded Videos Section 5 Minutes Vocabulary - Day 29 Youtube Notes Uploaded Notes Section 5 Minutes Vocabulary - Day 29 - PDF Youtube Articles Published Future of Work Report: Key Facts Weekly Current Affairs February 2019… Read More
  • Banking Awareness Notes PDF
    In a series of sharing useful study material for upcoming banking exams. Today we are providing Banking Awareness handwritten notes in PDF format. Monthly Banking Awareness Digest January 2019 December 2018 November 2018 October 2018 September 2… Read More
  • GK Digest Android App- New Version Available
    Hi Everyone We are glad to inform you all that our GK Digest App which covers that latest current affairs has now been updated with new and exciting features. The new app boasts of the following salient features: Compact, Convenient and Absolut… Read More
  • Weekly Current Affairs February 2019: Week IV
    National Events The Central government has increased the minimum selling price (MSP) of sugar by Rs. 2 per kg to Rs. 31. Minimum Selling Price Minimum Selling Price is the rate below which the mills cannot sell sugar in the open market to wholesa… Read More
  • Year End Review 2018: Department of Atomic Energy
    Unit-1 of Kaiga Generating Station has registered 941 days of continuous operation surpassing the earlier record of 940 days held by Heysham-2 Unit-8 (610 MWe AGR) of UK. Kakrapar Nuclear Power Plant Unit-2 resumed its operations in September 201… Read More
Load comments

No comments:

Post a Comment