Dec. 1, 2003
Create a folder on your
G: drive for the Excel labs. Some of these
exercises require pre-existing Excel documents. These documents may be
found on the class Web site, under ``Labs'' heading, next to the ``Excel
Lab I'' materials. Right-click each link and save each spreadsheet onto
G: drive folder.
- The underbid.xls workbook was the last assignment completed by
your predecessor prior to his unfortunate dismissal. The worksheet
contains a significant error, which caused your company to underbid a
contract and assume a subsequent loss of $100,000. As you look for the
error, don't be distracted by the attractive formatting. The shading,
lines, and other touches are nice, but accuracy is more important than
anything else. Inform your ``boss'' (that's me) of the nature of the
error. Include suggestions on how to avoid mistakes of this nature in the
- As you probably already know, you must budget for the amount of money
you can spend on entertainment each semester. To help you budget for
entertainment, create a sample worksheet that lists entertainment costs for
six months in at least four categories. You might include categories such
as hobbies, movies, concerts, videos, books, pets, CDs, or any other
recreational expenses. Use formulas to find the total for each month's
expenses and the total for each type of entertainment.
- Start Excel and use a blank, default worksheet.
- Enter the months as column headings and each type of entertainment
as row headings. Use a column for the total to the right of the months
and a row for the total below the entertainment categories. Enter the
values spent for each month and each category.
- Create the total formulas and copy them to the other cells in the
total row and total column.
- Save the file as
- As the owner and business manager of Sound Byte Music, you may need
to travel to other cities to attend music industry conventions, purchase new
inventory, promote the store, or meet with business associates.
When you travel on business, you keep a travel log of mileage so you can
claim travel expenses as a tax deduction. Using the file
travel.xls, complete the travel expenses worksheet by creating
formulas and copying them to the appropriate cells.
Thomas P. Kelliher
Tue Nov 25 09:30:49 EST 2003