The 6th grade Science students created a lookup table in Excel that showed the pH values and other characteristics of a dozen different everyday substances. The students learned how to hide columns and how to use the VLOOKUP function. They also used conditional formatting to simulate a pH paper test.
