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

27/10/2020 Client: arwaabdullah Deadline: 10 Days

Office 2016 – myitlab:grader – Instructions Excel Project

EX16_XL_VOL1_GRADER_CAP_AS – Travel Vacations 1.5

Project Description: You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston. You will format a list of memorials in DC, add Sparklines to compare the number of visitors over a 15-year period, and create a bar chart to illustrate annual visitors at each memorial. In addition, you will create a table of sightseeing locations, sort and filter the data, apply conditional formatting, and add a total row to display average time needed to spend at each memorial. Finally, you will complete a worksheet by adding formulas to compare estimated major expenses for each city.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 0 2 On the DC worksheet, select the range A4:G4, wrap the text, apply Center alignment, and apply Blue, Accent 5, Lighter 60% fill color. 6 3 On the DC worksheet, merge and center the title in the range A1:G1. Apply Accent5 cell style and bold to the title. 6 4 On the DC worksheet, change the width of column A to 34. 3 5 On the DC worksheet, select the range C5:F10 and insert Line Sparklines in the range G5:G10. 4 6 On the DC worksheet, select the range G5:G10, display the high point sparkline marker, and change the color of the high point markers to Dark Blue. 4 7 On the DC worksheet, select the range G5:G10, apply Same for All Sparklines for both the vertical axis minimum and maximum values. 2 8 On the DC worksheet, select the ranges A4:A10 and C4:F10 and create a clustered bar chart. Apply the Color 16 chart color. Apply the gradient fill to the plot area. Do not change the default gradient options. Note, depending on the version of Office used, the chart color may be named Monochromatic Palette 12. 5 9 Position the top-left corner of the chart in cell A13. Change the chart height to 6 inches and the chart width to 7 inches. 6 10 Change the chart title to Annual Visitors. Apply Blue, Accent 5, Darker 25% font color to the chart title and category axis labels. Change the value axis display units to Millions. 5 11 Apply data labels to the outside end of the 2015 data series. Apply Number format with 1 decimal place to the data labels. 4 12 Click the Places sheet tab, convert the data to a table, and apply Table Style Medium 6. 5 13 On the Places worksheet, sort the data by City in alphabetical order and then within City, sort by Sightseeing Locations in alphabetical order. 4 14 On the Places worksheet, add a total row to display the average of the Time Needed column. Apply Number format with zero decimal places to the total. 4 15 On the Places worksheet, select the values in the Time Needed column and apply conditional formatting to highlight cells containing values greater than 60 with Green Fill with Dark Green Text. 4 16 On the Places worksheet, apply a filter to display only fees that are less than or equal to $10. 4 17 On the Cities worksheet, click cell F4 and enter a formula that will subtract the Departure Date (B1) from the Return Date (B2) and then multiply the result by the Rental Car per Day value (F3). 5 18 On the Cities worksheet, click cell E13. Depending on the city, you will either take a shuttle to/from the airport or rent a car. Insert an IF function that compares to see if Yes or No is located in the Rental Car? Column for a city. If the city contains No, display the value in cell F2. If the city contains Yes, display the value in the Rental Car Total (F4). Copy the function from cell E13 and use the Paste Formulas option to copy the function to the range E14:E18 without removing the border in cell E18. 7 19 On the Cities worksheet, click cell F13. The lodging is based on a multiplier by City Type. Some cities are more expensive than others. Insert a VLOOKUP function that looks up the City Type (B13), compares it to the City/COL range (A7:B10), and returns the COL percentage. Then multiply the result of the lookup function by the Total Base Lodging (B5) to get the estimated lodging for the first city. Copy the function from cell F13 and use the Paste Formulas option to copy the function to the range F14:F18 without removing the border in cell F18. 7 20 On the Cities worksheet, click cell H13 and enter the function that calculates the total costs for the first city. Copy the function in cell H13 and use the Paste Formulas option to copy the function to the range H14:H18 without removing the border in cell H18. 3 21 On the Cities worksheet, select the range E14:H18 and apply Comma Style with zero decimal places. Select the range E13:H13 and apply Accounting Number format with zero decimal places. 3 22 On the Cities worksheet, in cell I2, enter a function that will calculate the average total cost per city. In cell I3, enter a function that will identify the lowest total cost. In cell I4 enter a function that will return the highest total cost. 6 23 On the Cities worksheet, select Landscape orientation, set a 1-inch top margin, and center the worksheet data horizontally on the page. 3 24 Ensure that the worksheets are correctly named and placed in the following order in the workbook: DC, Places, Cities. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 100

