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

Read More

NIACL Assistant 2017 Official Notification Out

Dear Aspirants,

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)

Click Here To Download The Notification

Source

Read More

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.

Click Here To Check The Notice

Source

Read More

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.

Read More

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.

CLICK the image for clear view

Read More

TODAY'S CURRENT AFFAIRS: 25th FEBRUARY, 2017

Dear Aspirants,

Current affairs are the most important part for the banking exams. You can score more in less time if you have good knowledge of the same. You can be perfect in it by reading daily and note them down in a notebook and revise them daily also read any newspapers on daily basis. Also you can use apps of the newspapers to get instant updates.

Here I'm providing you Today's news summary that will help you in exams.

NATIONAL:
1. TN Govt announces Rs5k short-term aid to 30k fishermen on Oil spill in sea.

2. India's first mountain biking path opened in Darjeeling.

3. Assam to get 9 Passport Seva Kendras around the state.

4. 'Adiyogi' 112-foot tall Shiva statue revealed at Isha Foundation in Coimbatore.

5. Proposal of TN on increase of workdays under MGNREGA to 150 days got approval from Centre.

6. Sylhet city of Bangladesh to get Financial assistance from India on its development.

7. Under Antyodaya Anna Yojana canteens to be opened in Haryana.

8. Maharashtra BJP to be celebrated Vijay Utsav at its head quarters in Mumbai.

9. Liker & Leh Dosmochey festival celebration starts today in Ladakh.

INTERNATIONAL:
10. New Zealand approves Sign Language as a official language.

BUSINESS AND ECONOMY NEWS:
11. Exports of India's steel marked 8.89 lakh tonnes in January.

12. DIPP reports FDI inflow increase 18 % to $46 billion in 2016.

AGREEMENTS:
13. India -Israel made deal of Rs.17,000-crore on jointly develop a missile MR-SAM.

APPOINTMENTS:
14. T R Zeliang Former CM of Nagaland appointed as Finance Advisor to state govt.

SPORTS NEWS:
15. Ball boys to be replaced by Shelter dogs in Brazil Open 2017.

16. Shooting World Cup : Bronze medal won by Pooja Ghatkar of India.

· John-John Dohmen, Naomi Van announced as best hockey players of 2016 in men and Women category

For More Updates

Like Our Facebook Page: Click Here

Join Our Facebook Group: Click Here

Read More

TODAY'S CURRENT AFFAIRS: 24th FEBRUARY, 2017

Dear Aspirants,

Current affairs are the most important part for the banking exams. You can score more in less time if you have good knowledge of the same. You can be perfect in it by reading daily and note them down in a notebook and revise them daily also read any newspapers on daily basis. Also you can use apps of the newspapers to get instant updates.

Here I'm providing you Today's news summary that will help you in exams.

DAYS TO REMEMBER:
1. Central Excise Day - February 24th

NATIONAL:
2. App launched to provide GST updates by CBEC.

3. J&K and Centre planned to invest
₹2,400 crore to boost state's tourism.

4. Dance festival 'Brahan Natyanjali' starts today at Thanjavur temple.

5. Private school of Haryana made must to install solar plants.

6. CBSE insists school buses to have GPS, CCTV & guard facility.

7. Pradeep Refinery project of IOCL got concession on interest by Odisha Govt.

INTERNATIONAL:
8. Bilateral talks held between Bangladeshi PM Sheikh Hasina and India Foreign Sec.

9. 9th edition of BRICS Summit to be take place in China's Xiamen city.

BANKING NEWS:
10. Merger of SBI associate banks with SBI to be kick start from April 1.

BUSINESS AND ECONOMY NEWS:
11. TCS ranked world's third most valuable brand in IT services.

For More Updates

Like Our Facebook Page: Click Here

Join Our Facebook Group: Click Here

Read More