Question $2$

a$.$ Write a user$-$defined function called SumStop which takes an integer $$as an input and adds up the values of the cells in column A $($starting from cell A$1)$ until the value of the sum exceeds $,$ and then outputs the number of cells used. You should assume that all of the cells in column A contain numbers.

Use a suitable Do While loop and the cells command. Declare all variable types and include appropriate comments in your code.

b$.$ Write a user$-$defined function called NoSpace which takes a string as input and outputs the same string with all of the spaces removed. For example, given the string

The quick brown fox

it should return the string

Thequickbrownfox

Use a a suitable loop, declare all variable types, and include appropriate comments in your code.