Fax Different Formula with airSlate SignNow

Fax different formula

hello everyone today we learn about some of the formula auditing tricks if ever you are working with a file which has been handed over to you you want to start with a certain ground with certain knowledge prerequisite knowledge before you can give your own inputs for example if you are given this simple model which talks about sales growth assumptions how hard the cost behaving in their upcoming years and based on that based on those assumption how are the sales cost and profit numbers being generated now either you double-click on these cells one by one and find out how the formulas are playing internally and how are they calculating the in profit or if if you want to get a quick glance of how are they moving you may go to formulas tab and there's something on the right hand side called show formulas notice there's a shortcut associated with show formulas too so first I click the button show formulas what does it do it quickly shows you all the formula add a single glance on the entire sheet if you click on the same button once again it goes back to normal the same thing you could have achieved by using these two keys on the keyboard one is control and the other is called back the key which is residing just immediately above the tab key so I'm going to press those shortcut keys together control and back to key you get the same effect I use this quite often before I start working on any file that has been given over to me by my colleague or by my clients so there goes the first string sure all formulas next this is another trick which shows you how are the formulas flowing from which sources so if I keep my cursor on this particular cell and I say trace PC D'Oench it shows me in graphical arrows form what are the numbers that are helping getting this answer on board and in fact if you want to go beyond the one level precedence you may again check the cell and double click on trace presidents similarly if I select one particular cell and I say double click on trace dependents notice it shows dependents dependents so it depends on how many times you click single click or double click if you don't want to show these arrows you may we say remove arrows and in fact if you pick up any cell who uses another cell from a different sheet then how does it get shown up I say trace dependence okay there's no dependent this must be the case for PC Dennis let me select this cell and double click on trace president's okay it shows president and presidents presidents and there's one window like sign which tells me that some cell has been referred from different sheep I double click on this dotted line and it tells me that this is the cell let me select that and press ok nope I'm taking to another sheet which is called test sheet so that was the button based exercise trace precedents and trace dependents if you want a similar thing using a shortcut key you as well may refer to these couple of shortcut keys which I'm going to use right now for example I choose this cell and I'm going to press the shortcut key control third bracket open this one so ctrl third bracket open it quickly chooses one level of precedence which I can readily make it bold by using control B and control you for underline similarly if I place my cursor on this green cell and I pays the same shortcut key control third bracket open it takes me to one cell previous to it now point number three is if I had referred to only one cell from a test sheet let's say in this case 62 and I use control third bracket open the same shortcut key it takes me there but now the question is how do I come back I will press f5 f5 is activating the guru box and automatically the origin where you came from that has already been posted here so all I need to do is press end up so right now what did I use I use the shortcut control third bracket open that is to go to the source and then if you want to return back then you use this shortcut key that is f5 and enter so basically it's going to work like this I can do third bracket open and f5 and end up so it's like moving back and forth similarly if you want to trace all the president's not just one using a shortcut key then you start using these to shortcut keys for presidents and dependents respectively so ctrl shift third bracket yeah it chooses all the cell's if I color them you'll find out which cells are they pointing to so these are couple of shortcut keys which helps you audit the entire sheet using quick navigation shortcut keys