Local sheet is limited to the associated action only. The scope of data is limited to that particular action. Other Actions which are part of the test cannot access those data values.
Global sheet has scope with respect to all actions coded as part of a Test.
I think this is sufficent to get answer for your scenarios, Please try it out and let us know if any confusion.
Global sheet has scope with respect to all actions coded as part of a Test.
I think this is sufficent to get answer for your scenarios, Please try it out and let us know if any confusion.

