Assignment title: Information
COMP 1212
Excel Assignments
Weekly Assignments
Either complete the weekly assignments in MyITLab
Alternative Excel Unit Project
Due: Week 13, December 2
Complete one large assignment. For an event of your choice (sports, leisure or general interest) create an Excel spreadsheet that includes at least 4 worksheets: event planning (tasks and timelines), event staff with work hours/schedule, tracking the budget, tracking attendees (attendance, payments or dietary requirements). You must include:
1. Formatted cells, rows and columns with lines, fill and gradients
2. Chart(s)
3. Formulas: addition, subtraction, percentages, multiplication, SUM and AVERAGE
4. Functions: Date, IF, VLOOKUP or PMT
When your spreadsheet is complete, please upload to the Excel Unit Project dropbox.