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 change chart style 42

07/12/2021 Client: muhammad11 Deadline: 2 Day

Office 2010 – myitlab:grader – Instructions Skills Series Vol. 1 (Capstone)

Aspen Falls Restaurants

Project Description: In this project, you will modify a workbook to track taxes generated by restaurants in the Aspen Falls area. To complete the project, you will enter and format data, create formulas and functions, create and format a pie chart and a clustered column chart, apply conditional formatting, use Find and Replace to edit data, and finally create page footers.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the Excel file named Skills_eV1_Grader_CAP. 0 2 On the Taxes worksheet, center the title, Aspen Falls Restaurants, across cells D2:F2. 2 3 In cell J3, type Annual. In cell J4, type Federal Taxes. Center the text in each cell. 4 4 In cell J5, insert a formula that will add the numbers in cells F5:I5. Use the fill handle to copy the formula into cells J6 through J8. 5 5 In cell D2, apply the cell style Heading 1. 3 6 In cell J9, insert the SUM Function to total the values in the range J5:J8. Apply the Total cell style to the cell. 3 7 In cell C5, type Cafe after Giorno’s. In cell J2, type Tax Rebate and in cell K2, enter the value 3000 as the rebate amount. In cell K4, type After Rebate. 4 8 In cell K5, use an absolute cell reference to construct a formula that subtracts the rebate from the Annual Federal Taxes. Copy the formula down through cell K8. 5 9 Apply the accounting number format to the range F5:K9. 3 10 Select the nonadjacent ranges C5:C8 and J5:J8, and create a clustered column chart. 4 11 Change the fill color of the data series to Red, Accent 2. 3 12 Remove the legend and insert the title Annual Federal Taxes above the chart. 5 13 Reposition the clustered column chart so that the top left corner of the chart area aligns with the top left corner of cell E11. 3 14 Select the nonadjacent ranges K5:K8 and C5:C8 and create a Pie in 3-D chart in a new chart sheet named Rebate Taxes. 7 15 For all the slices, change the 3-D rotation of X to 30, and then change the point explosion of the Giorno’s Café slice by 40%. 4 16 In the pie chart, insert the chart title Taxes After Rebate above the chart, and then apply the Style 42 chart style. 5 17 Display the legend at the bottom of the chart area and increase the font size to 24. 4 18 On the Taxes worksheet, clear the formatting in the range F4:I4, and then right-align the text. In the range F3:I3, use the Date Format to change the dates to show as 3/31, 6/30, 9/30 and 12/30. 4 19 On the Revenue worksheet, in cell G5, insert a formula that subtracts the Local Taxes and Federal Taxes from the revenue and then divides that remainder by the number of branches for Giorno’s Café indicated in the Taxes worksheet (use the cell reference, not the number). Use the fill handle to copy the formula into cells G6:G8. 5 20 On the Meal Deal Sales Winners worksheet, in cell J6, use the MIN function to find the lowest number of Meal Deals sold. 3 21 In cells F5:F26, use the three triangles icon set in the directional style of conditional formatting to indicate where each manager falls among the group in terms of sales. 3 22 Add a new conditional formatting rule to format the range F5:F26 using a three-color scale. Keep the default values. 3 23 In column E, use Find and Replace to change all occurrences of AM Shift to Morning. 4 24 In cell I2, use the NOW function to insert the current date and time. 3 25 In cell J7, use the SUM function to insert the total number of Meal Deals sold. In cell J8, use the MAX function to find the most Meal Deals sold. 6 26 Group all of the worksheets together. Insert the file name in the center section of the footer for all of the worksheets in the workbook. Keep the worksheets grouped together. 5 27 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Rebate Taxes; Taxes; Revenue; and then Meal Deal Sales Winners. 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:

Write My Coursework
Finance Homework Help
Top Grade Essay
Quick Mentor
Math Guru
Math Specialist
Writer Writer Name Offer Chat
Write My Coursework

ONLINE

Write My Coursework

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.

