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

Discovering your authentic self dr shefali - High altitude balloon experiments - The danger of a single story worksheet answers - Magento 2 service layer - East west university grading system - The classical school of criminology attributes crime to - Highly stretchable and tough hydrogels - Synthesis of triphenylmethanol lab report - Week 3 Part 2 - Determine two or more advantages and disadvantages of using traditional predictors - Unit: Information Technology - The lower quartile is equal to - Iec 60364 7 714 - 1827 fordham rd dallas tx 75216 - A gas contained in a piston cylinder assembly undergoes - Nursing diagnosis for foley catheter - Posted Below - Www printeron com ddl bear - Castillo tax service south sioux city - Helena college of technology of the university of montana - Finance questions - What is the visual depiction of workflow analysis - Cis 502 - Chapter 1 introduction to statistics 1.2 exercises answers - Help for philosophy - Portal pymble ladies college - Flushing connection diaphragm seal - Baladna company qatar - Cell transport webquest worksheet answer key - Data mining - National crime check pty ltd - Environmental Policy SLA: Renewable Energy Paper - Terms and conditions may apply film - Adjectives for a snake - Chapter 18 prentice hall chemistry answers - Deliver in 10hrs unit 4 ip program capstone - Self referral physio worthing hospital - Noneffective Communication - Anti-Racism - Short essay on electrical safety - Growing pains the wrath of con ed - Examples of ethical dilemma and ethical lapse - "vote for my special local project and i will vote for yours." this political technique: - Discussion - Up ac za library - The following information is available on company a - "Consumer Behavior Blog Post –Hey! Give me back my information! Is selling consumer information ethical?" - Chapter Summaries(1 & 2)- 2 pages - Why you reckon langston hughes text - Counting backwards from 20 - DB ORGANIZATION HUMAN RESOURCE - Fire door gaps australia - Bruce lincoln holy terrors pdf - What is mass haul diagram - Bangladesh high commission canberra australia - Compare ac and dc transmission system - Rod mckuen thoughts on capital punishment - 400 nm to hz - Nokia market segmentation targeting and positioning - Case study healing and autonomy - Chevron australia pty ltd perth - Describe the health illness continuum - Google project oxygen do managers matter - Advanced pathophysiology neurological section - Internal and external assessment in strategic management - Morelo palace 90g for sale - Turn signal and hazard light wiring diagram - Source program is written in which language - Write an equation for a rational function with - Low total protein nursing interventions - Mamá hola daniela cómo 1 - Strategic profile and case analysis purpose - Example of an extramural community based service - LAW 4 - Certainty risk and uncertainty in decision making - Bangladesh high commission sydney camp 2019 - Bsbrsk501 manage risk assessment - 1d william street tranmere - Literature review on cyber crime pdf - Assignment - Difference between surface level diversity and deep level diversity - Memo to a Friend - Historic civil engineering landmarks - Sea monsters qld museum review - The permissible bending stress in steel is - Alh3 lewis dot structure - Nabertherm more than heat 30 3000 c manual - Hypothetical research proposal - Actual intake vs recommended intake - Principles of motivational interviewing - Nursing - Social Work Process Recording - Gram staining experiment lab report - Case how to sink the mayflower - Assignment - &&+2349022657119..HOW TO JOIN OCCULT FOR MONEY RITUAL.. ILIMIENAT.. VOODOO HEALER..HOODOO SPLLER - Human Resources - Top10 electrocompetent cells protocol - American Government - Stress Article