Search This Blog

Search Engine

Custom Search

20210128

What is FII, FPI, DII and MF in stock market?

FII means

F - Foreign

I - Institutional

I - Investors


FPI means

F - Foreign

P - Portfolio

I - Investors


And DII means

D - Domestic

I - Institutional 

I - Investors


And MF means

M - Mutual

F - Fund

20210123

How to know which Excel version you are using through an Excel formula?

Formula of INFO helps

The magic word for this is Release with double inverted commas

Type  

= INFO

Apply a left bracket (
Then double inverted commas "
Then type word RELEASE
Then close double inverted commas "
Apply right bracket
Press Enter

You will get the Excel version as 10.0 or 16.0 or any other that you are using. 

= INFO("RELEASE") 

20210122

What is the maximum Number of columns and rows in Microsoft Excel Version 16?


Number of max Columns - 16384

START Column - A
START Number - 1

END Column - XFD
END Number - 16384

Beyond this, if we try to add column, we cannot add as Excels limit is over here at 16384


Number of max rows - 1048576

START Row - A
START Number - 1

END Row - XFD
END Number - 1048576

Beyond this, if we try to add row, we cannot add as Excels limit is over here at 10 lacs 48 thousand five hundred seventy six

So 16k is horizontal limit 
And 10.48 Lacs is vertical limit of excel in Excel version 16


20210121

IPO mandate not visible in Google Pay

Go to Google Pay

Click on Right upper corner where your profile picture is there

Go to Settings

In Settings, you will see Mandates

Click on Mandates

All pending mandates will be visible. 

Click on approve amount. 

Amount will be blocked. 

If you get IPO, amount will be withdrawn or else money will be again unblocked. 

20210120

How to make page Portrait to Landscape in Word documents in same file at same time?


Can be done on last page by this method

Go to Layout
Click on arrow below Hyphenation
A Page Setup Dialog box will come
Click on Landscape

In Apply to
Click on 
1) This section ( if available) 
Or
2) This point forward

The selected documents will be changed from landscape to portrait and vice versa

If need to do in the In-between documents, then repeat above process again and again and keep on changing Landscape to Portrait and Portrait to Landscape as per need. So you will have a single file containing pages which are in Landscape form as well as Portrait form in same file. 

20210116

Good and Bad foods for knee pain

Good foods

1) Paneer

2) Gents finger

3) Pomegranate



Bad food

1) Brinjal

2) Matki (Moth bean - legume) 

3) Gawar (Guar vegetable) 

4) Rice 


20210103

What is full form of Nifty?

1) NIFTY - National Stock Exchange Fifty
    Also known as top 50 companies of NSE 
    Where NSE means National Stock Exchange

2) SENSEX - Stock Exchange Sensitive Index
     Also known as top 30 companies of BSE
     Where BSE means Bombay Stock Exchange

3) NASDAQ - National Association of Securities Dealers Automated Quotation

4) NYSE - New York Stock Exchange