$50 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

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

$22 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$24 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

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

$29 Chat With Writer
Math Guru

ONLINE

Math Guru

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.

$26 Chat With Writer
Math Specialist

ONLINE

Math Specialist

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.

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

Fully explain the following statement, providing supporting examples: Cultural shifts in literature and the visual arts led to the development of the enactment of the first animal protection laws in the 19thC. - Ordinary simple interest problems with solutions - Develop a bcg matrix for hershey company - Abc crisis model - Dr kimberly levels of attraction quiz - 6 6 challenge problem p 174 answers - Scientific and Mathematical/Analytical Perspectives of Inquiry Paper - Clinical Field Experience D: Fluency, Comprehension, and Vocabulary: I Do, We Do, You Do - For his statistics class experiment researcher - Turning point charlotte nc - Lee mack 9 letter word - History Help - Temptrak temperature monitoring system - How to solve sin 3x - 3.88 milligrams is equal to how many centigrams - Thirty percent of all dog owners poop scoop - Principles of management and organization - St helens hospital phlebotomy department - Diode rectifier circuit experiment - Evidence strategies for child custody pdf - Manchester united soccer club case study project management - Model for writers 13th edition - Labor Relations and Management Final Exam - First hand data and second hand data - Middle passage robert hayden analysis - Sherbrooke forest dandenong ranges - Purevision 2 multifocal fitting guide - Tag heuer used watch values - Ravi puravankara email id - How to use gel coat repair kit - Matrix organizational structure in healthcare - Blue card traffic control - Formulating leadership part ii powerpoint - Data flow diagram for human resource management project - Is disney a growth or value stock - Which of the following transactions occurred in the marketspace? - The _____ act criminalized securities fraud and toughened penalties for corporate fraud. - Times advertising rate card - Create a professional digital portfolio. - Granville island stage arts club theatre company events - 7 domains of typical it infrastructure - Compute the price of a percent coupon bond - What is strategy porter 1996 harvard business review - Archers body corporate management - Lifestyle and health practices profile - What is the fahrenheit equivalent of 0.00 kelvin - British columbia graduate scholarship - The diploid number for humans - Combustion of hydrazine equation - August 10 Week 3 project - Gravitational field strength on jupiter - Middlesex county joint health insurance fund - Plain language statement example - Analyze A Failing Promotional Campaign - 3.2 material certification requirements - Edna inspector calls quotes - Single Point Essay - 161 eastern road south melbourne - Calculate the length of ac - Merlin gerin multi 9 c60n c40 - Sustainable project - Public wants in economics - Probability Distribution - 200 WORD RESPONSE - Jandy valve actuator repair - Human Nutrition - The eukaryotic cell cycle and cancer worksheet answers - ༺|༻【༺|༻】 ∭@@|+ ,+27835179056 |..,,,۝∭】SAFE ABORTION PILLS IN SOWETO TEMBISA BENONI BIZANA PONGOLA NAMIBIA SWAZILAND HILLBROW - Week 15 Health care - Examples of inferential questions - Nursing care plan for cardiac patient - Nutritional Care Plan - Mission - Sitting on the beach - Http www tripmate com wpf430c - America riveting prospects by ed crooks financial times - Chapter 9 give me liberty - A major output of the classical school of management was the - Veeam sobr capacity tier - First class welder certificate - Nikon f100 focusing screen - Joe brainard i remember pdf - The state patrol ticket processing system case study - Sa010 form - A microeconomist as opposed to a macroeconomist might study - Storage organs in humans - Frosted flakes marketing strategy - Memorandum Report - Awl vet clinic gold coast - Perception in organisational behaviour pdf - How important is it to trace costs appropriately explain - Criminal procedure discussion #2 - Gopro innovation case study - Why is fartlek training important - Fundamentals of dsl technology pdf - Malayalee association of southampton - Mixed fixed and variable costs - Cite this for me uts harvard - Reaction of metals and acids - How long do aqua dragons live