Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.1 Insert Data In Cells and Ranges: Copy and Paste Data (Paste Errors)

Paste Between Worksheets What Do You See? When you copy and paste data into a new spreadsheet, you may see many error messages. That's Excel's way of asking, "Where's the data?"   2. Try This: Review the #REF Errors Click on any cell that says #REF! You will see that the formulas are still there. This example shows: D3=D2+$B$3. When you paste formulas into a new spreadsheet, the cell references may become meaningless. In this example, there is no Reference Cell, $B$3, so there is nowhere to look up the quantity.   3. Try This: Review the #VALUE! Errors Click on any cell that says #VALUE! You will see that the formulas are still there. This example shows: E4=C4+D4.   In this example C4 has Text, not Numbers. How do you multiply Text times Numbers? Hence, the error #value!   Keep going, please... Home->Clipboard->Paste