graphic1

Exam 77-427 Microsoft Excel 2013 EXPERT
1. Manage and Share Workbooks
1.3   Manage Workbook Changes: Identify Errors

Paste Errors

4. What Else Do You See? Look next to the #REF! message:  There is an exclamation point that flags the error. This error has been identified as an Invalid Cell Reference.

 

The Error options include:

Help on this error

Trace Error

Ignore Error

Edit in the Formula Bar

Error Checking Options

 

This #REF! error comes from pasting data from one spreadsheet to another, but the new spreadsheet does not include all of the Cells that the formulas reference.

Keep going...

Home->Clipboard->Paste

graphic2