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

Wellness assessment and plan paper - Discussion 1 - Advantages of net present value method - Sirui t 004x vs t 005x - Nova hunting the elements worksheet answers fill in the blank - Portland state university maseeh - Gen 103 week 2 assignment - Domino's case study ppt - The Chief of police has asked you to create a PowerPoint presentation based on the research findings. Your presentation consists of the current and future criminal justice technology, examples and the benefits to your department. - Figurative language in boy in the striped pajamas - Tower hamlets penalty charge - Commenced business with capital journal entry - Sparknotes all quiet on the western front chapter 5 - Collapse of barings bank - Classification of magnetic materials - Monash business summer units - Wheel of choice problem solving - PICOT - Climate of doubt discussion questions - Corrections research paper and evaluation - How to make a culturagram - Wk2 dis/sg - Inter - Yo quiero taco bell translation - How many chapters are in jasper jones - Payroll service giant initially crossword clue - Addressing job selection criteria - Ibm content navigator mobile - Muslim Molvi 7340613399 OnLine No 1 FaMOUs VashIKaraN sPecIaLIsT IN Rajahmundry - 5x 8 7x 4x 1 - Shell oil in nigeria case study pdf - 2.5 litres in ml - Hygiene risks that will affect food safety are as follows - The backchannel can present challenges for business presenters because - My courses cty online - Genetic problems monohybrid crosses - Uncle doug output transformer - How to record stock split in journal entry - Excel 2016 capstone project ex 1 working with sales data - Did pablo picasso paint starry night - You are pulling heaven down and raising figurative language - Statement of Purpose - Marriage breakdown rollover ato - Strong tie ltd case study solution - Fair work statement nsw - WK 7 Discussion SOCW 6443: Treating Sleep Disorders - Eyeglassomatic manufactures eyeglasses for different retailers - Banking model of education - 3 responses with 60 words each (No plag) - Alert and oriented x4 questions - Lhr terminal 3 gate map - Gloucester royal hospital map - The problem of social order - Gibbons game theory solutions - University health centre durham - Last rodeo presley phillips lyrics - Bisalloy 400 sheet sizes - Ethylbenzene to styrene mechanism - City high caramel instrumental - Why doesn't blanche like bright lights - Classification Exercise - Plas madoc swimming baths prices - Environmental Science Essay Questions - How to write an oral presentation vce - Point loma high school yearbook - Racq road side assistance - Statistics - Epidemiology Paper - Advantages and disadvantages of data warehouse ppt - Pvc pipe max temp - Convert tons to barrels of crude oil - Project management at six flags new jersey - Year 12 physics formula sheet - 4 page essay for Latinx studies - Motivational interviewing vs coercive approach - Research paper correction and need to add bullet points for ppt - Week 2 discussion - The raven annabel lee - Anglian waterways boat registration - And when thy little heart doth wake - Cross site request forgery - Article - Maturity Model Discussion - Effective business writing quiz - You should be here sign worldventures - Mcdonald's global performance management practices - How to sell textbooks on chegg - Criminal Justice essay - Reactions in aqueous solutions lab key - Temperature log sheet for freezer - Anagrams of christmas carols and songs - Threat Categories [500 words] - Walt disney company competitive advantage - 5 stages of family life cycle - Commercial cookery - Omnibus mexicanos dallas tx jefferson - CIA Triad - Allied high tech consumables - Garden street grill cromer - Econometric. Stata.