- 9 10 11 On The Dc Worksheet Select The Ranges A4 A10 And C4 F10 And Create A Clustered Bar Chart Apply The Monochromat 1 (62.18 KiB) Viewed 53 times
- 9 10 11 On The Dc Worksheet Select The Ranges A4 A10 And C4 F10 And Create A Clustered Bar Chart Apply The Monochromat 2 (89.7 KiB) Viewed 53 times
- 9 10 11 On The Dc Worksheet Select The Ranges A4 A10 And C4 F10 And Create A Clustered Bar Chart Apply The Monochromat 3 (33.1 KiB) Viewed 53 times
- 9 10 11 On The Dc Worksheet Select The Ranges A4 A10 And C4 F10 And Create A Clustered Bar Chart Apply The Monochromat 4 (67.75 KiB) Viewed 53 times
- 9 10 11 On The Dc Worksheet Select The Ranges A4 A10 And C4 F10 And Create A Clustered Bar Chart Apply The Monochromat 5 (67.75 KiB) Viewed 53 times
- 9 10 11 On The Dc Worksheet Select The Ranges A4 A10 And C4 F10 And Create A Clustered Bar Chart Apply The Monochromat 6 (80.44 KiB) Viewed 53 times
- 9 10 11 On The Dc Worksheet Select The Ranges A4 A10 And C4 F10 And Create A Clustered Bar Chart Apply The Monochromat 7 (64.33 KiB) Viewed 53 times
13 14 15 16 17 18 19 20 21 22 23 24 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 (81) 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 F 18 without removing the border in coll 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 E13H13 and apply Accounting Number format with zero decimal places 3 6 2 4 2 6 3 3 5 3 3
Step 25 26 27 Instructions 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 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.
File C21 14 15 16. 17 18 19 20 21 22 23 24 25 Home Insert Page Layout Cut Copy Fotmat Painte 4 5 Lincoln Memorial 6 World War II Memorial Year Compli 1922 2004 1982 7 Vietnam Veterans Men 8 Korean War Veterans N 9 Franklin Delano Roosev 1994 1997 10 Thomas Jefferson Mem 1943 11 12 13 26 27 28 29 30 Caliber A B 1 Washington DC Memoreal Visiters 2 Source: https://irma.nps.gov/Stats/Reports/Park/FRDE 3 31 32 33 34 35 36 37 Formulas Duta Review DC Places Cities C Clipboard Font Alignment PRODUCT NOTICE Most of the features of Excel have been disabled because this product requires an update. ✓ J D E 2002 2007 3,551,973 4,214,167 5,191,361 View Help 2012 8 B F G 2017 Trend 7,956,117 4,079,605 4,161,685 4,876,842 3,296,596 3,633,793 4,424,407 5,072,589 2,675,205 3,433,663 3,267,124 4,155,947 2,493,089 2,751,725 2,764,459 3,507,402 2,066,932 2,327,254 2,613,131 3,366,571 Tell me what you want to do Canter H BOHURROUN 5-% Number Update Now Conditional Formatting Manage Account
File C21 14 15 16. 17 18 19 20 21 22 23 24 25 Home Insert Page Layout Cut Copy Fotmat Painte 4 5 Lincoln Memorial 6 World War II Memorial Year Compli 1922 2004 1982 7 Vietnam Veterans Men 8 Korean War Veterans N 9 Franklin Delano Roosev 1994 1997 10 Thomas Jefferson Mem 1943 11 12 13 26 27 28 29 30 Caliber A B 1 Washington DC Memoreal Visiters 2 Source: https://irma.nps.gov/Stats/Reports/Park/FRDE 3 31 32 33 34 35 36 37 Formulas Duta Review DC Places Cities C Clipboard Font Alignment PRODUCT NOTICE Most of the features of Excel have been disabled because this product requires an update. ✓ J D E 2002 2007 3,551,973 4,214,167 5,191,361 View Help 2012 8 B F G 2017 Trend 7,956,117 4,079,605 4,161,685 4,876,842 3,296,596 3,633,793 4,424,407 5,072,589 2,675,205 3,433,663 3,267,124 4,155,947 2,493,089 2,751,725 2,764,459 3,507,402 2,066,932 2,327,254 2,613,131 3,366,571 Tell me what you want to do Canter H BOHURROUN 5-% Number Update Now Conditional Formatting Manage Account
H File Paste J11 Home Insert Page Layout Cut Copy Format Painter 4 5 6 A 1 Sightseeing Locations 2 Edgar Allan Poe National Historic Site 3 White House X King's Chapel Burial Ground Park Street Church City Hall 7 Fireman's Hall 8 Vietnam Veterans Memorial 9 Korean War Veterans Memorial 10 Faneuil Hall Marketplace 11 Powel House Calibri BIU Clipboard Font Alignment PRODUCT NOTICE Most of the features of Excel have been disabled because this product requires an update. f. 17 Fenway Park 18 Christ Church 19 Old State House 20 Arlington National Cemetery 21 Franklin Delano Roosevelt Memorial 22 Old South Meeting House 23 USS Constitution Museum 32 Betsy Ross House 33 Library of Congress 24 805 Massacre Site 25 Washington Square Park 26 National World War II Memorial 27 Jefferson Monument 28 Bunker Hill Monument 29 Congress Hall 30 Independence Hall 31 United States Capitol DC 34 Ford's Theatre 35 Paul Revere House 36 Todd House 37 Massachusetts State House 38 Lincoln Memorial 39 Supreme Court 40 Old North Church. 41 Formulas Data Review 12 Old City Hall Philadelphia Philadelphia Washington DC 13 Washington Monument 14 Cathedral Basilica of Saint Peter and Paul Philadelphia 15 Martin Luther King, Jr., Memorial Washington DC 16 Elfreth's Alley Philadelphia BOS Philadelphia BOS Washington DC Washington DC Places Cities City Philadelphia Washington DC BOS BOS B Philadelphia Philadelphia Washington DC Washington DC BOS BOS BOS BOS Philadelphia Washington DC Washington DC BOS Philadelphia Philadelphia Washington DC Philadelphia Washington DC Washington DC BOS Philadelphia BOS Washington DC Washington DC BOS C D Fee Time Needed $0.00 $0.00 $0.00 $0.00 $12.00 $0.00 $0.00 50.00 $0.00 $5.00 $0.00 $0.00 $0.00 50.00 $5.00 $25.00 $5.00 $10.00 $0.00 $0.00 $6.00 $10.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 50.00 $5.00 $0.00 $9.00 $3.50 $0,00 $0.00 $0.00 View Help $0.00 $3.00 TAARRR8882 8888888888888888888888888 120 120 30 30 120 60 60 60 120 60 60 60 60 60 60 60 60 75 180 60 60 75 30 30 45 30 75 30 90 120 60 60 120 60 60 120 45 90 30 Wap Text Merge Center E Tell me what you want to do F -% G Update Now Lach Exp19 Excel App Number H Condition Formattin Manage Account
K4 A 1 Departure Date 2 Return Date 1234 in 1000 4 Lodging Base/Night $ 5 Total Base Lodging $ 6 8 9 10 11 12 Destination City 13 Boston 14 Miami 15 Orlando 16 Philadelphia 17 San Antonio 18 Washington DC 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 City 1 34 35 26 B 6/17/2021 6/22/2021 2 3 4 125 625 COL 95% 110% 125% 140% City Ty 3 2 1 3 1 4 C Rental Car? No Yes Yes No Yes No D E Ground Transportation Round-trip Shuttle Rental Car per Day Rental Car Total Airfare $ 367 392 299 479 218 469 Shuttle or $ $ F Rental Lodg 50 35 G Meals $ 375 330 285 375 285 420 H Summary Trip Costs Average Lowest Highest Total Cos