Microsoft Excel waxay leedahay qalab aad u fiican oo kaa caawinaya inaad si fudud u hesho xogta muhiimka ah iyada oo aan wax cilmi baaris ah la samayn. Waxaad si toos ah ugu heli kartaa ku dhawaad ​​xog kasta oo Excel ah iyadoo leh hawlo qaar. Shaqada xogta aan la isticmaalin ee Excel waa xogta Juqraafiga^{(Geography data)} .

Habka xogta juqraafiga ee Excel waa dahab miinada leh oo leh xog badan oo gujis ah. Waxaad heli kartaa xogta goobta sida dadka ku nool, aagga, caasimadda, luqadda, aagga waqtiga, iwm. Haddii aad dib u cusbooneysiiso xogta, xogta hadda jirta ayaa lagu beddeli doonaa xogta cusub. Aan aragno sida aan u isticmaali karno astaanta Juqraafiga^(Geography) ee Excel .

Sida loo isticmaalo Nooca Xogta Juquraafiga^{(Geography Data Type)} ee Excel

Tallaabooyinka loo isticmaalo nooca xogta Juqraafiga ee ^(Geography)Excel

1. Ku buuxi^(Fill) dukumeentiga magacyada goobta
2. Dooro goobaha
3. Guji Xogta ku jirta menu/ribbon
4. Dooro Juqraafiga
5. Kadibna ku dhufo astaanta liiska ee ka sareysa qoraalka la doortay
6. Dooro nooca xogta aad rabto inaad ku darto

Si aad u isticmaasho xogta Juqraafiga^(Geography) , ku buuxi xaashida magacyada goobta aad u baahan tahay xogta, oo dooro iyaga. Hadda, dhagsii Xogta^(Data) ku jirta ribbon oo dooro Juqraafiga^(Geography) .

Habka xogta juquraafiga hadda waa loo dajiyay qoraalka aad dooratay. Guji^(Click) astaanta liiska si aad u aragto noocyada xogta. Dooro nooca xogta aad rabto inaad ku buuxiso xaashida.

Waxaad dooran kartaa nooc kasta oo xogta ah waxaana dhamaantood lagu dari doonaa safka xiga ee xaashida.

Haddii aad rabto in aad dib u cusboonaysiiso xogta aad ku dartay dukumeentiga adiga oo isticmaalaya qaabka Juqraafiga^(Geography) , dhagsii Refresh All in the ribbon.

Tani waxay xogtaada ka dhigaysa mid cusub oo isbeddellada ah. Haddii aad rabto in aad dib u cusboonaysiiso hal xog, ku dhufo midigta oo dooro nooca xogta^{( Data type)} oo guji Refresh.

Xogta Juquraafiga ayaa ka maqan Excel

Haddii aadan awoodin inaad ku muujiso xogta Juquraafiga ee ^(Geography)Excel kaaga , waa inaad ku soo gashaa koontada rukunka ee Microsoft 365 .

Haddii aadan ahayn macaamiil, ma heli kartid sifada. Sidoo kale, luqadaada wax ku hagaajinaysaa waa inay noqotaa Ingiriis.

Hadda akhri^{(Now read)} : Sida loo sameeyo Curve Bell ee Microsoft Excel^{(How to make a Bell Curve in Microsoft Excel)} .

How to use Geography Data Type in Excel

Microsoft Excel has great tools to help you in getting important data easily without any research. You can get almost any data in Excel directly with just some functions. The less-used data function on Excel is Geography data.

The geography data feature in Excel is a goldmine with a lot of data in a click away. You can get data of a location like its population, area, capital, language, timezone, etc. If you refresh the data, the existing data will get replaced by the new data. Let’s see how we can use the Geography feature in Excel.

How to use Geography Data Type in Excel

The steps to use Geography data type in Excel

1. Fill the document with location names
2. Select the locations
3. Click on Data in the menu/ribbon
4. Select Geography
5. Then click on the list icon above the selected text
6. Select the data type you want to add

To use the Geography data feature, fill the sheet with the location names you need data of, and select them. Now, click on Data in the ribbon and select Geography.

The geography data feature is now enabled for the text you have selected. Click on the list icon to see the data types. Select the data type you want to fill in the sheet.

You can select any number of data types and they all will get added to the next row in the sheet.

If you want to refresh the data you have added to the document using the Geography feature, click on Refresh All in the ribbon.

This makes your data up to date with the changes. If you want to refresh a single data, right-click on it and select the Data type and click on Refresh.

Geography Data missing in Excel

If you are unable to Geography data feature in your Excel, you must sign-in with Microsoft 365 subscription account.

If you are not a subscriber, you cannot get the feature. Also, your editing language must be English.

Now read: How to make a Bell Curve in Microsoft Excel.

Related posts

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo Gelida Xogta laga soo qaatay muuqaalka sawirka ee Excel

• Sida loo isticmaalo shaqada TYPE ee Excel

• Sida loogu beddelo Taxanaha Xogta ee garaafka Excel ama jaantuska

• Isticmaal Xidhiidhiyaha Xogta PDF ee Excel si aad u soo dejiso xogta PDF xaashida

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo Data Visualizer Add-In for Excel si loo abuuro Flowcharts

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Isticmaal Hawlaha Kooban si aad u soo koobto Xogta ku jirta Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loogu dabaqo Xaqiijinta Xogta Unugyada Microsoft Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• U isticmaal Excel Qalab ahaan si aad xogta uga koobbiso Shabakadda

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel