Excel V

CS 14A

Apr. 14, 1997

Several of these exercises require pre-existing Excel documents. These documents may be found on your R: drive, in nearly the same location in which the previous exercise's documents were found --- the final folder on the ``trail of folders'' is named excel5. Don't forget to do a Save As after you've opened each document.

Questions

These questions may appear on a forthcoming quiz. They come from the Excel Essentials readings)

1. What is a database? A record? A field? A field name?

2. What is a sort? A sort field?

3. What are search criteria? What is a filter?

Exercises

1. On Your Own, Excel Essentials, pg. 151. The filename is music2.xls. There's no need to print anything.

2. Brief Cases, Excel Essentials, pg. 151. The filename is employee.xls. There's no need to print anything.