Family Reunion spreadsheet using Excel
Not what you're looking for?
A couple of your cousins have heard from other family members that you are using Excel to organize the family 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.
Download the project workbook.
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 decide to construct a Family Reunion Account workbook that contains information similar to the original Bank Account workbook and uses formulas and functions.
Before you begin creating the workbook, you 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 2 are part of the minimal requirements. The only other minimal requirement is the use of data validation. You must also create a short document (2-4 paragraphs) describing the following:
Why did you use the layout, formatting, formulas, and functions of the new workbook you did?
Why this is an effective layout?
You must format the worksheets to be easily read and understood. Each sheet should be renamed, and the tab color should be changed.
Purchase this Solution
Solution Summary
The questions are answered in an Excel file with 2 worksheets and a Word file with 576 words.
Solution Preview
The worksheet labeled Totals provides a summary of the computations done in the Reunion worksheet. I will go over the Reunion worksheet which contains all the calculations for the family reunion, followed by the Totals worksheet which uses specific calculations in the Reunion worksheet.
REUNION WORKSHEET
The layout consists of columns which are labeled with the appropriate headings. Cells in red are entered by the user. Cells that are not colored should not be changed as they contain formulas. This colored layout was used to make it easier for the user to enter data. The formatting includes dollar signs to make it easier to see where the dollar amounts are located. The SUMIF, IF and COUNT functions were used to compute the values in cells in the worksheet. They will be explained ...
Education
- MSc, California State Polytechnic University, Pomona
- MBA, University of California, Riverside
- BSc, California State Polytechnic University, Pomona
- BSc, California State Polytechnic University, Pomona
Recent Feedback
- "Excellent work. Well explained."
- "Can you kindly take a look at 647530 and 647531. Thanks"
- "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
- "GREAT JOB!!!"
- "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.