Hi,

I did my Excel Expert Exam last week but unfortunately, I failed.
Sooo... I need your help for the following points:

1) How can we trace precedents for inconsistent formula and the table opened was full of formulas (E.G: SUM(A1:D1)...in same way for other cells)

2) How can we Evaluate long formula and correct the value of a cell (E.G: incorrect value for a cell using multiple IF function).