Test Answer

1. And 2. Schwab Commission Charges

3. A1 of Total stock cost, The reason why this has four #### is because the cell isn't big enough for it to hold all the numeral or letter so it puts #### to tell you that your cell is too small

4. Returns the largest value in a set of values. So in G2, so this one tells you what the minimal cost of the money will cost

5. Ok, I used the SUBSTITUTE command line, I first wrote 4 different words in 4 different cells, I then went to a cell below that and went to the F of X and clicked on "most recently used" and clicked on SUBSTITUTE. and I did all of the stuff it asked me to do, and I got it to work. What it does is it changes the a line of text to a different line of text!

6.It finds out how much money you have to pay to get a certain amount of money and/or it tells you how yo can get the most money affectively.  

s