for wizard kim: expenses worksheet in excel

 

Expenses Worksheet in Excel

 

Before beginning this assignment, you should thoroughly review Excel Worksheets, Charts, Formulas, Functions, and Tables from your course textbook, Go! All in one: Computer concepts and applications.
 
For this assignment you will use Microsoft Excel to develop a worksheet that details your personal expenses in at
least six categories from the last three months. Some of these expense categories might include, but are not limited to Rent, Utilities, Phone, Food, Entertainment, Tuition, Childcare, Clothing, and Insurance. (These numbers may be fictitious.)

 

Part 1: The Spreadsheet

 

  • Begin by opening a new Microsoft Excel file. (You may use the template found here.)
  • Use Rows 1 and 2 for a title.
  • Beginning in row 4, use column A to list your different expenses.
  • Label the next three columns (B, C, D) for the past three months.
  • Fill in the appropriate amount for each expense for each month.
  • Beside the column with your third month’s entries, create another column for totals for each category.
    • Use a formula to calculate a total for each category of expense. 
  • In the row below your last expense entry, create another row for the monthly totals of expenses.
    • Use a formula to calculate a total for each month of expenses.
  • Beside the column add another column for calculating the percent of the budget for each expense category.
    • Use a formula to calculate the percent that each expense category is of the total expenditures.
  • Format the worksheet by adjusting column widths and wrapping text, and by applying appropriate financial number formatting and cell styles. 

 

Please Note:While some calculations might be easy to do in your head or using a calculator—merely typing the answer into the appropriate cell—the point of this assignment is to get you accustomed to using formulas. In situations requiring frequently updated data or more complex calculations, Excel is a very powerful tool if you know how to use it. Your grade is based on your demonstrated ability to use the required formulas.

Part 2: The Chart

 

 Create a chart using the numbers from your spreadsheet similar to the example below.

 

 

 

  • Open the Insert ribbon at the top of the screen.
  • Click on a populated cell inside your spreadsheet, then, click on Column on the Insert ribbon. Select the style of column chart you like. 
  • Click and drag your column chart into position below your spreadsheet.

 

Suggested challenge for intermediate users: Add a row or rows detailing your income and subtract the total expenditures from the total income.

 

Suggested challenge for advanced users: Use a formula, function, or combination of both to show your net gain or loss (income minus expenses summed over time) for the three-month period.

 

 

 

·         Submitted an .xls file with a spreadsheet labeled and populated according to the directions.

 

·         Included calculated totals for each month and each category.

 

·         Included formulas to calculate each expense category’s percentage of the total expenditures.

 

·         Formatted the worksheet by adjusting column widths and wrapping text, and by applying appropriate financial number formatting and cell styles.

 

·         Included a column or bar graph comparing expenses for each month.USE BAR GRAPH

 

·         Accurately portrayed numbers from the expenses spreadsheet in the chart.

 

·         Formatted the chart for visual appeal.

 

 

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency