DC worksheet place worksheet cities worksheet 134 14 15+ 16 17+ 18 19 20 21 22 23
Fantastic news! We've Found the answer you've been seeking!
Question:
DC worksheet
place worksheet
cities worksheet
Transcribed Image Text:
134 14 15+ 16 17+ 18 19 20 21 22 23 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 Green Fill with Dark Green Text. 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. P On the Cities worksheet, click cell H13 and enter the function that calculates the total costs for the first city. 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. P 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 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. # On the Cities worksheet, select Landscape orientation, set a 1-inch top margin, and center the worksheet data horizontally on the page. 3 3 44 4 4 5+ 7e 7+² 3+² 3² 6 3 2 7 4 2 134 14 15+ 16 17+ 18 19 20 21 22 23 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 Green Fill with Dark Green Text. 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. P On the Cities worksheet, click cell H13 and enter the function that calculates the total costs for the first city. 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. P 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 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. # On the Cities worksheet, select Landscape orientation, set a 1-inch top margin, and center the worksheet data horizontally on the page. 3 3 44 4 4 5+ 7e 7+² 3+² 3² 6 3 2 7 4 2
Expert Answer:
Related Book For
Posted Date:
Students also viewed these physics questions
-
Data Set 14 in Appendix B lists city fuel consumption amounts (mi/gal) for cars categorized by size (small, midsize, large). If we use those city fuel consumption amounts arranged into the three...
-
On September 1, 2013, Turner Corporation places an order with a Japanese supplier for manufacturing equipment for delivery on June 30, 2014. The purchase is denominated in Japanese yen in the amount...
-
On July 1, 2013, Owens Corporation places an order with a European supplier for manufacturing equipment for delivery on June 30, 2014. The purchase is denominated in euros in the amount of...
-
An asset with a first cost of $9000 is depreciated by MACRS over a 5-year recovery period. The CFBT is estimated at $10,000 for the first 4 years and $5000 thereafter as long as the asset is...
-
Who is Lester Wunderman, and in what ways does his historic campaign for Columbia House illustrate the mindset of direct marketing?
-
What is meant by the term IT applications portfolio?
-
Consider the air pollution and mortality data given in Table B.15. a. Is there a problem with collinearity? Discuss how you arrived at this decision. b. Perform a ridge trace on these data. c. Select...
-
Nowlin Pipe & Steel has projected sales of 72,000 pipes this year, an ordering cost of $6 per order, and carrying costs of $2.40 per pipe. a. What is the economic ordering quantity? b. How many...
-
Company Y , a beverage manufacturer, observed that their product's demand and supply were in perfect balance, leading to consistent sales and no surplus or shortage in the market. What does the case...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Parker Company borrows money from the Redwolf Bank and signs an interest-bearing promissory note. Principal Interest rate Interest $9,600 8% $128 Required: Given the details above, determine the term...
-
Explains why the three reports should be used to measure the effectiveness of the strategies, supporting answer with research its for vehicle and the company is Honda. The three beneficial Google...
-
The company is Adidas provide the following I. Strategic alternatives to Adidas II. Recommended Strategy to Adidas
-
MaxiMac Enterprises manufactures The Kitchen Wizz. Data relating to the production of 'Kitchen Wizz' for 2019 was as follows: Annual volume in units $32,000 Selling price per unit $60 Variable...
-
Define the pros and cons of the differing contract types. What kinds of projects would you recommend for those differing contract types?
-
Using examples, critically discuss the importance of relationship marketing in driving consumer-based brand equity.
-
I think that if you are going to form a relationship (alliance) with anyone/company/etc. that you should comprehend each other's cultures, values, styles, etc. before joining forces. If they don't...
-
Which property determines whether a control is available to the user during run time? a. Available b. Enabled c. Unavailable d. Disabled
-
Listed below are the numbers of home runs in major league baseball for each year beginning with 1990 (listed in order by row). Is there a trend? Dotplots. In Exercises 11 and 12, construct the...
-
The author is a member of the board of directors of a nonprofit organization that held a fund-raising auction. He recorded the opening bids suggested by the auctioneer and the final winning bids for...
-
The Genetics and IVF Institute conducted clinical trial of the XSORT method designed to increase the probability of conceiving a girl. As of this writing, 945 babies were born to parents using the...
-
Why should projects be linked to the organisation's Strategic Plan?
-
What is the BCG matrix and how is it used?
-
Explain the role projects play in the delivery of an organisation's strategy
Study smarter with the SolutionInn App