Microsoft+Excel+2

**Gift Giving **  ** Follow the steps below to complete this lesson: ** 
 * 1. Open Microsoft Excel to create a spreadsheet **
 * 2. Go to the cells indicated below and type the following (using bold, all caps, centered alignment): **
 * A1 THE GIFT OF GIVING **
 * E1 TOTAL AMOUNT **
 * 3. Move to the following cells and type-in the information indicated (using bold, all caps, centered alignment) **
 * A3 FRIENDS AND FAMILY **
 * B3 GIFTS **
 * C3 WEBSITE **
 * D3 PRICE **
 * 4. Under FRIENDS AND FAMILY, you are going to go down the A column and type names of friends and family **** members. **
 * 5. Under GIFTS, you are going to type a gift you would like to give that person (anything) **
 * 6. Under WEBSITE, you are going to go online and copy and paste the website where the gift can be found **
 * To do this, go to the address bar of the website where you found the gift and highlight everything in the address bar. Then, hold down the control button while pressing the letter C (this copies). Then go back to your excel spreadsheet and click in the cell next to that gift and hold down the control key while pressing the letter V (this pastes). Your link should appear. **
 * 7. Under PRICE, you are going to put the dollar amount of the gift **
 * 8. **** When you have at least 15 gifts for people, go to F1 and type the following: =sum(d4:d18) **
 * *The last number d18 will change if you have more than 15 friends and family. **
 * 9. **** Click enter and your total should appear for all of the gifts you wish to buy **
 * 10. Go to Format and Cells to select a Border of your choice. **
 * 11. Save and print your document **