Question

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.

Answer 1

The question shows the use of conditional statements. The formula in cell E13 is = IF(C13="Yes",F4,F2)

Assuming you have already entered the function that calculates the total costs for the first city in cell H13, you can use the steps below to copy the function to the range H14:H18 without removing the border in cell H18:

• Select cell H13. This will highlight the cell containing the function you want to copy.
• Press Ctrl+C to copy the function.
• Click cell H14 and hold down the Shift key while clicking cell H18**. This will select the range H14:H18.
• Right-click the selected range and select Paste Special from the context menu.
• In the Paste Special dialog box, select Values under Paste and check the box next to Paste Link under Paste Options.
• Click OK to paste the function values without removing the border in cell H18.

Answer 2

1, 511

Step-by-step explanation:

See attachment