Auditing

Question 1

Toggle between ‘Normal’ display and ‘Formula’ Display

Answer 1

Ctrl + ` / ~

Question 2

On Same Sheet: Selects cells directly referred BY formula (DIRECT PRECEDENTS)

Answer 2

Ctrl + [

Adding ‘SHIFT’ to the combination (CTRL + SHIFT + ‘*‘ ) allows selecting all precedents (direct and indirect)

Question 3

On Same Sheet: Selects cells directly referring TO formula (DIRECT DEPENDENTS)

Answer 3

Ctrl + ]

Adding ‘SHIFT’ to the combination (CTRL + SHIFT + ‘+‘ ) allows selecting all dependents (direct and indirect)

Question 4

‘Go To’ Tool or dialogue box. To go to a Cell or Cell Range or a Defined Name

Answer 4

Ctrl + G OR F5

Question 5

Trace Precedents, with arrows (All sheets)

Answer 5

Alt&raquo_space; M&raquo_space; P

Question 6

Trace Dependents, with arrows (All sheets)

Answer 6

Alt&raquo_space; M&raquo_space; D

Question 7

Remove all arrows

Answer 7

Alt&raquo_space; M&raquo_space; A

Question 8

Select all cells with comments

Answer 8

Ctrl + Shift + o