> It sounds like he didn't realize or notice that autofill was using adjacent cells (from other countries, in this instance).

No, it doesn’t sound like that: “in several instances where there were no observations to use for the autofill operation, the professor had taken the values from an adjacent country in the spreadsheet.”

It was not Excel’s fault.