Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel chapter 9 grader project

01/12/2021 Client: muhammad11 Deadline: 2 Day

Project Description:

You started recording every credit card transaction so that you can analyze your monthly expenses. You used an Excel worksheet to track dates, places, categories, and amounts. Because you are a consultant who travels periodically, you also have business expenses. You included a column to indicate the business-related transactions. Now you need to convert the data to a table, sort and filter the data to analyze it, and apply conditional formatting to apply a visual effect for further analysis.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Open the downloaded Excel file named exploring_e04_grader_a1.xlsx.

0

2

In the Dining Out worksheet, convert the data to a table. Apply Table Style Light 14.

10

3

Remove duplicate rows in the Dining Out worksheet.

5

4

Sort the table by Description in alphabetical order, then by Store in alphabetical order, and then by Amount from the smallest to the largest.

10

5

Filter the records using the check box filters to show personal (i.e., non-business) lunch and dinner expenses.

10

6

Display the Total Row. In cell D48, select the function to total the Amount values. In cell E48, do not show a total.

10

7

In the June Expenses worksheet, apply the conditional formatting style that displays a Green Data Bar Gradient Fill in the range D2:D47.

5

8

Create a conditional formatting rule with these specifications to the range A2:C47:
• Formula to determine which cells to format
• Formula: =(AND(argument1,argument2)) where argument1 compares $D2 to see if it is greater than or equal to 100 and argument 2 compares $E2 to see if the text is "Yes".
•Light Green (Standard) fill color
• Green border color
• Outline preset border style

10

9

Create a conditional formatting rule with these specifications to the range A2:C47:
• Formula to determine which cells to format
• Formula: =(AND(argument1,argument2)) where argument1 compares $D2 to see if it is less than 100 and argument 2 compares $E2 to see if the text is "Yes".
•Orange (Standard) fill color
• Green border color
• Outline preset border style

10

10

Create a custom color sort for the Description column with these specifications:
• Sort on cell color to display the Light Green (Standard) fill color on Top as the primary sort.
• Sort on cell color to display the Orange (Standard) fill color on Top as the secondary sort.

10

11

Freeze the top row.

5

12

Set the Scale to Fit percentage to 115%. Display the worksheet in Page Break Preview and insert a page break so that row 36 starts on a new page.

5

13

Repeat the titles on row 1 on all pages.

5

14

Insert a custom footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side of the June Expenses worksheet.

5

15

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Dining Out, June Expenses. Save the workbook. Close the workbook, and then exit Excel. Submit the workbook as directed.

0

Total Points

100

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Calculation Guru
Coursework Assignment Help
Professional Accountant
Assignment Helper
Professional Coursework Help
Accounting & Finance Master
Writer Writer Name Offer Chat
Calculation Guru

ONLINE

Calculation Guru

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$20 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$45 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$19 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$25 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$31 Chat With Writer
Accounting & Finance Master

ONLINE

Accounting & Finance Master

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$38 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Tiger tails boarding shutterfly - Reflective Journal - Mcloughlins beach caravan park - International hrm case study brunt hotels answers - Electrolysis science fair - Applied physics letters supplementary material - Who is the specific target audience for sojourner truth's plea? - Thou blind man's mark sparknotes - Ansi asse z15 1 pdf - Personal Application - Freezing point depression pre lab answers - Function family reunion answers algebra 2 - Bolt torque to axial force - Dora creek public school - Oedipus text online - Collective nouns and verb agreement - Unit that measures the density of fibres - Can anyone help me with a Portfolio Management Essay? - Systematized nomenclature of medicine clinical terms snomed - Dulux monument powder coat - Green acres france aquitaine - What is the payback period for the cash flows - Aggregate demand and aggregate supply quiz - Rolston music company is considering the sale - UDL Modification - Nola pender model - Is seaweed living or nonliving - Founding brothers the collaborators - Discussion and 2 replies - Concerto meaning in music - Prevention of bullying in schools colleges and universities - What is the difference between innuendo and a downplayer - Baubles and bubbles columbia sc - How the concept of health has changed overtime - Ancient egypt map worksheet - History of coors beer cans - Titanic case study ethics - Tom buchanan house description - Blood Vessel, Blood Pressure, And Blood Components - Red green bar reader - Risk management plan templates - Mental status exam write up - Marketing management 5th edition by dawn iacobucci pdf - Hbr 10 must reads on strategy summary - Likert scale always sometimes never - Statewide super withdrawal form - Principle of moments class 11 - Midterm - Abercrombie and fitch wiki - How to read micrometer - European group for the study of deviance and social control - Tunapuna piarco regional corporation councillors - Hollywood homeless youth partnership - Discussion Study 3 - What does ipde mean - Health and safety risk register template - Dr c bravado ctg - Corwin corporation case study questions - Ponderosa racing pigeons stud - Shannon company segments its income - 515 bus timetable ipswich - Unit VII Journal Org BH - Nutrition Care Plan for COPD - CCIS - Art Project ( three times) - Ricka, 5 pages due by 48 hours - Career - Urban outfitters social responsibility - Examples of levers in sport - Transition model william bridges - Dehydration of 2 methylcyclohexanol lab report - Internal factors of samsung - Bucks teaching assistant pay scale - Is a burette accurate or precise - Article question and answer - Marketing - What factors affect the quality of an lcd monitor - How to demonstrate active transport - Negotiation readings exercises and cases 6th edition - Social media and mobile marketing strategy by randi priluck pdf - Imagine a country holly sklar summary - The 10 core social work competencies are - Scan disk scheduling algorithm - Switch mode transformer gcse - Vlsm variable length subnet mask workbook version 1.0 - Sir joseph hotung net worth - Cons of constitutional monarchy - Epson tm t70ii manual - Correlation coefficient calculator ti 84 - Relax - How have ideas about the solar system changed - Light vs darkness archetype - Mu mu mv mv - Receiver Coffee Ivey Case Study - Label the layers of the earth worksheet - Garden variety flower shop uses clay pots - Descartes method of doubt sparknotes - Help me with my homework - Properties of soil agriculture and water availability impacts - Bio rad western blot sandwich - Knightswood model boat club