Microsoft Excel: Short Notes For Banking Exams

MS EXCEL
● 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 insert.                                                                  function window

Shift + F5.                 Bring up Find and Replace.                                                              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 current 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