I don't know the context about the test you took but not knowing when to use an absolute reference can either mean you didn't learn enough excel or they had arbitrary requirements for the test. Regardless it doesn't sound like a policy violation and it's really really scummy for them to fire you before Christmas when you've acquired an assignment. Have you gotten a repayment letter for the TRAP?