Assignment 2: Expenses Worksheet in Excel

Jul 11th, 2015
KateS
Category:
Writing
Price: $10 USD

Question description

For this assignment you will use Microsoft Excel to develop a worksheet that details your personal expenses in at least four categories from the last three months. Some of these expense categories might include, but are not limited to, Mortgage, 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.)
  • Save it as LastnameFirstInitial_M3_A2
  • 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

Below your table of monthly expenses, you will create a chart using the numbers from your spreadsheet similar to the example below.

[img alt="" width="523" height="304" src="http://vizedhtmlcontent.next.ecollege.com/pub/content/5269ee2f-4445-4977-8df3-cda433457cfb/AU_COM106_W3_A2_G2.jpg">

    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.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UIUC
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
Five Star Tutor
Dec 4th, 2016
" Outstanding Job!!!! "
SjSurvivor143
Nov 19th, 2016
" Thanks for the help. "
Joemoe
Nov 5th, 2016
" <3 it, thanks for saving me time. "
tinytim47
Oct 27th, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
pmallory
Oct 23rd, 2016
" Totally impressed with results!! :-) "
mixedballz
Oct 14th, 2016
" excellent work as always thanks for the help "
kiln82
Sep 30th, 2016
" awesome work thanks "
darnay
Sep 21st, 2016
" The best tutor out there!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1828 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors