Activity – Excel 4: Creating a budget
- Start a new Excel workbook.
- Save the file as Your name TEP021 Excel 4.xlsx in the documents folder on your computer.
- Create a weekly budget spreadsheet using the information below.
- Newspaper at $2.20per day from Monday to Friday. $2.80 each for Saturday and Sunday.
- Milk at $4.75 every day.
- Personal spending $35.00 per day from Monday to Friday. $50.00 each for Saturday and Sunday.
- Bread at $3.70 per loaf on Monday, Wednesday, Friday, and Saturday.
- General Groceries – $200.00 on Thursday.
- Football – $25.00 on Saturday (not included in personal spending).
- Lunch – $18.00 each from Monday to Friday.
- 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.
- Calculate the weekly cost of each listed item, daily total spending, and the total cost of a week.
- Apply a Table Style of your choice.
- Insert a header with your name and student number on the left and the date on the right.
- Insert a footer with the file name on the left and page number on the right.
- Ensure the table does not split over two pages by adjusting the column widths or switching to Landscape orientation, or both.
- Close your workbook
- Upload the completed activity document to the TEP021 Activities folder on OneDrive.