Activity – Excel 4: Creating a budget

  1. Start a new Excel workbook.
  2. Save the file as Your name TEP021 Excel 4.xlsx in the documents folder on your computer.
  3. Create a weekly budget spreadsheet using the information below.
  4. Newspaper at $2.20per day from Monday to Friday. $2.80 each for Saturday and Sunday.
  5. Milk at $4.75 every day.
  6. Personal spending $35.00 per day from Monday to Friday. $50.00 each for Saturday and Sunday.
  7. Bread at $3.70 per loaf on Monday, Wednesday, Friday, and Saturday.
  8. General Groceries – $200.00 on Thursday.
  9. Football – $25.00 on Saturday (not included in personal spending).
  10. Lunch – $18.00 each from Monday to Friday.
  11. Click the File tab and then Save As to save the spreadsheet as Your Name TEP021 Excel 4 in the Documents folder on your computer.
  12. Calculate the weekly cost of each listed item, daily total spending, and the total cost of a week.
  13. Apply a Table Style of your choice.
  14. Insert a header with your name and student number on the left and the date on the right.
  15. Insert a footer with the file name on the left and page number on the right.
  16. Ensure the table does not split over two pages by adjusting the column widths or switching to Landscape orientation, or both.
  17. Close your workbook
  18. Upload the completed activity document to the TEP021 Activities folder on OneDrive.

License

TEP021 Foundations for Success Copyright © by TEP Team, CDU. All Rights Reserved.

Share This Book