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

Remove duplicate rows in the dining out worksheet

13/10/2021 Client: muhammad11 Deadline: 2 Day

IFMG 101

Hi,

I want someone help me to do my homework IFMG 101 In myITlab.

Thanks

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 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". • Medium Green fill color (7th color on the 4th row) • 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". • Light Green fill color (7th color on the 2nd row) • 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 Medium Green fill color on Top as the primary sort. • Sort on cell color to display the Light Green 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 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

Updated: 04/04/2013 1 E_CH04_EXPV1_A1_Instructions.docx

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:

Helping Hand
Financial Hub
Assignment Helper
Maths Master
Accounting Homework Help
Top Grade Tutor
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I will cover all the points which you have mentioned in your project details.

$30 Chat With Writer
Financial Hub

ONLINE

Financial Hub

I have read and understood all your initial requirements, and I am very professional in this task.

$34 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$29 Chat With Writer
Maths Master

ONLINE

Maths Master

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$23 Chat With Writer
Accounting Homework Help

ONLINE

Accounting Homework Help

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$38 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

I have read and understood all your initial requirements, and I am very professional in this task.

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

Choose ONE of the two questions below to write a two-page, five paragraph minimum essay: - Http evolve elsevier com silvestri comprehensive rn - Under armour annual report 2016 pdf - Qc makeup academy locations - Parents workshop - Blood pressure measurement in pregnancy - 3-4 paragraphs cohesive response - Thesis statement on sula - Josquin des prez music style - International human resource management book pdf - Modulus of steel in gpa - Lds young women handbook - High country inc produces and sells many recreational products - CLC PowerPoint - Romans 8 29 30 suggests what about salvation - For each of the following situations involving marginal cost - Discussion Questions - Porter's diamond model for toyota - Patagonia strengths and weaknesses - Descartes third meditation summary - Articles with ethos pathos and logos - Seth feye established reliance financial services - Principal led street fighter - Major distinctions between zinn and schweikart - Prepare a classified balance sheet as of december 31 2018 - Working capital management includes which one of the following - Virtual pig dissection whitman answers - CHCADV005 provide systems advocacy services - Assignment cover sheet unisa - Homework 4 2 mystatlab module four problem set - Dr mark nesselson pediatrician - 600000 seconds in minutes - Week 6 - Thin film resistor wikipedia - Bsbfim501 pdf - What command embeds a new spreadsheet - Strategic audit report example - Classroom observation powerpoint presentation - An investment offers 6100 per year for 15 years - 6.4 billion in numbers - Msud blackboard - 200 WORD ESSAY ON PROGRAMS TO HELP CONVICTS REENTER SOCIETY - Assignment - Ld9 - RM DISCUSSION-1 - Is it ever ok to break a promise pdf - Charles barkley i am not a role model - Large blank canvas kmart - Identity management for internet of things river publishers pdf - Discussion - Erin danielle company purchased equipment and incurred the following costs: - Biomérieux vitek 2 compact user manual - Media Proposal - 1988 ap calculus ab multiple choice answers - The more factor by laurence shames - The world at work handbook of compensation benefits pdf - Weaslers - According to the attraction selection attrition theory job applicants - Neurological Disorders - Economic Impact of COVID in the US. - Brookside sexual health clinic aylesbury - What products should ww grainger carry at a store - I lift my hands to the great i am - The ethical emotivist would most agree most which statement - Assignment - Wawa velorio - 10 pair colour code - Capsim drift rates - Homeworke - 2 identify and document key nursing diagnoses for jennifer hoffman - P kolino business plan analysis - Https securepro prod energy siemens com securepro - Business model canvas healthcare example - Hydraulic anti drift valve - Optometrist chatswood lemon grove - Donning and removing sterile gloves with rationale - Shannon wiener index meaning - The brethren john grisham sparknotes - SOFTWARE PROJECT MANAGEMENT - Victim facilitation - Medea quotes about revenge - Advantages and disadvantages of organic farming - Rosemarie rizzo parse date of death - To my muse by jose rizal meaning per stanza - Green zones moreton bay - 1 Question - Chapter 7 grader project excel - Retriggerable monostable multivibrator circuit - 2 robyn court hampton park - Jacaranda tree leaf type - In praise of the f word argumentative essay - Enterprise key management policy - What is guided writing in primary school - Gestalt principles in advertising - Lección 6 contextos - Meaning of exceptionality in special education - The state patrol ticket processing system case study - Research paper - The fenders folsom prison blues - Canadian geography trivia with answers