MIS 388

Guest Check Homework

Create an Excel workbook that will make the necessary computations and look like the example that follows:

The following computations must be made:

1. One sheet in the workbook should be named “Price List” and contain the table shown below.

2. A second sheet in the workbook should be renamed “Guest Check” and contain the data shown below.

1. You should enter the numbers in the column labeled “Item” into the worksheet
2. The columns labeled “Description” and “Price” should be retrieved from the price list worksheet using the VLOOKUP function. Conditionally format these columns so that the #N/A does not show in unused lines.
3. You should enter the numbers in the column labeled “Quantity” into the worksheet
4. The column labeled “Amount” is computed by multiplying “Quantity” times “Price”. Conditionally format this column so that the zeroes don’t show.
5. The “TOTAL” line is the summation of the “Amounts” above.
6. “Tax” is computed at a rate of 8.25% of “TOTAL”.
7. “Amount Due” is the sum of “TOTAL” and “Tax”.

3. Attach the Excel file to an e-mail and send it to me with the subject “John Doe (9:99 class)– Guest Check homework”.

Price List

Price List
Item Number	Description	Regular Price
10	Hamburger	0.69
15	Double Burger	1.5
20	Cheeseburger	0.79
25	Double Cheese	1.6
60	French Fries	0.65
90	Coke	0.45

Guest Check

DAVE'S DANDY DELIGHTS
Burgers for the Strong at Heart
Item	Description	Quantity	Price	Amount
90	Coke	5	0.45	$2.25
10	Hamburger	3	0.69	$2.07
60	French Fries	3	0.65	$1.95
20	Cheeseburger	2	0.79	$1.58
			TOTAL	$7.85
			Tax (8.25%)	$0.65
			Amt Due	$8.50