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

Change the chart style to style 42

12/11/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:

Exam Attempter
Financial Assignments
Assignment Helper
Isabella K.
Coursework Assignment Help
Professor Smith
Writer Writer Name Offer Chat
Exam Attempter

ONLINE

Exam Attempter

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$32 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$46 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$50 Chat With Writer
Isabella K.

ONLINE

Isabella K.

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$18 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$21 Chat With Writer
Professor Smith

ONLINE

Professor Smith

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.

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

Reporting logistic regression apa example - Bsbrsk501 manage risk assessment - Iodine clock reaction lab report discussion - Abc sells 400 shares of its $23 par common stock for $27. the entry would entail credit(s) to - Edu 100 week 5 journal - Electrochemical cells lab pre lab answers - Kidney and nephron worksheet - Print network diagram ms project - What are the five sustainable marketing principles - Plastic parts produced by an injection molding operation are checked - Management at a Company - Company policies - Routine activities theory emphasizes a motivated offender, a suitable target, and: - Pronouns and antecedents ppt - We bought a zoo sparknotes - Goodstart sick leave policy - Vince's vinyl database - Comparative law lecture notes - A major characteristic of the classical psychoanalytic therapist is - List of management accounting techniques - Swot analysis of potato chips - Is 50 a composite number - Cheap seating area in a theatre crossword - Week 2 discussion - Reflection Paper Information security & Risk Management ISOL-533 - 4 hours - Forum - Absolute and relative location - Vce biology 2017 exam answers - Acorn rescue centre whitchurch - Thorpe bay tennis club - How to identify cations and anions in an unknown solution - Slavery and the making of america episode 3 - Attention getter for informative speech - Oh deer project wild - Managerial Accounting_Discussion4 - Simon st josephs ferntree gully - Answers to case studies in nursing fundamentals - Succulent karoo endangered species - Mfj 259b schematic diagram - Richard hillis heart attack - Ruined temple diablo 2 - Remember the order of the planets - Work done by a system is taken to be - The mmpi was originally developed to identify - Action camera market share 2016 - Inténtalo escribe el equivalente de las palabras en inglés - 5 day hypertrophy program - Water by the spoonful pdf - Maslow case study cindy - Foxit reader free download cnet - Quest on virgin media - Ipswitch ftp server download - 80e bra size conversion - The basic patterns of the universe are spoken of in the confucian book of - Salah is the coolness of my eyes hadith - Color blind powerpoint slides - Under armour vrio - Operations management simulation process analytics solutions - Rittal touch up paint - Reaction stoichiometry and percent yield lab answers - Monsanto case study business ethics - How to summarize a current event article - Advantages to live in city - How to evaluate a piecewise defined function - Perceptual distortion - Band saw safety procedures - Appliance warehouse phoenix - Joining the conversation a guide for writers 3rd edition pdf - How to check endpoints for interval of convergence - Experiment 7 empirical formula lab report - Bloomberg bmc questions and answers - Zinc blende coordination number - What is nursing quality indicators - Stat 200 week 5 homework problems - Electron configuration for lithium - Dcm personal care sdn bhddcm personal care sdn bhd - Griffith college assignment cover sheet - Siemens builds a strategy oriented hr system solution - The edge of the orchard discussion questions - Spinach extract chromatography - They say i say pdf - Avocado trees per hectare - Crypto Week 4 Milestone - Anti drug legislation matrix - Cavendish ikin ruthin properties - Paper Revision - Reconstruction and the Compromise of 1877 - Tycoon thai menu cameron park - Which of the following statements is true of missionary salespeople - Administration and Supervision in Criminal Justice - Professor Question 4 - Nuffield hospital woking ivf - The key study guide - Geometry - Example of persuasive messages in business communication - Jayco electric awning problems - 3.8 3 select memory by sight - Dissertation topic - Elt oup student headway - Ksp of ca oh 2 - Essay on a midsummer nights dream