- 2 3 4 5 6 7 3 9 10 11 On The Dc Sheet Check The Spelling And Correct All Misspelled Words On The Dc Worksheet Select T 1 (65.43 KiB) Viewed 49 times
- 2 3 4 5 6 7 3 9 10 11 On The Dc Sheet Check The Spelling And Correct All Misspelled Words On The Dc Worksheet Select T 2 (99.38 KiB) Viewed 49 times
- 2 3 4 5 6 7 3 9 10 11 On The Dc Sheet Check The Spelling And Correct All Misspelled Words On The Dc Worksheet Select T 3 (33.28 KiB) Viewed 49 times
- 2 3 4 5 6 7 3 9 10 11 On The Dc Sheet Check The Spelling And Correct All Misspelled Words On The Dc Worksheet Select T 4 (67.23 KiB) Viewed 49 times
- 2 3 4 5 6 7 3 9 10 11 On The Dc Sheet Check The Spelling And Correct All Misspelled Words On The Dc Worksheet Select T 5 (81.68 KiB) Viewed 49 times
- 2 3 4 5 6 7 3 9 10 11 On The Dc Sheet Check The Spelling And Correct All Misspelled Words On The Dc Worksheet Select T 6 (64.36 KiB) Viewed 49 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 (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 F 18 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.
25 26 27 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 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Home Insert Page Layout 32 33 34 35 Format Painter 36 37 A 8 1 Washington DC Memoreal Visiters 2 Source https://irma.nps.gov/Stats/Reports/Park/FRDE 3 4 5 Lincoln Memorial Year Comple 1922 2004 6 World War II Memorial 7 Vietnam Veterans Men 1982 8 Korean War Veterans M 1994 9 Franklin Delano Roosev 1997 10 Thomas Jefferson Mem 1943 11 12 13 14 Colbri BIU DC S Places Formulas Data Review Cities Clipboard Font Alignment PRODUCT NOTICE Most of the features of Excel have been disabled because this product requires an update. View E * 2012 Help F 29 Wrap Text Merge & Gryter 2002 2007 3,551,973 4,214,167 6,191,361 7.956,117 4,079,606 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 G 2017 Trend %*** Number Update Now Conditional Formatting Manage Account
File Prste 111 Home Insert la Copy Formal Pantet 199 A Page Layout Calibri BIV DO S 19 1Old State House 20 Arlington National Cemetery 21 Franklin Delano Roosevelt Memorial 22 Old South Meeting House 23 USS Constitution Museum 24 BOS Massacre Site 25 Washington Square Park 26 National World War 11 Memorial 27 Jefferson Monument 28 Bunker Hill Monument 29 Congress Hall 30 Independence Hall 31 United States Capitoli 32 Betsy Ross House 33 Library of Congress 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 Clipboard Font Alignment PRODUCT NOTICE Most of the features of Excel have been disabled because this product requires an update. 1 Sightseeing Locations 2 Edgar Allan Poe National Historic Site 3 White House 4 King's Chapel Burial Ground 5 Park Street Church 6 City Hall 7 Fireman's Hall 8 Vietnam Veterans Memorial 9 Korean War Veterans Memorial 10 Fancull Hall Marketplace 11 Powel House 12 Old City Hall 13 Washington Monument Washington DC 14 Cathedral Basilica of Saint Peter and Paul Philadelphia 15 Martin Luther King, Jr., Memorial Washington DC 16 Elfreth's Alley Philadelphia 17 Fenway Park 18 Christ Church Formulas Data Places Cities City Philadelphia Washington DC BOS Philadelphia Philadelphia Washington DC Washington DC 805 B Philadelphia Philadelphia 805 Philadelphia BOS Washington DC Washington DC 805 BOS BOS Philadelphia Washington DC Washington DC BOS Philadelphia Philadelphia Washington DC Philadelphia Washington DC Washington DC BOS Philadelphis B01 Washington DC Washington) BOS Review G Fee 50.00 50.00 $0.00 $0.00 $12.00 50.00 50.00 50.00 50.00 $5.00 50.00 $0.00 $0.00 $0.00 $5.00 525.00 $5.00 $10.00 50.00 50.00 56.00 $10.00 $0.00 50.00 $0.00 $0.00 $0.00 50.00 50,00 View Help 50.00 $5.00 $0.00 53.00 $3.50 $0.00 $0.00 $000 $0.00 $3.00 BIO H D Time Needed 320 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 8888888 RET Papift 120 120 E F Tell me what you want to do 5-%28 Lach Exp19 Excel Appl Update Now G Number H Condition Formattin Manage Account
K4 A 1 Departure Date 234 in 1000 25 2 Return Date 4 5 6 7 8 9 10 11 Lodging Base/Night S Total Base Lodging $ City 1 2 3 4 12 Destination Cit 13 Boston 14 Miami 15 Orlando 16 Philadelphia 17 San Antonio 18 Washington DC 19 20 KEELESSCENTENNES 25 26 32 33 35 B 6/17/2021 6/22/2021 26 125 625 110% 125% 140% COL 95% City Typ 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 $ $ F 50 35 Shuttle or Rental Lodgin G Meals $ 375 330 285 375 285 420 H Summary Trip Costs Average Lowest Highest Total Cos