- Go to “Student Roster” worksheet. You will see all the names of your club members.
- Type “25” to those students who were indicated as “Y” (Yes) to the Membership Paid column.
- Type “0” to those students who have not paid for the membership.
- Use appropriate formula to calculate the total membership fee that the club has been collected.
- Make sure that you format the “Amount Paid” column appropriately so that you can display “$” inside the column. Hint: use “Accounting” format.
- Format this “Student Roster” sheet to look more professional and appealing. You may use any pre-load format styles. Use appropriate font and color.
Budget Planning Worksheet
- In the same working file, go to the next worksheet, “Budget Planning.”
- Use appropriate formula to display the “Total Membership Fee” that you calculated from the “Student Roster” tab.
- Use appropriate formula to calculate the “Total Revenue.”
- Think about some of the items, events, and activities that you will plan to spend on the club. Then, type the amount of the expenses next to the expense items.
- Use appropriate formula to display the “Total Expenses.”
- Format this Budget Planning sheet to look professional and appealing.
- Create a pie chart to display all the expenses. Place the chart below the Budget Planning table.
- Save your work. Go to Blackboard, Course Content, and Excel Module to submit your file.
0 comments