What are the correct formulas/functions to complete a family budget?
Not what you're looking for?
In this project, you will enter in the correct Formulas/Functions to complete a family budget that has been started for you. You will also create a pie chart that will represent the expenses for the entire year. To view these instructions while working in Excel, print these instructions or move back and forth between your browser and Excel.
1. The Orange colored cells in the "O" column and Rows 14 and 19 on the worksheet indicate places where you will put in the formulas and functions.
2. Calculate the total expenses for each month. You must use the SUM function in the cell range C14:N14.
3. Calculate the total amount for each expense item for the entire year. These must be SUM functions and will be entered into the range: O5:O13. Note: Cell O14 will actually end up holding the total amount for all expenses.
4. Calculate the Gain or Loss for each month. These must be formulas and will be entered into the range: C19:N19.
5. Create a pie chart to show the graphical representation of the expenses, using the picture below as a guide. Hint: You must select the names and their corresponding totals before selecting the pie chart from the menu. This means that ranges: A5:A13 and O5:O13 must both be selected (highlighted) before choosing the pie chart from the menu.
6. Move the pie chart onto its own worksheet and name the worksheet: Expenses.
7. Add the Callout with the text (as shown in the picture): Rent was the biggest expense for the family.
8. Add the chart title: Expenses.
9. Add Data labels to show the percentages for each item in the pie chart.
Purchase this Solution
Solution Summary
This solution contains the correct functions in the original Excel file reattached.
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Basic Networking Questions
This quiz consists of some basic networking questions.
Javscript Basics
Quiz on basics of javascript programming language.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.