| 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. |
shasha4
AdminSecretaryExcelAssessment.xls
