Dear Aspirants,
NIACL has activated the link of RECRUITMENT OF of ASSISTANT Cadre lll 2017. You can apply directly by clicking below link.
Monday, 6 March 2017
Sunday, 5 March 2017
SBI PO 2017 Recruitment– Last Date to Apply (Reminder)
Dear Aspirants,
Today is the last day to apply for SBI PO 2017 Examination, candidates those who are not yet applied can apply here by using the link given below to avoid the last minute rush on website.
Saturday, 4 March 2017
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
Friday, 3 March 2017
NIACL Assistant 2017 Official Notification Out
Dear Aspirants,
online registration : 6-03-17 to 29-03-17
Payment of fee: 06-03-17 to 29-03-17
Tier 1 exam- 22nd and 23rd april (tentative)
Tier 2 exam- 23rd May (Tentative)
As per the notice in Times of India on 2nd march The new india Assurance co. Ltd. has released the official Notification for 984 vacancies for Assistance in Class lll cadre.
online registration : 6-03-17 to 29-03-17
Payment of fee: 06-03-17 to 29-03-17
Tier 1 exam- 22nd and 23rd april (tentative)
Tier 2 exam- 23rd May (Tentative)
Notice Regarding IBPS RRB-V Result
Dear Aspirants,
IBPS has released a notice regarding the Declaration of the result of IBPS RRB CWE V informing that the processing of the result /provisional allotment of RRBs-CWE –V is in progress.
The candidates are requested to visit our official website periodically to know the status of Declaration of Result/Provisional Allotment of RRBs-CWE-V.
CURRENCY TERMS WITH EXPLANATION FOR SBI PO
List of Currency Terms With Explanation
Money as a means of payment consists of coins, paper money and withdrawable bank deposits.
Legal tender:
As per provisions of coinage Act 1996, bank notes, currency notes and coins (Re. 1 and above) are legal tender for unlimited amount. The subsidiary coins (below Re. 1) are legal tenders for sum not exceeding Re 1. Issue of 1, 2 and 3 paisa coins discontinued wef Sep 16, 1981.
Currency chest:
Currency chests are operated by the Reserve Bank of India (RBI) so that they can provide good quality currency notes to the public. However, RBI has appointed commercial banks to open and monitor currency chests on behalf of RBI. The money kept in currency chests in the commercial banks is considered to be kept in RBI.
Small coin depot:
The bank branches are also authorized to establish Small Coin Depots to stock small coins. The Small Coin Depots also distribute small coins to other bank branches in their area of operation.
Soiled note:
"Soiled note" means a note which, has become dirty due to usage and also includes a two piece note pasted together wherein both the pieces presented belong to the same note and form the entire note.
Mutilated Note:
Mutilated banknote is a banknote, of which a portion is missing or which is composed of more than two pieces.
Imperfect Note:
Imperfect banknote means any banknote, which is wholly or partially, obliterated, shrunk, washed, altered or indecipherable but does not include a mutilated banknote.
Soiled and Mutilated banknotes can be exchanged for value. All banks are authorized to accept soiled banknotes for full value. They are expected to extend the facility of exchange of soiled notes even to non-customers. All currency chest branches of commercial banks are authorized to adjudicate mutilated banknotes and pay value for these, in terms of the Reserve Bank of India (Note Refund) Rules, 2009
A mutilated banknote can be exchanged for full value if:
1. For denominations of Re. 1, Rs. 2, Rs. 5, Rs. 10 and Rs. 20, the area of the single largest undivided piece of the note presented is more than 50 percent of the area of respective denomination, rounded off to the next complete square centimeter.
2. For denominations of Rs. 50, Rs.100, Rs. 500 and Rs. 1000, the area of the single largest undivided piece of the note presented is more than 65 percent of the area of respective denomination, rounded off to the next complete square centimeter.
Wednesday, 1 March 2017
The New India Assurance Co. Ltd. Recruitment Out
Dear Aspirants,
Greetings Today, The new india Assurance co. Ltd. has come up with 984 vacancies for Assistance in Class lll cadre.
online registration : 6-03-17 to 29-03-17
Payment of fee: 06-03-17 to 29-03-17
Tier 1 exam- 22nd and 23rd april (tentative)
Tier 2 exam- 23rd May (Tentative)
The official Notification will be out soon.
Here is the cutting of the Notification from Today's Times Of India Newspaper.
Greetings Today, The new india Assurance co. Ltd. has come up with 984 vacancies for Assistance in Class lll cadre.
online registration : 6-03-17 to 29-03-17
Payment of fee: 06-03-17 to 29-03-17
Tier 1 exam- 22nd and 23rd april (tentative)
Tier 2 exam- 23rd May (Tentative)
The official Notification will be out soon.
Here is the cutting of the Notification from Today's Times Of India Newspaper.
CLICK the image for clear view
