Question

INSTRUCTION: On the Summary worksheet, copy cell E6 and paste only the formula to cell E7. Do not paste the original cell formatting.

Answer 1

To copy cell E6's formula to E7 while preserving formatting, use Paste Special and select Formulas.

Step-by-step explanation:

To copy a formula from one cell to another while keeping the original cell formatting, you can use the Paste Formula option. In this case, you need to copy cell E6 on the Summary worksheet and paste it to cell E7. To do this, follow these steps:

1. Select cell E6
2. Copy the cell
3. Select cell E7
4. Right-click and choose Paste Special
5. In the Paste Special dialog box, select Formulas
6. Click OK

By following these steps, you will only paste the formula from cell E6 to E7 while keeping the original formatting of cell E7.