Multiple choice technology

Say that you want to paste a formula result — but not the underlying formula — to another cell. In Excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?

  1. Click the Paste Button image button on the Standard toolbar.

  2. Click the arrow on the Paste Button image button on the Standard toolbar, then click Formulas.

  3. Click the arrow on the Paste Button image button on the Standard toolbar, then click Values.

  4. Noneofthese
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To paste only the value result of a formula (not the formula itself), use Paste Special > Values. In Excel 2002, you click the arrow on the Paste button to access special paste options, then select 'Values.' Option A performs a normal paste including the formula, Option B pastes formulas, and Option D is incorrect because the correct answer exists.

Keep practicing — related questions