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 10 grader project

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

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

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:

High Quality Assignments
A Grade Exams
Math Guru
Calculation Master
Pro Writer
Fatimah Syeda
Writer Writer Name Offer Chat
High Quality Assignments

ONLINE

High Quality Assignments

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$44 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$23 Chat With Writer
Math Guru

ONLINE

Math Guru

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$23 Chat With Writer
Calculation Master

ONLINE

Calculation Master

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.

$37 Chat With Writer
Pro Writer

ONLINE

Pro Writer

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

$26 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

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

Campbell biology vol 1 w mastering biologynew design - Niggermainia - Formula for flexible budget variance - Comment - BA 370 - Alaska horizon paperless employee travel - Discuss the role of the IMF in the global economy. Have they been successful in meeting their objectives? - Precalculus multiple choice questions with answers - Bsbhrm604 manage employee relations answers - Clc development powerpoint presentation - The yellow wallpaper secondary sources - Radne raket 120 parts - Informatics in healthcare - What is the doctrine of part performance - Exam 02.00 play with focus pretest - Application of middle range nursing theories to practice - Movie summary - Fin 571 financial ratio analysis - Psychology Final Grad Level - Passive and active resistance to slavery - ¿sabes? el concierto al aire libre fue un éxito. yo creía que (1) , pero hizo sol. - Gbn gd live television - EH week5 p5 - Find the rational zeros of the polynomial function calculator - Commonwealth hospital accredited hmo - MGT317 Week-5 Final Exam score 87% - E3 spark plug heat range chart - Walt disney swot analysis 2019 - A coffee manufacturer is interested in whether - Quality system Design - Ac nielsen research services - Summary of audit differences example - Data Governance Case Study Analysis (Amazon) - At modern lumber inc art binley - Epidemiology Case 3 - Cain killed abel with a rock billboard - Cummins campaign c1555 - How to find a positive and negative coterminal angle - Grasslin time clock wiring diagram - Multicultural centre for women's health - +91-8306951337 get your love back by vashikaran IN Sangli-Miraj&Kupwad - The disaggregating step in market segmentation involves - Milestone - J gk to j kgk - The chase annie dillard - Geoknow net climate graphs - Hotel investment business plan - COMM 203 - Sinek's golden circle (start with why) - Week 1 discussion 2 - A project requires an initial investment of - Bottle stand up game - Moreton bay pd online - I need help for my assignment on TutorsOnSpot - Module 2 SLP - Billy elliot do you want to see my fanny - Spirit release therapy training - Week 2 Report - Cost of bank cheque cba - Everyday use dee - Royal dick school of veterinary studies - What major factors help influence salespeople's ethical conduct - Intial - Why do people resist change in an organization - Blue streak inside jetblue the upstart that rocked an industry - Social work professional values and ethics - GOVT 480 DB FORUM 4 THREAD due 9/25/2020 - Haccp plan for frozen chicken - 0.44 converted into the nearest sixteenth of an inch is - What year did nehemiah rebuild the wall - Bachelor of software engineering unsw - Kiwi dna extraction lab - What is the static budget variance of operating income - Lump sum sales of stock with preferred stock - Address the need to contingency planning, ensuring to address the following items: (1) Benefits of scenario events/planning. (2) Questions to consider when implementing scenario planning. (3) The common types of scenario planning - Bottle recycle centre caboolture - Oncourse strategies for creating success - 5 7 driving data answers - Ethics - Discussion post: Database Search - Joyce van tassel baska integrated curriculum model - 253 wyatt circle norco ca - Sometimes you hear someone say that a particular appliance - Week 5 socioautobiography audio powerpoint - Holistic learning theory laird 1985 - List 5 ways to strongly authenticate a remote machine - Anglesea cliff collapse today - This is how you do it kid the inventorpreneur's handbook - Third soliloquy in hamlet - Begin with the end in mind - Starch production in photosynthesis - Midterm Questions - Alterations in the urinary elimination pattern - Linux - Rcbs case trimmer collet chart - Advantages and disadvantages of training methods ppt - Samsung model ln t4061f recall - X 2 22x complete the square - Www mhhe com garrison 15e - Spc plum sauce woolworths