Reference no: EM1339814

A couple of your friends have heard from other family members that you are using Excel to organize the high school reunion data and create invoices and labels. They have asked you if you can help them create a check registry for one of their projects. They have created a workbook for their project, and you decide to review the formulas they have decided to use.

As you review the workbook, you realize you can create a similar workbook to track payments by each family participating in the family reunion to ensure that you are not using your own money to fund their attendance. You and your cousins decide to create a team that will construct a Reunion Account workbook that contains information similar to the original Bank Account workbook and uses formulas and functions.

Before you begin creating the workbook, your team must define how the workbook will be constructed. The functions you are required to use are IF and SUMIF. You may also use other functions, but these two are part of the minimal requirements. The only other minimal requirement is the use of Data Validation. Due to the fact that each of you have different ideas about everything from layout and formatting to use of formulas and functions, each member must creating a short document (2-4 paragraphs) describing the following:

each member's proposal for the precise use of layout, formatting, formulas, and functions of the new workbook

each member's explanation of why their proposal would be the most effective

The team is tasked with choosing the best of the proposed ideas and creating the workbook accordingly. The team must format the worksheets to be easily read and understood. Each sheet should be renamed and the tab color should be changed. The team should produce one completed workbook with all team member names contained on the first sheet using the naming convention ReunionAccoutTeam#.xls (replacing # with the team name or number.