Скачать или смотреть Exp25_Excel_AppCapstone_IntroAssessment_Travel | Exp25 Excel AppCapstoneIntroAssessment Travel

Exp25_Excel_AppCapstone_IntroAssessment_Travel | Exp25 Excel AppCapstone IntroAssessment Travel

Contact Us:

WhatsApp : +92 3706196728
Email : [email protected]



Exp25_Excel_AppCapstone_IntroAssessment_Travel

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 clustered column 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 Start Excel. Download and open the file named Exp25_Excel_AppCapstone_IntroAssessment_Travel.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 One worksheet has the original default name, Sheet1. You want to give the worksheet a meaningful name.

Rename Sheet1 as Memorials. 1
3 You want to move the Year Completed column between the Memorial and 2009 columns.

Select and cut column F. Insert cut cells in cell B1. 3
4 Now you want to separate the worksheet title and source from the dataset with a blank row.

Insert a blank row between rows 2 and 3. 2
5 Now you are ready to work with the DC2024 worksheet. Your first task is to correct spelling errors.

Display the DC2024 worksheet. Check the spelling and correct all misspelled words. 2
6 Continue using the DC2024 worksheet. You will format the headings on row 4.

Select the range A4:G4, wrap the text, apply Center horizontal alignment, and apply Dark Blue, Text 2, Lighter 90% fill color. 5
7 You now want to format the title so that it is more prominent.

Merge and center the title in the range A1:G1. Apply Dark Teal, Accent1 cell style and bold to the title.
4
8 The first column is too narrow for the names of the memorials. You will increase the width to display the full memorial names.

Change the width of column A to 34.
0
9 Sparklines provide visual representations of data. You will insert sparklines for the dataset.

Select the range C5:F10 and insert Line Sparklines in the range G5:G10.
4
10 Now you will format the sparklines.

Select the range G5:G10, display the high point sparkline marker, and change the color of the high point markers to Dark Red.
3
11 You want to create a chart that compares the number of visitors for each memorial.

Select the ranges A4:A10 and C4:F10 and create a clustered column chart.

Apply the Monochromatic Palette 9 (Orange gradient, light to dark) chart color.

Apply the gradient fill to the chart area and select the Light Gradient, Accent1 preset gradient. Do not change any other gradient settings. 4
12 The chart displays over the data. You will move it below the dataset and adjust its size. In addition, you will add Alt Text for accessibility compliance.

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 chart shows the number of visitors to each memorial. (including the period).
4
13 The chart needs a meaningful title. In addition, you want to format the axes and add gridlines.

Change the chart title to Annual Visitors. Apply Dark Blue font color and bold to the chart title. Apply Dark Blue font color to the category axis labels. Change the value axis display units to Millions. 4
14 You want to add data labels for one data series.

Apply data labels to the outside end position of the 2024 data series. Apply Number format with 1 decimal place to the data labels.
2
15 Now you are ready to focus on the Places worksheet. First, you will find an abbreviation and replace it with a city name.

Display the Places worksheet. Find all occurrences of BOS and replace them with Boston. 4
16 You decide to convert the dataset to a table, assign a name to the table, and apply a table style.

Convert the data to a table, assign the table name Tourist_Attractions, and apply Turquoise, Table Style Light 12. 4
17 The table on the Places worksheet is large. As you scroll through the table, you want the headings to remain onscreen.

Freeze the top row. 2