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 on the Standard toolbar.

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

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

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To paste formula results (values only), you click the arrow on the Paste button and select Values. This pastes the calculated result without the underlying formula.

Keep practicing — related questions