Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

  • Assignment to Submit for Grade

    1. Create a new file in Excel, and save it using your FSU username as the filename. Make sure that in the "Save As Type" field, you select "Excel Workbook (*.xlsx)". For example, if your email address [email protected], you could save the file as"dag11zAssgn4.xlsx". This is in Excel 2010 format or later.

    2. [4 pt] Rename Sheet1 to BudgetXX. Where XX is the last two digits of the current Year. For instance if this was the year 2056 you would name it Budget56.

    3. [4 pts] Create a Variable Expense section with the items listed on the left and months across the row. Start in row 3 or larger. There must be at least 12 items and a value for each of the 12 months. Use real or fictitious amounts. Variable expense sections with less than 12 rows of data will receive the following ADDITIONAL deductions:

      1. 10-11 Items [-15 Points]

      2. 8-9 Items [-30 Points]

      3. < 8 Imtes [-100 Points]

    4. [4 pts] Sum the rows and columns:

      1. Put a label on the row below the last item called Variable Monthly Total and

        sum the Column for each month. Use the SUM function.

      2. Put a label after the last month called Yearly Total and Sum each row. Use the

        SUM function.

    5. [4 pts] Create a Fixed Expense section with the items listed on the left and months

      across the row. This should be just below the Variable Expenses. There must be at least 6 items and an entry for each of the 12 months. Use real or fictitious amounts. Fixed expense sections with less than 12 rows of data will receive the following ADDITIONAL deductions:

      1. 4-5 Items [-15 Points]

      2. 2-3 Items [-30 Points]

      3. < 2 Imtes [-100 Points]

    6. [4 pts] Sum rows and columns:

      1. Put a label on the row below the last item called Fixed Monthly Total and sum

        the Column for each month. Use the SUM function.

      2. Put a label after the last month called Yearly Total and Sum each row. Use the

        SUM function.

    7. [4 pts] Create an Income Section with the items listed on the left and months across the

      row. This should be below the Fixed Expenses. There must be at least two entries and a value for each of the 12 months. One of course would be a regular job but think of

      2

something else like a second job. Use real or fictitious amounts. Income sections with

only one row will receive an additional 30 point deduction.

  1. [4 pts] Sum rows and columns:

    1. Put a label on the row below the last item called Monthly Total Income and sum the column for each month. Use the SUM function.

    2. Put a label after the last month called Yearly Total and Sum each row. Use the SUM function.

  2. [8 pts] Format the top rows ( Careful, 25 point deduction of not done properly)

    1. Fall term will be August through July ,

    2. Spring term will be January through December,

    3. Summer term will be in April through March for B Term or June through May for C

      Term

    4. Merge at least four cells in the center of your data on row 1 and create a title for

    your spreadsheet. Include your full name (i.e. Kim Novak's Budget). Make the font at least size 24 and choose an interesting Font.

10. [4 pts] Create a row Called Monthly Total Expenses that shows the total expenses for each month ( add the variable and fixed expenses for each month)

11. [4 pts] Use a formula to calculate how much money is left over or under for each month and total for the year. Subtract the Monthly Expenses from the Monthly total Income.

  1. [4 pts] Calculate how much money you earned in the year called Total Income.

  2. [4 pts] Which Variable expense (rent, groceries, cell phone, etc.) did you spend most on

    over the 12 month period? Yours must look at all items over 12 months. Show this in your spreadsheet by inserting another label on the left part of the sheet (call it Maximum Yearly Expense) and function MAX() at the bottom of your spreadsheet that shows the maximum yearly expense. Your Maximum Expense Amount should only show the highest expense amount and not what it was for. For example, if your’ largest yearly expense was $3000 for rent, your spreadsheet will show Maximum Yearly Expense $3000.00.

  3. [4 pts]What was the average you spent for the 12 month period (both fixed and variable)? Get the Average of the Monthly Total Expenses. Show this in your spreadsheet by inserting another label (call it Average Monthly Total) and function AVERAGE().

15. [5 pts] Insert a label and formula at the bottom of your spreadsheet that shows how much total money you have left over at the end of the year. You must subtract the total amount you spent from the total amount you earned.

16. [5 pts] Just below the cell where you show the amount left over use the IF() function to display a message based on the amount of money you have left over at the end of the 12 months. Feel free to make up your own goal. In the example, it was a trip to Paris. Yours should be something different. Insert a label identifying the goal.

Example Cell IF() Statement:

  =if(b21>10000,”Buy a Plane”,”Broke”)

3

 

17. [2pts]ChangealldollaramountstoCURRENCYformat.
18. [3 pts] Sort your variable expenses items along with their associated values

alphabetically
19. [3 pts] Change all labels in the spreadsheet to bold.

  1. [2 pts] Change all cell contents, except the title, to one of the following fonts: Arial,

    Calibri, Comic Sans, Courier, Georgia, Times New Roman, and Verdana. Change the font

    size to 12.

  2. [2 pts] Change column widths so that all data is visible.

  3. [3 pts] Use cell fill color, and cell borders to give your spreadsheet an attractive

    appearance (use colors and style of your own choice). Both fills and borders must be

    used in at least one area of the spreadsheet.

  4. [4 pts] Use conditional formatting on the cell that contains your yearly leftover amount

    (see step 10) to automatically change the cell fill color to red whenever the number in

    the cell is negative.

24. [12 pts] Create pie charts for each yearly totals for the Variable Expenses, Fixed

Expenses, and Income. Include in each pie chart:

  1. The labels

  2. A title for each chart

  3. Show the Values on the chart either by the actual value or percentage

  1. [3 pts] Set the Print Area for the spreadsheet to include the cells containing data and

    the charts. --everything from cell A1 through the bottom right corner of your pie charts.

  2. Use Print Preview to view your work.

  3. [3 pts] Change the page orientation to Landscape. Note that your spreadsheets may

    require more than one page.

  4. [2 pts] Type your full name in the Header of the spreadsheet along with the date you

    submit your work for a grade. Format it to bold and make sure it's centered.

  5. Save your work and submit it to your Instructor for grading prior to the due date listed

    on the course agenda. 

testimonials icon
It is called "The shocking demise of Mr. Thorndike." It was one of Morse's most puzzling cases. That morning Rupert Thorndike, the autocratic C...
testimonials icon
The details of the papers can be found in the attached document.  Please include question as the header for the answer.  The school uses Safe Ass...
testimonials icon
During Week 1, we will explore the concept of diversity in general. Distinguishing between diversity and inclusion is essential. Having an understa...
testimonials icon
Solve Problems 8 and 11 from Chapter 3. Determine how these problems will support your decision making process?...
testimonials icon
Running head: THE IMMUNE SYSTEM1The Immune SystemNameInstitutional AffiliationDateTHE IMMUNE SYSTEM2The work of our immune system is to defend us fro...
testimonials icon
I’m studying for my Computer Science class and don’t understand how to answer this. Can you help me s...
testimonials icon
The purpose of this assignment is to evaluate a static budget and prepare and evaluate a flexible budget. You are required to calculate an...
testimonials icon
Unit V Scholarly Activity  Data Warehouses and Data Marts  Write a one- to two-page (250-500 word) paper that discusses the d...
testimonials icon
Design a secure software structure This assignment is aimed to let you practice Security and Trust in Softwa...
testimonials icon
Number of Pages 4 Summary of th...
testimonials icon
Hispanic/ LatinoCultureInstitution AffiliationDateIntroduction For nurses to provide the best care to their patients they have to be culturallycompet...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65