Spreadsheet #23: Database Functions Using Spreadsheet Software

[Back to Group 1 Assignments] [Back to Chem3020 home]

Read up on the database functions for your spreadsheet and find out how to "query" your table or "filter" a range for the information you want.  Then, load up our old Spreadsheet #3, and using the database operations, answer the following:  (Download another copy of the old spreadsheet by clicking here: SORTDATA )

1. How many titrations were reported for Polymers-4-U?

        2. What was the total number of AA analyses reported?

        3. How many tests were done for Xactor Drugs before July?

        4. How many chloride assays were done by titration vs. gravimetric tests?

        5. What companies requested phosphorus tests by UV/VIS?

        6. How many total tests were completed from 3/15 through 12/31?

Print a hard copy of your lists to answer each of the questions above.  Also make a cover sheet, summarizing your results, and turn both of them in during class.

Programming Tips:

In Excel, you can select Auto Filter to select the information you want. (Data > Filter > Autofilter)

In Excel, a blue arrow signifies a filter is being applied to that column.

Make sure that with each new search you have set the previous filter back to “View All.”