Question

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.

Answer 1

To calculate the total costs for the first city on the Cities worksheet, including airfare, shuttle or rental, lodging, and meals, you can use the following function in cell H13:=SUM(B13, C13, D13, E13)This function will add the values in cells B13, C13, D13, and E13 to calculate the total costs.To copy this function to the range H14:H18 without removing the border in cell H18, you can follow these steps:Click on cell H13 to select it.Press the "Copy" button on the ribbon or use the keyboard shortcut Ctrl + C to copy the cell.Select the range H14:H18 by clicking on cell H14 and dragging the mouse to cell H18.Right-click on the selected cells and select "Paste Formulas" from the context menu.This will paste the function from cell H13 into cells H14:H18, calculating the total costs for each city. The border in cell H18 will not be removed.

Step-by-step explanation: