Exp19_excel_appcapstone_introassessment_travel | Computer Science homework help

#Exp19_Excel_AppCapstone_IntroAssessment_Travel

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.

     

Start   Excel. Download and open the file named Exp19_Excel_AppCapstone_IntroAssessment_   Travel.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

 

On the DC sheet, check the   spelling and correct all misspelled words.

 

#On the DC worksheet, select the   range A4:G4, wrap the text, apply Center alignment, and apply Blue, Accent 5,   Lighter 60% fill color.

 

On the DC worksheet, merge and center the title in the range A1:G1. Apply Blue, Accent5 cell style and bold to the title.

 

 

On the DC worksheet, change the   width of column A to 34.

 

 

On the DC worksheet, select the range C5:F10 and insert Line Spark lines in the range G5:G10.

 

 

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 Red.

 

 

On the DC worksheet, select the   range G5:G10, apply Same for All Sparklines for both the vertical axis   minimum and maximum values.

 

 

On the DC worksheet, select the   ranges A4:A10 and C4:F10 and create a clustered bar chart. Apply the   Monochromatic Palette 12 chart color. Apply the gradient fill to the chart   area. Do not change the default gradient options.

 

#Cut the chart and paste it in   cell A13. Change the chart height to 6″ and the chart width to 7″.   Add Alt Text The bar chart shows the number of visitors to each   memorial for the years 2002, 2007, 2012, and 2017.

 

 

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. Add Primary Minor   Vertical gridlines to the chart.

 

 

Apply data labels to the outside   end of the 2017 data series. Apply Number format with 1 decimal place to the data   labels.

 

 

On the Places sheet, find all   occurrences of BOS and replace them with Boston.

 

On the Places sheet tab, convert   the data to a table, assign the table name Tourist_Attractions, and apply Blue, Table Style   Medium 2.

 

On the Places sheet, freeze the   top row.

 

#On the Places worksheet, sort   the data by City in alphabetical order and then within City, sort by   Sightseeing Locations in alphabetical order.

 

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.

 

#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 Light Red Fill.

 

On the Places worksheet, apply a   filter to display only fees that are less than or equal to $10.

 

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).

 

 

#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.

 

 

#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.

 

 

#On the Cities worksheet, click   cell H13 and enter the function that calculates the total costs for the first   city, including airfare, shuttle or rental, lodging, and meals. 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.

 

 

#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.

 

 

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.

 

 

Group the three worksheets and   create a footer with Exploring Series on the left side, the sheet tab code in the   center, and the file name code on the right side.

 

On the Cities worksheet, select   Landscape orientation, set a 1″ top margin, and center the worksheet   data horizontally on the page.

 

Save and close Exp19_Excel_AppCapstone_IntroAssessment_Travel.xlsx.   Exit Excel. Submit the file as directed.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Exp19_excel_appcapstone_introassessment_travel | Computer Science homework help

#Exp19_Excel_AppCapstone_IntroAssessment_Travel

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.

     

Start   Excel. Download and open the file named Exp19_Excel_AppCapstone_IntroAssessment_   Travel.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

 

On the DC sheet, check the   spelling and correct all misspelled words.

 

#On the DC worksheet, select the   range A4:G4, wrap the text, apply Center alignment, and apply Blue, Accent 5,   Lighter 60% fill color.

 

On the DC worksheet, merge and center the title in the range A1:G1. Apply Blue, Accent5 cell style and bold to the title.

 

 

On the DC worksheet, change the   width of column A to 34.

 

 

On the DC worksheet, select the range C5:F10 and insert Line Spark lines in the range G5:G10.

 

 

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 Red.

 

 

On the DC worksheet, select the   range G5:G10, apply Same for All Sparklines for both the vertical axis   minimum and maximum values.

 

 

On the DC worksheet, select the   ranges A4:A10 and C4:F10 and create a clustered bar chart. Apply the   Monochromatic Palette 12 chart color. Apply the gradient fill to the chart   area. Do not change the default gradient options.

 