Updated: 02/15/2018 1 Current_Instruction.docx

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:

Essay Writing Help
Quality Homework Helper
University Coursework Help
Online Assignment Help
Top Grade Essay
Top Writing Guru
Writer Writer Name Offer Chat
Essay Writing Help

ONLINE

Essay Writing Help

I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. I hold MBA (Strategic Management) (Finance and Marketing) & CPA.K (Accounting and Finance.)

$62 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

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

$62 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
Online Assignment Help

ONLINE

Online Assignment Help

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

$55 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

Working on this platform from a couple of time with exposure of dynamic writing skills gathered with years experience on different other websites.

$62 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

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

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Crack in the earth's crust where volcanic material escapes - 7 lbs 13 oz - What is a critical review - Two sided refutational message - Create an instruction set for a relatively simple task. - Distinguishing Inductive and Deductive Reasoning - Studying sn1 and sn2 reactions nucleophilic substitution lab report - British gas thermostat battery - Los tutores obra de teatro - Https www hhmi org biointeractive selection tuskless elephants - OT- Journal Analysis 3 - 1992 by key curriculum press inc answers - The element from period iii with the largest atomic radius - Shaver manufacturing inc offers dental insurance - Create a scenario summary report excel 2013 - Nursing assignment - Battle of fallen timbers apush - Producer in food chain - Musk Attar - 274 kw to hp - Civil right/ must be original work/ no plagiarism/ scholarly resources 2015/ turn in ready - Bus business administration capstone exam - Nurse manager role in reengineering of health care - Er diagram for movie database management system - Accounts payable internal control checklist - Mental Health - 800 words - Ted bundy case study - History of clinical psychology - Holy cross catholic church burnaby - Guided project 2 3 excel - Discount matrix transactional analysis - Poison dart frog physiological adaptations - Legislative initiative relating to psychology - Ib business and management past papers 2017 - MANAGING IN THE GLOBAL ECONOMY - Sigma 10m9 wet saw - Antacid analysis lab report - Usyd jane foss russell building - +27737189846,Al Barsha 1®=Safe Affordable Misoprostol 200 mcg Mifepack tablets For Sale in Ajman®Buy MTP KIT, - Spencer supplies stock is currently selling - King lear questions and answers doc - Memo - Partial dependencies are dependencies on only a portion of the ____. - Discussion & Journal - Week 3 - Brophy and good 1986 - Dq - What makes a good advert - Lactic acid fermentation inputs and outputs - York st john email - Cybertext building blocks of accounting a financial perspective - X descent in jvp - Cultural considerations presentation - Equivalent circuit of separately excited dc motor - Shareholder Analysis - Essay 2-3 pages APA Format - Talbot industries is considering launching a new product - How to find standard deviation on a calculator - Informative speech on abortion outline - Write A Brief Summary Of The Unbecoming Behavior 400 Words Only - Annotated Bibliography - Micellization in physical chemistry - Mechanical advantage and efficiency worksheet answer key - 1z0 067 latest dumps - Critique - Of - Egan - Et - Al - 2011 - Arts - And - Humanities - Assignment - Help - Competitive analysis of pepsi and coke - Maths made easy edexcel - Cell division mitosis and meiosis lab answers - Nelson health centre merton - Acg risk score range - Ballenger curious researcher 9th edition - System sensor model 2151e - The book thief point of view - Eric worre 90 day blitz - Postgraduate award of proficiency in assessment for access arrangements - Create a scenario summary report excel 2013 - Issues in economics today 7th edition quiz answers - Family tree maker companion guide - Hoyt sector model city examples - Ford supplier learning institute - Gcu child nursing - Bad physics in movies - Sas access 9.4 for relational databases reference - Smart unli call 15 - Extraction of oil of cloves by steam distillation - Internal users of accounting information - The beach a river of sand - What are pe eyes - Gravimetric determination of chloride in a soluble sample lab report - Continental airlines go forward plan - A e haigh pty ltd - MG375 Unit 7 Assignment - How many chromosomes does a zebronkey have - Butl_ Learnign Feamework - Assessing a Healthcare Program/Policy Evaluation - How to write comic dialogue - Web safe cursive fonts - Cisco unified cm assistant console - Joe brainard i remember pdf - Examples of unethical behavior in budgeting