How to use Offset formula in excel in Hindi
Автор: SP Standard Education
Загружено: 2020-08-04
Просмотров: 156
in this video we will able to use of offset formula/function in excel. What is Offset formula in excel. where we can apply offset formula in excel. what is the syntax of formula OFFSET. what is the correct method for applying Offset formula. How to apply offset formula in excel. How to add offset formula in excel. what is the right method for applying offset formula in excel.
Below data is for your practice. just copy the same in new excel sheet and apply text to column function on it and do practice with the same...
Serial no.|Indian Cities|Population|Density(/km2)|Literacy|*Sex Ratio|Main Language
1|Mumbai |12478447|22937|0.9028|852|Marathi
2|Delhi |16753235|11297|0.8634|875|Hindi
3|Bangalore |8425970|4378|0.89|914|Kannada
4|Hyderabad |6809970|18480|0.8296|945|Telugu
5|Ahmedabad |5570585|12000|0.8962|897|Gujarati
6|Chennai |4681087|21000|0.9033|986|Tamil
7|Kolkata |4486679|24000|0.8714|899|Bengali
8|Surat|4462002|14000|0.8903|758|Gujarati
9|Pune|3115431|603|0.9161|945|Marathi
10|Jaipur|3073350|598|0.8434|898|Rajasthani
11|Lucknow|2815601|690|0.8472|915|Hindi
12|Kanpur|2767031|1366|0.8414|842|Hindi
13|Nagpur|2405421|11000|93.13|961|Marathi
14|Indore|1960631|3727|0.8738|921|Hindi
15|Thane|1818872|12000|0.9136|882|Marathi
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