#Cut the chart and paste it in   cell A13. Change the chart height to 6″ and the chart width to 7″.   Add Alt Text The bar chart shows the number of visitors to each   memorial for the years 2002, 2007, 2012, and 2017.

 

 

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. Add Primary Minor   Vertical gridlines to the chart.

 

 

Apply data labels to the outside   end of the 2017 data series. Apply Number format with 1 decimal place to the data   labels.

 

 

On the Places sheet, find all   occurrences of BOS and replace them with Boston.

 

On the Places sheet tab, convert   the data to a table, assign the table name Tourist_Attractions, and apply Blue, Table Style   Medium 2.

 

On the Places sheet, freeze the   top row.

 

#On the Places worksheet, sort   the data by City in alphabetical order and then within City, sort by   Sightseeing Locations in alphabetical order.

 

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.

 

#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 Light Red Fill.

 

On the Places worksheet, apply a   filter to display only fees that are less than or equal to $10.

 

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).

 

 

#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.

 

 

#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.

 

 

#On the Cities worksheet, click   cell H13 and enter the function that calculates the total costs for the first   city, including airfare, shuttle or rental, lodging, and meals. 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.

 

 

#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.

 

 

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.

 

 

Group the three worksheets and   create a footer with Exploring Series on the left side, the sheet tab code in the   center, and the file name code on the right side.

 

On the Cities worksheet, select   Landscape orientation, set a 1″ top margin, and center the worksheet   data horizontally on the page.

 

Save and close Exp19_Excel_AppCapstone_IntroAssessment_Travel.xlsx.   Exit Excel. Submit the file as directed.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees


We value our customers, and so ensure that our papers are 100 percent original. Our Team of professionals does not miss the mark; they ensure that step by step each paper is written uniquely. We never duplicate or work as we compare papers rest assured. We deliver our work a day before time to ensure that you don’t miss your deadlines. It is not only doing the work but delivering it at the right time. We capture the consequences of late remittances. .

Money-back guarantee

We value customer satisfaction here at popularessaywriters.com and make sure that you get the best value for your Money. It happens that sometimes you can pay twice for your order or may want to cancel it, or you feel that it doesn’t meet your requirements; our money back guarantee will give you the opportunity to get back your money. We will also refund 100% of money paid double. In case your paper does not satisfy your requirements , we request that you notify us via writing within 2 days otherwise on the third day we will assume that you have been satisfied. Do all your correspondences through our email address popularessaywriters@gmail.com.

Read more

Zero-plagiarism guarantee

At popularessaywriters.com, our professional writers know the consequence plagiarism does for our clients. We have updated software’s such as article checker and copyscape to check for originality of the custom papers before submission of the final paper to the you. Our guarantee to the customer is that we will write 100% original papers for them that are quality, timely and of low cost. We have experienced professional and competent PhD writers who will write quality custom papers for you..

Read more

Free-revision policy

. At popularessaywriters.com, we are proud to provide top-quality Essay writing service to our esteemed customers. We are ready to take up that challenging academic assignment that is giving you sleepless nights and simplify it for you according to your desired requirements. We are willing to revise your paper if it does not meet your requirements. At popularessaywriters.com, we do not compromise with quality; thus, we offer unlimited free revisions until the customer is satisfied with their custom paper. Our unlimited free revision services are provided under the following terms:.. .

Read more

Privacy policy

Popularessawriters.com knows that client’s information is an essential tool for our company. It means that whatever the client requests from our service is kept strictly confidential. It means that whoever writes for this company understands the terms and conditions hence you should not be worried because you will never see your work somewhere else...

Read more

Fair-cooperation guarantee

Rest assured that we will always be attentive to your needs and requirements. We belief in the phrase treat your neighbour as you would want them to treat you. We leave nothing to chance and always look forward to a good interaction with each other.. .

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency