Computer Science, asked by srimayeebehera01, 15 days ago

Identify the error and correct the given formula for copying a formula of one sheet to another: =B4+D4^Sheet 1​

Answers

Answered by dvenkat27
0

hen go back to sheet 1 and the source cell and press Enter. Now, to transfer a formula: Assume the formula is in sheet 1, cell A1. Highlight A1, Copy (Ctrl+C) it, go to the cell in sheet 2 where you want the formula to go and Paste (Ctrl+V) it. Excel will adjust the formula to =Sheet1!

Similar questions