Any topic (writer’s choice)

For this Lab 3 you should do the following:

Create an excel file referring to a topic of your choice. This may be a list of books and various attributes, patrons and their item rentals, a budget for a school or library, a personal budget, etc.

Whatever the example, make sure you have some values that make sense to sum, average and/or calculate in some way.

Submit the spreadsheet file containing the following:

1. A list of items and attributes (some of which must be numeric)

2. The use of cell references

3. The use of at least 2 excel functions

4. At least one reference to another sheet

5. Some formatting changes (e.g. cell merge, colors, borders, cell format, etc.)

You can leave a response, or trackback from your own site.