Donna has entered a long, complex formula in cell B4 in one worksheet. She would like to use the same formula in a cell on another worksheet. To do this quickly, she should?
A. Use Autofill
B. Copy and Paste
C. Use the SUM function
D. Write the formula on paper and type into the new cell

Respuesta :

The correct answer is choice B - copy and paste

A long and complex formula can easily be copied from one worksheet to another by using the copy and paste feature. You will need to place the cursor in the cell that you want to copy and then press control+C, use the copy icon, or right click and choose copy. To paste it to the new worksheet you can either use control+v, use the paste icon, or right click and choose paste.