24/7 Homework Help

Studykind Will Help You Write Your Essays and Term Papers

From initial topic to finished paper

Question:

[Solution] Project #2, MTH – 154 Quantitative Reasoning

by | Jul 18, 2022 | Recent Orders

Project #2, MTH – 154 Quantitative Reasoning

Create a Sales Report and make Analysis of your Expenses during one-two month time period

Goals:

· Create, Save, and Navigate an Excel Workbook

· Enter Data in a Worksheet

· Construct and Copy Formulas and Use the Functions; Construct Formulas for Mathematical Operations

· Format Cells with Merge & Center, Cell Styles, and Themes

· Chart Data to Create different Column Charts

· Format all tables as ready for Print Worksheet, Display Formulas

 

Instructions

1. Create the table in Excel with original data; create a title for this table.

2. List for Groceries category at least 10 positions; for Entertainment 2-5, for Other 3 positions (for example, rent, books, gas, etc.). You have to create a bigger table than below.

  Price for

Item

Number of

Items

Total, $ %% of Total Expenses
Groceries        
Milk     <formula>  
Bread     <formula>  
      <formula>  
    Total Sales Tax <formula>  
    Total <formula> <formula>
Entertainment        
      <formula>  
      <formula>  
    Total Sales Tax <formula>  
    Total <formula> <formula>
Other        
      <formula>  
      <formula>  
    Total Sales Tax <formula>  
    Total <formula> <formula>
     

Total Expenses

 

<formula>

 

3. Calculate the tax in formulas for each category. Sales Tax Rates are different for states and counties. Find the Tax Rates in your county: https://tax.virginia.gov/retail-sales-and-use-tax . Indicate in the conclusion what Sale Tax you applied.

4. Create a Bar Chart for Groceries Expenses. Title your chart.

5. Create a Pie Chart for main categories: Groceries, Entertainment and Other. Show in this chart Percentage of Total Expenses. Title your chart.

6. Write 3-5 sentences in conclusion: what is proportion of your expenses for the different positions, how you can manage it, etc. Your conclusion must have quantitative reasonings.

7. In the second row of worksheet, write your full name and class.

8. Format page in Exceluse landscape orientation. Pay attention to charts: they have to be visible as a whole piece.

9. Safe the file with your full name, Upload the file in Canvas -> Assignments. The Extension of file must be xls or xlsx.

Sample Solution
Assignment Help

HOME TO CERTIFIED WRITERS

Why Place An Order With Us?

  • Certified Editors
  • 24/7 Customer Support
  • Profesional Research
  • Easy to Use System Interface
  • Student Friendly Pricing

Have a similar question?

Services that we offer

Your Paper Is In Safe Hands

PLAGIRAISM FREE PAPERS

All papers we provide are well-researched, properly formatted and cited.

TOP QUALITY

All papers we provide are well-researched, properly formatted and cited.

HIGHLY SECURED

All papers we provide are well-researched, properly formatted and cited.

Related Assignments

Study more efficiently

Quickly get your essay from idea to final graft save time, money and effort.

Boost your grade

Get through your toughest problem and learn how to solve them from expert writers

Essay Writing Service Ready to Help Online 24/7

Hire a professional just from $9.99

Click here

Open chat
1
Powered by Essaynice
Hello welcome to our whatsapp support 👋
Can we help you?