Instructions
These are the instructions for editing the Test Worksheet tab of this workbook.
1. Begin typing your First, Middle and Last Name in Cell A1; make the Font – ARIAL; make the Font Size – 14; Merge & Center your name across columns A thru E.
2. Note the Purchasing Card # beginning in Cell B2. Reformat the Card # to BOLD; Reformat the color of the numbers to a shade of purple.
3. Sort the Transaction Detail information alphabetically by Vendor; Insert a New Comment to Cell A8 to explain how you completed the sort.
4. In Cell D16 (Total1), include a formula to add the 1st 3 amounts in the Transaction Detail
5. In Cell D17 (Total2), include a formula to add the last 3 amounts in the Transaction Detail
6. In Cell D18 (Total3), include a formula to add the amounts in Cells D16 and D17; Edit the format of the result to Bold.
7. The data from Cell E10 should be automatically included in Cell B22; complete this action without copying and pasting.
8. The data from Cell E11 should be automatically included in Cell B23; complete this action without copying and pasting.
9. The amount from Cell D10 should be automatically included in Cell D22; complete this action without copying and pasting.
10. The amount from Cell D11 should be automatically included in Cell D23; complete this action without copying and pasting.
11. Save this workbook as AdminSecExcelTest – YourLastNameFirstName and return via email per the instructions by the deadline.
TEST WORKSHEET
Purchasing Card # 4715 1234 9876 5623
Department: MARSHAL
TRANSACTION DETAIL
Transaction # Date Vendor Amount Funding Line
1 8/3/16 John Thornton’s Chevrolet $490.45 100-419-4202-1110
2 8/3/16 GA Post Council $33.00 100-419-4202-1349
3 8/4/16 McGarity’s $116.40 100-419-4202-1462
4 8/5/16 Home Deport $154.94 100-419-P019-1713
5 8/5/16 Home Deport $255.23 100-419-P019-1713
6 8/5/16 Home Deport $143.46 100-419-P019-1713
Total1 $
Total2 $
Total3 $
ACCOUNT SUMMARY
Line # Funding Line Amount
1
2
3
4
5
6
Total $ $0.00
&C&”Arial,Bold”&18&UPurchasing Card Reconciliation Form