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 4 capstone exercise

07/01/2021 Client: saad24vbs Deadline: 3 days

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



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
Top Essay Tutor
University Coursework Help
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

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

Benchmark patient's spiritual needs case analysis - What literature is now contained in the fasb asc - 5 moment hand hygiene - The pocket calorie counter suzanne beilenson - Human resource management applications nkomo answers - Leadership styles and employees motivation perspective from an emerging economy - Unthinking eurocentrism multiculturalism and the media pdf - Mona lisa smile movie - Edge hill university library - Rules for stability of resonance structures - Physical Security - Intentional torts, negligence, and strict liability. - Sher wood hockey sticks global sourcing case solution - Case study - Adverbs as sentence openers - Externalism in epistemology is an approach to rationality which argues that - Executive Summary - Heart rate experiment variables - Past perfekt in german - Reread this sentence from the letter from birmingham jail - Umuc haircuts stage 3 - Fungal nail infection cks - Case brief , white collar crime - Barriers to effective communication and how to overcome them ppt - HR: Post and responses - Adjustments in preparation of financial statements - Case study on moral status - Help with my finance homework - Oaklands junior school medway - Glencoe virtual lab when is water safe to drink answers - Coca-cola - Business Analytics (Predictive analytics) - Characteristic x rays of copper - Apprenticeship staff support programme - Which genus is considered the ancestor to adapids and omomyids - Deconstructing Adaptive Leadership - Library google scholar swinburne - Sleep no more macbeth doth murdered sleep - New lithographic equipment acquired at a cost of - Outliers essay conclusion - The global community bank under terms - Discussion - Bablock hythe caravan site flooding - Is grandfather a proper noun - Jane elliott blue eyed video - International university of japan - Capstone Research Companion - Sap fico profile summary - DISCUSSION - Discussion 1 - Canonical discriminant analysis spss - What happened to rodney peairs - Nursing intervention for abdominal pain - The revenue account for a merchandising business is entitled - A geographer might use a gps to - Minimum coins to make change - Teaching and Learning Styles - Betterup whole peron model - Discussion: American citizenship test and reflection - Arte et marte pronunciation - Enron the smartest guys in the room ethical issues - The second thinksafe step is: - Athlean x rotator cuff - Case 3 walmart manages ethics and compliance challenges answers - Revenge of the geeks analyze craft and structure answer key - The following frequency histogram represents the iq scores - Percy jackson chapter 6 questions and answers - How to write police report narratives - Bachte hole jante hobe - Clipsal dimmable led downlights - Product rule derivatives with radicals - Transimpedance amplifier op amp - Discussion Board: Why Employees Stay - Tesco ashbeck water review - Biomes virtual lab answers key - Uncertainty of a ruler - Using the Scientific Method to challenge our thinking - Sexual harassment assault response prevention training course answers - Assignment 4.1: Advocacy Action Plan Part II: PEST Analysis - Mayray govinda mantra meaning - Teesside university student email login - Hydrogen peroxide decomposition balanced equation - Project 2 - The portland hospital prices - Ccrp certification exam questions - Covid vs TB - Bus1 - Art robot science project board - How to use backtrack 5 to hack wifi - R - Triumph of the nerds part 1 summary - Purchased equipment on account journal entry - Hours per patient day formula - Financial accounting ifrs 3e chapter 10 - Your wisdom is consumed in confidence - Super teacher worksheets writing - Https www ketocustomplan com login - Concert press release example - Sniper solitude tree stand reviews - Methyl benzoate by fischer esterification