Expert answer:Excel Problem Solving Assignment

Solved by verified expert:Please follow the instructions in attachment. and here is the criteria of this assignment.Data:The spreadsheet includes all required content, including: title, row and column headings, income, and expensesFormulas:The spreadsheet includes all required formulas, including: total income, total expense, net, and percentage.Formatting: The table is formatted appropriately using cell styles, font/font size/font color, cell merging, number formatting, and appropriate column widths.Chart:The spreadsheet contains an appropriate chart with a suitable chart title. The chart was created from the correct data range. The chart is moved to an appropriate location.In addition, you don’t need to finish integration part in this assignment.Thx
excel_probelm_solving_assignment_instructions__1_.docx

Unformatted Attachment Preview

EXCEL PROBLEM-SOLVING ASSIGNMENT
NOTE: This assignment may ask you to perform a task that I have not taught you how to do (and
that you may not find in your textbook). This is intentional. The purpose of this assignment is to see
how well you problem-solve with the software. You are welcome to research how to do these
things using Google or YouTube or whatever other search engines you are comfortable with.
For this assignment, you will create an Excel spreadsheet detailing your annual budget.
Getting Started
•
•
Open your textbook (or e-Book) to Excel Module 1.
Open a blank Excel spreadsheet.
Content
•
•
•
•
•
•
•
Using Excel Module 1 from your textbook as a model, create a spreadsheet that details your
monthly budget.
Use an appropriate Title.
The budget should include Income and Expenses for each of the 12 months of the year.
o COMMON STUDENT QUESTION: What if I’m just a college student and don’t have
a job or expenses?
▪ Do you eat? Then you pay for the food somehow and you get that money
from somewhere.
▪ Do you drive? Then you pay for gas somehow and you get gas money from
somewhere.
▪ Are you a student at UNA? Then you pay for tuition and books somehow and
that money comes from somewhere (Parents? Scholarships? Grants?
Student Loans?).
o EVERYONE has income and EVERYONE has expenses. Think hard and put
together a budget that makes sense.
Your budget should include calculations for total monthly income and total monthly
expenses.
Your budget should include a calculation for Net, which is a calculation of what you have left
over each month after paying expenses.
Your budget should include a yearly total for each type of income and each type of expense.
Your budget should include the percentage that each expense category makes up out of
your total expenses (HINT: an absolute reference is needed for this formula).
Formatting
•
Do not use the same colors shown in the textbook, but use all of the different types of
formatting tools shown in the chapter to format your spreadsheet appropriately.
o Format the title so that it stands out as a title.
•
o Format the numbers with appropriate number formats.
o Format the column and row headings appropriately.
Make sure the entire spreadsheet is formatted to fit on one page (so that if it were printed
you would be able to see all of the data printed on one page.
Chart
•
•
•
•
•
Select the data range that contains your expense percentages and the row headers that
identify those percentages (HINT: you will be selecting non-adjacent ranges for this).
Create a 3-D Pie Chart from that data.
Keep the chart in the same sheet, but move it so that it does not cover up your data.
Give the chart an appropriate Chart Title.
Use chart tools to format the chart appropriately.
Integration
•
•
•
•
Open the PowerPoint presentation that you previously created for the PowerPoint ProblemSolving assignment.
Add a new slide to appear right before the Summary slide.
o Name the new slide My Expenses.
o Copy the chart from Excel and paste it into the My Expenses slide in PowerPoint.
Save your changes to the PowerPoint file and close it.
Save your changes to the Excel file and close it.
Submit both your completed Excel spreadsheet and your revised PowerPoint presentation to the
appropriate assignment link in Canvas.
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades