Gill Library
Customer Book Comments
Karey Gone With The Wind 11/15/2001 11/14/2001
Missy Anne of Green Gables 11/18/2001 11/20/2001
Betsy The Hobbit 11/26/2001 11/28/2001
Ricky The Firm 11/8/2001 11/7/2001
1. Create formula to calculate the information in Column E. Format for number, no decimals.
2. If Statement in Column F. If On Time (Overdue) is greater than zero, Returned on Time, Send Reminder.
Gill-Mart
Employee Payroll
Employee Pay Rate Health
Karey $12.50 40 5
Missy $13.25 25 0
Betsy $10.50 32 0
Ricky $15.75 40 8
Assumptions Questions
Overtime Rate 1.5 Highest Gross Pay
Federal 25% Lowest Pay Rate
Health 3% Average Net Pay
1. Calculate Gross Pay (hint--use rate, overtime rate, and overtime hours).
2. Calculate Federal Withholding
3. Calculate Health.
4. Calculate Total Deductions - the sum of Federal Withholding and Health.
5. Calculate Net Pay.
6. Use functions to answer the questions in Column I
7. Format cells - select your own fill color.
Gill-Mart
Customer Purchase Price Quantity Amount Discount
Karey HP LaserJet 1100 $85.99 5
Missy Dell Laptop $1,299.99 1
Betsy Nokia Cell Phone $75.99 10
Ricky Acer CDRW $159.99 3
Assumptions Average Price
Purchase Quota $700.00 Highest Discount
Discount Percent 15% Lowest Amount
1. Calculate Amount.
2. Calculate Discount: If the Amount is greater than or equal to the Purchase Quota, calculate a discount, 0.
3. Calculate Final Amount.
4. Calculate statistical information in cells G9 to G13.