MS Excel Exercises
Problem 1
The Williamson Corp
Properly fill out the deposit slip for The Williamson Corp., based on the following information:
a. Date: ma DATE July 9, 20xx
b. $16,580 in currency Bujngu CHECKS
c. $62.25 in coins
d. Checks in the abount of $2,455.94; $4,338.79; and $1,461.69
MS Excel Exercises TOTAL-OTHER SIDE
Problem 2 Bank of America TOTAL
LESS CASH
NET DEPOSIT
Properly fill out the deposit slip for The Williamson Corp., based on the following information:
a. Date: July 9, 20xx
b. $16,580 in currency
c. $62.25 in coins
d. Checks in the abount of $2,455.94; $4,338.79; and $1,461.70
MS Excel Exercises
Problem 3
CURRENCY $ 16,580.00
COIN $ 62.25
$ 2,455.94
$ 4,338.79
$ 1,461.69
L-OTHER SIDE
$ 24,898.67
$ 24,898.67
,
MS Excel Exercises
Problem 2
Properly fill out the deposit slip for Sally Randall, based on the following information:
a. Date: December 18, 20xx
b. A check for $651.03
c. $150 cash withdrawal
Note: Fill in the appropriate values and use Excel for all computations.
SALLY RANDALL
CURRENCY $ 150.00
DATE December 18, 2023 COIN
CHECKS $ 651.30
TOTAL-OTHER SIDE
Bank of America TOTAL $ 801.30
LESS CASH $ 150.00
NET DEPOSIT $ 651.30
MS Excel Exercises
Problem 3
On April 3, Skeeter King received her bank statement, showing a balance of $1,637.93.
Her checkbook showed a balance of $1,493.90. Outstanding checks were $224.15,
$327.80, $88.10, $122.42, and $202.67. There was an $8.00 service charge, and the deposits
in transit amounted to $813.11. Use the form below to reconcile Skeeter's account.
Checks Outstanding
Amount
$ 224.15
$ 327.80
$ 88.10
$ 122.42
$ 202.67
Total $ 965.14
CHECKBOOK BALANCE $ 1,493.90 STATEMENT BALANCE $ 1,637.93
Add: Interest & Other Credits Add: Deposits in Transit $ 813.11
SUB TOTAL SUB TOTAL $ 2,451.04
Deduct: Service Charges & Other Debits $ 8.00 Deduct: Outstanding Checks $ 965.14
ADJUSTED CHECK BOOK BALANCE 1,493.90 ADJUSTED STATEMENT BALANCE $ 1,477.90
MS Excel Exercises
Problem 4
Bob Albrecht received his bank statement on July 5, showing a balance of $2,663.31. His
checkbook had a balance of $1,931.83. The statement showed a service charge of $15.80
and a note collected by the bank for Bob, in the abount of $200.00. (A note collected is
a payment owed to Bob by someone who makes that payment directly to bob's bank
account.) The deposits in transit totaled $314.12, and the outstanding checks were for
$182.00, $261.40, and $418.00. Use the form below to reconcile Bob's account.
Checks Outstanding
Amount
$ 182.00
$ 261.40
$ 418.00
Total $ 861.40
CHECKBOOK BALANCE $1,931.83 STATEMENT BALANCE $2,663.31
Add: Interest & Other Credits $ 200.00 Add: Deposits in Transit $ 314.12
SUB TOTAL 2,131.83 SUB TOTAL $ 2,977.43
Deduct: Service Charges & Other Debits $ 15.80 Deduct: Outstanding Checks $ 861.40
ADJUSTED CHECK BOOK BALANCE 2,131.83 ADJUSTED STATEMENT BALANCE 2,100.23
MS Excel Exercises
Problem 5
As cashier for the Country Kitchen Care, it is your responsibility to make the daily
deposits. Complete the deposit slip below based on the following information:
a. Date: January 20, 20xx
b. Checks totaling $344.20
c. Currency of $547.00
d. Coins: 125 quarters, 67 dimes, 88 nickels, and 224 pennies.
Note: Fill in the appropriate values and use Excel for all computations (including
the total for the coins).
COUNTRY KITCKEN CAFÉ
CURRENCY $ 547.00
DATE Jan 20,20xx COIN $ 44.59
CHECKS $ 344.20
TOTAL-OTHER SIDE $ 935.79
Grove Isle Bank TOTAL
LESS CASH
NET DEPOSIT $ 935.79
MS Excel Exercises
Problem 6
On October 1, Jennifer Bernhard received her bank statement showing a balance of
$440.22. Her checkbook records indicate a balance of $338.97. There was a service
charge for the month of 414.40 on the statement. The outstanding checks were for
$47.10, $110.15, $19.80, and $64.10. The deposits in transit totaled $125.50. Use the
following form to reconcile Jennifer's checking account.
Checks Outstanding
Amount
$ 47.10
$ 110.15
$ 19.80
$ 64.10
Total $241.15
CHECKBOOK BALANCE $ 338.97 STATEMENT BALANCE $ 440.22
Add: Interest & Other Credits Add: Deposits in Transit $ 125.50
SUB TOTAL $338.97 SUB TOTAL $ 565.72
Deduct: Service Charges & Other Debits $ 414.40 Deduct: Outstanding Checks $ 241.15
ADJUSTED CHECK BOOK BALANCE $338.97 ADJUSTED STATEMENT BALANCE -$89.83
MS Excel Exercises
Problem 7
If a 48-piece set of stainless steel flatware costs $124.80, what is the cost per piece?
Number of pieces = 48
Total cost = $ 5,990.40
Cost per piece = $ 124.80
MS Excel Exercises
Problem 8
If the interest on a $4,600 loan is $370, what would be the interest on a loan of $9,660?
Case 1 Case 2
Principal = $4,600.00 Principal = $9,660.00
Interest = $370.00 Interest = $777.00
MS Excel Exercises
Problem 9
What is the total cost to ship an order weighing 420 pounds if the breakdown
is $.18 per pound for packing, $.12 per pound for insurance, $.37 per pound
for transportation, and $148.60 for the shipping crate?
Weight of order = 420 pds
Packing charge per pound = $ 0.18
Insurance charge per pound = $ 0.12
Transportation charge per pound = $ 0.37
Charge for shipping crate = $ 148.60
Total cost = $ 430.00
MS Excel Exercises
Problem 10
A recipe calls for 1 1/2 tablespoons of minced garlic for every 1/4 pound of
pasta. How much garlic would be required for 2 1/2 pounds of pasta?
Case 1 Case 2
Garlic = 1 1/2 tbs Garlic = 15 tbs
Pasta = 1/4 pound Pasta = 2 1/2 pounds
