High School

You selected and copied worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than the formulas. What do you do?

A. Display the Paste Special dialog box and select Formulas and number formats.
B. Click the Paste arrow in the Clipboard group and select Formulas.
C. Click the Paste arrow in the Clipboard group and select Values & Source Formatting.
D. Click Paste in the Clipboard group on the Home tab.

Answer :

Final answer:

To change the pasted copy of worksheet data from formulas to current formula results, select 'Values & Source Formatting' from the Paste arrow in the Clipboard group.

Explanation:

To paste worksheet data containing formulas as the current formula results rather than formulas, you should select option c. Click the Paste arrow in the Clipboard group and select Values & Source Formatting.

Learn more about Pasting formulas in Excel here:

https://brainly.com/question/22824478

#SPJ11

Other Questions