Ivan inputs a phone number into cell A2 of an Excel workbook. He formats the cell using a phone number format: (555) 987-6543. Ivan copies cell A2 into a new workbook. What will be displayed in the new workbook, and why? , because Excel will not recognize a number when copied between files.
555987654, because when a number is copied, the number, not the format, is copied.
(555) 987-6543, because when a number is copied, the number and format are copied.
(555) 9876343, because when a number is copied, Excel will recognize the area code but not the dash between the numbers