Cell C1 of a worksheet contains the formula =A1 + B$1. The result of the formula is 100. The Copy command is then used to copy the formula to cell C4. Assuming cell A4 is empty, which on of the following will appear in cell C4?

a. The sum of cells A4 and B4

b. The content of cell A1

c. The content of cell B1

d. The content of cell B4

The first step to copy a formula between worksheets is to select Copy from the Edit menu or the Clipboard menu. What should you do next so that the copy of the formula in the destination worksheet includes cell references from the source worksheet:

a. Select Paste Special on the Edit menu or the Clipboard, and then click OK.

b. Select Paste Special on the Edit menu or the Clipboard, and then click Paste Link.

c. Select Paste on the Edit menu or the Clipboard, and then click OK.

d. Select Paste on the Edit menu or the Clipboard, and then click Paste Link.