To make the inner workings of your spreadsheet more visible you can display ALL the formulas instead of their results with a simple shortcut.  Press ctrl and ` – this will toggle between showing formula results and the formula itself.