Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want the pichtures for step 26.. please explain with pictures Stader - Instructions Exp19_Excel_AppCapstone_Intro Assessment_Travel Project Description: You are considering several cities for a

image text in transcribed
image text in transcribed I want the pichtures for step 26.. please explain with pictures
Stader - Instructions Exp19_Excel_AppCapstone_Intro Assessment_Travel Project Description: You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston You wil 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 Steps to Perform: Step Instructions Points Possible 1 0 2 Start Excel. Download and open the file named Exp19_Excel App Capstone_Intro Assessment Travelmix Grader has automatically added your last name to the beginning of the filename On the DC sheet, check the speling 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% il color On the DC worksheet merge and center the title in the range A1.G1. Apply Blue, Accents cel style and bold to the title 3 2 6 4 4 5 On the DC worksheet change the width of column A to 34 3 6 On the DC worksheet, select the range CS F10 and insert Line Sparklines in the range G5 G10 On the DC worksheet, select the range 65 610, display the high point sparkline market and change the color of the high point markers to Dark Red Focut hp Enable Editing Realed On: 02042021 2 Exp19_Excel AppCapstone_Intro ader - Instructions Excel 2019 Projed Step Instructions 25 On the Cities worksheet, in cell 12, enter a function that will calculate the average total cost per city. In cell 13, enter a function that will identify the lowest total cost. In cell 14 enter a function that will return the highest total cost Points Possible 6 26 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 l' top margin, and center the worksheet data horizontally on the page. 27 3 28 3 Save and close Exp19_Excel_App Capstone_Introssessment_Travel tsx Edt Excel Submit the file as directed 0 Total Points 100 bp

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Administration The Essential Reference

Authors: Brian Laskey, David Kreines

1st Edition

1565925165, 978-1565925168

More Books

Students also viewed these Databases questions

Question

What are the skills of management ?

Answered: 1 week ago

Question

What were the issues and solutions proposed by each team?

Answered: 1 week ago

Question

3. Who would the members be?

Answered: 1 week ago