Chapter 41 Geography and Stock data types
Question answered in this chapter:
What properties of geographic locations can be used in Excel formulas?
What properties of corporations can be used in Excel formulas?
Office 365’s new data types mean that cells containing a geographic location or corporation now contain many pieces of current data about the location or corporation. If you have Office 365, you now can write formulas that return various properties of geographic locations. For example, if cell E4 contains Paris, then the formula E4.Population will go to Wikipedia and return Paris’s current population. You can also write formulas that return properties of corporations. For example, if cell E8 contains Microsoft, then the formula E8.Price ...
Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
