GCSE/IGCSE and AS/A Level ICT-Applied ICT

Using the Web, the GoogleLookup function attempts to find the values for straightforward facts about specific things. Keep in mind that while the GoogleLookup function knows quite a bit, it doesn’t know everything. Although not all of the formulas you try will work, we encourage you to experiment.

When GoogleLookup isn’t sure if an answer isn’t the best one for your entry, you’ll see a dialog box with a handful of possible answers that you can choose from. Just select the cell and click More Options… to select a different value.

Below are instructions to use the GoogleLookup function and a list of common Lookup functions.

To use the GoogleLookup function, enter the following formula in the desired spreadsheet cell:

Syntax: =GoogleLookup(“entity”; “attribute”) where “entity” represents the name of the entity that you want to access, like Kuala Lumpur, Audrey Hepburn, or oxygen, and “attribute” is the type of information that you want to retrieve.

Different attributes apply to different entities. For example:

• Boston has a population.
• Kofi Annan has a place of birth.
• The Mississippi River has an origin.

Here are a couple of examples:

• To insert the number of Internet users in Paraguay:
  =GoogleLookup(“Paraguay”; “internet users”)
• To insert the Earned Run Average of Roger Clemens:
  =GoogleLookup(“Roger Clemens”; “earned run average”)

Note: In order for the formula to compute properly, quotation marks must be used around both the “entity” and the “attribute.”

First I’ve tried to use GoogleLookup function to find Australi’a population and here is the screenshots:

Then I’ve tried to find Australia’s total internet users. Here is the screenshots and the result:

Here are some of the types of entities you can access using GoogleLookup, and a few popular attribute names (some entities won’t have all these attributes, and some will have more, so feel free to experiment):

• Countries and Territories (like “Burkina Faso”): population, capital, largest city, gdp
• U.S. States (like “Tennessee”): area, governor, nickname, flower
• Rivers (like “Amazon River”): origin, length
• Cities and Towns (like “Chicago”): state, mayor, elevation
• Musicians (like “John Lennon”): date of birth, place of birth, nationality
• Actors (like “Audrey Hepburn”): date of birth, place of birth, nationality
• Politicians (like “Anwar Al-Sadat”): date of birth, place of birth, nationality
• U.S. Presidents (like “Zachary Taylor”): date of birth, place of birth, political party
• Baseball Players (like “Wade Boggs”): games, at bats, earned run average, position
• Chemical Elements (like “Helium”): atomic number, discovered by, atomic weight
• Chemical Compounds (like “Isopropyl Alcohol”): chemical formula, melting point, boiling point, density
• Stars (like “Betelgeuse”): constellation, distance, mass, temperature
• Planets (like “Saturn”): number of moons, length of day, distance from sun, atmosphere
• Dinosaurs (like “Velociraptor”): height, weight, when it lived
• Ships (like “USS Chesapeake”): length, displacement, complement, commissioned
• Companies (like “Hewlett-Packard”): employees, ceo, ticker

No related posts.

Tags: computer networks, dynamic spreadsheet, free worksheets, gcse, gcse ict, gcse past exam papers, google, google documents, googlelookup, ict, IGCSE, igcse ict, lookup, past exam papers, revision notes, spreadsheet, Spreadsheets

Trackback URI | Comments RSS