Banking GK Questions 2026

The Constituent Assembly adopted, enacted and gave to itself the Constitution on 26 November 1949, and the Government of India has observed the date as Constitution Day, or Samvidhan Divas, since 2015.

The date is the birth anniversary of Maulana Abul Kalam Azad, born in 1888, who was independent India's first Minister of Education and the moving spirit behind the founding of the University Grants Commission and the Indian Institutes of Technology.

India's first Prime Minister was born on 14 November 1889, and because of his known fondness for children, who called him Chacha Nehru, his birthday was adopted as Children's Day after his death in 1964.

Columns are lettered A to Z, then AA to AZ, BA to BZ and so on, and the 16,384th column of the enlarged grid falls at XFD.

COUNT walks through the range and counts only the cells that hold a numeric value, which includes dates and times because Excel stores them as serial numbers.

Division by zero has no answer in arithmetic, so Excel refuses to invent one and writes #DIV/0! instead.

A dollar sign locks the part of the address that follows it, so $A$1 has both the column and the row locked and keeps pointing at cell A1 however far the formula is copied.

Excel treats whatever follows an equals sign as something to be calculated, so =A1+B1 adds the two cells and =SUM(A1:A10) totals a range.

From Excel 2007 the grid of one worksheet was enlarged to 1,048,576 rows and 16,384 columns, so the very last cell of the sheet is XFD1048576.

From Excel 2007 onwards the suite moved to the Office Open XML formats, and a plain workbook saves with the.xlsx extension.

Ctrl together with F2 opens the print area of the Backstage view in Excel, Word and PowerPoint, where the page is shown exactly as it will be printed and the printer, copies, orientation and margins can be set.

An electronic spreadsheet stores data in a grid of rows and columns and recalculates its formulas whenever a value changes, and Excel is the spreadsheet program of the Microsoft Office suite.

LEN returns the number of characters in an entry, counting letters, digits, punctuation and spaces alike, so =LEN("Excel") gives 5.

The title bar is the strip along the very top of the Excel window, and it carries the name of the open workbook followed by the name of the program, for example Book1 - Excel.

Pressing Shift together with the spacebar selects the whole row that holds the active cell, from column A right across to the last column of the grid.

The building on Feroze Shah Road, named after Rabindranath Tagore, houses all three of India's national academies, the Sahitya Akademi for letters, the Lalit Kala Akademi for the fine arts and the Sangeet Natak Akademi for the performing arts.

She received the Sahitya Akademi Award in 1956 for her Punjabi poetry collection Sunehe, meaning messages, and was the first woman to be honoured by the Akademi.

The Fellowship, not the annual award, is the highest honour the Sahitya Akademi confers, and its rules restrict it to twenty-one living writers at any one time.

The Sahitya Akademi recognises twenty-four languages and gives one award in each of them every year for the most outstanding book of literary merit, so roughly two dozen names are announced together.

The Prime Minister was the first President of the Sahitya Akademi, elected when the academy was set up in 1954, and he held the office until his death in 1964.