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

Chapter 9 grader project excel

24/11/2021 Client: muhammad11 Deadline: 2 Day

BUS 180: 301

Credit Card Expenses

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

Office 2013 – myitlab:grader – Instructions Exploring - Excel Chapter 4: Assessment Project 1

Credit Card Expenses

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:

Best Coursework Help
University Coursework Help
WRITING LAND
Math Exam Success
Write My Coursework
Top Academic Guru
Writer Writer Name Offer Chat
Best Coursework Help

ONLINE

Best Coursework Help

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

$22 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$42 Chat With Writer
WRITING LAND

ONLINE

WRITING LAND

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$31 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$25 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$27 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

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

$24 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

Which of the following statements is true of process costing? - Vocabulary - Mechanic shop business plan pdf - Miami Dade College PSY1515 - Persuasive essay about using cellphones in school - Top10 electrocompetent cells protocol - Gillette operates numerous strategic business units - United bank offers a 15 year mortgage - Exposure wilfred owen annotated - Occupational deprivation alienation imbalance - Native cherry tree australia - Eaton gen 3 fault codes - Costco craze inside the warehouse giant cnbc - Saylordotorg github io - 20 meter sprint test normative data - Luxottica trading and finance ltd - Linus tech tips mio honda - Bsb10115 certificate i in business - Obama nobel speech analysis - Introduction to java programming 11th edition - Isoflex marine engine mounts - Behind bars rookie year fabian fired - Self amalgamating tape jaycar - Product - 27 riemann sums homework answers - Spontaneous communitas abolishes status. - Nsw drink driving interlock - Module 02 Course Project - The Myth of Lobbyists - Pinto fires and personal ethics summary - Psychotherapy with individual - Bode plot example problems - Reflection Paper - Conscription debate australia ww1 - Examples of enablers and disablers - New transaction cannot enlist in the specified transaction coordinator biztalk - English - Irchester community primary school - Septic Shock - Australia ania walwicz analysis - 15 Yo - Caboolture hospital mental health - Juno and the paycock summary - Cssa trial papers english - Viticulture and oenology courses - Duke ellington teddy roosevelt - English composition - Woodcock johnson early cognitive and academic development - Charge of 1 kg electron - 2012 vcaa pe exam - Australian treatment outcome profile - Discussion - A database driver is software that lets the - Alina, cristina y yo somos buenas amigas. (nosotras) (1) - ME - Main - Homework 1 & 2 - 9 - Need assistance with part 2-4 - Acts 2 1 13 - 2 page advocacy paper - What is surface feet per minute - Elevator Design you are designing an elevator for a hospital. The force exerted on a passenger by the floor of the elevator is not to exceed 1.60 times the passenger's weight. The elevator accelerates upward with constant acceleration for a distance of 3.0 m and then starts to slow down. What is the maximum speed of the elevator? - Why is making a tentative diagnosis problematic - Nike commodity chain - Jen purchased a condo in naples florida - And above all to thine own self be true - Wk 2 Discussion 2 - Principal as instructional leader monthly map year at a glance - Essendon football theme song - Week 2 Project Phil - Pr 7 1a fifo perpetual inventory - Upper tropospheric winds that flow parallel to isobars are called - Stolen by jane harrison analysis - Change management simulation power and influence scenario 1 - The norton introduction to literature portable 13th edition pdf - Administration and Supervision in Criminal Justice. - Project - NUTRITION - Biggest challenge with apa formatting - What processes and systems might actually stifle innovation and intrapreneurship - Aligned learning activities and differentiation elm 210 - Chcdiv001 pdf - Prophecy and the founding of new religions often occurs among the - How to upgrade polycom group 500 firmware - Comparison and contrast examples sentences - International marketing and export management 7th edition pdf - Common hebrew inscriptions on gravestones - Words ending in ectomy - Joseph banks aged care facility canning vale wa 6155 - Methods of risk analysis in capital budgeting - 200 gpa to n/m2 - Safety hazard symbol worksheet answers - The parable of the sadhu summary - HR/Acc - Now and forever lyrics - Servicenow fulfiller vs approver license - International conference on harmonization guidelines for good clinical practice - Strengths based approach education - Week two assignment worksheet psy 410 - Cisco callmanager attendant console - Chase sapphire case solution - What is primacy and recency effect - The village montclair state university