Calculating Average Share Price To Date
In column 0, calculate the overall average stock price for each company. Use Original Price and all New Prices for each company. Label this column "Avg. Price". You need to figure out the formula on your own.
Hint: You will use C, F, I, and L. The problem is that they are not adjacent (connected) to each other. You can either type in the entire formula, or "Control Click". Select this first cell (C3), then hold down the Ctrl key and select F3, I3, L3. Don't let go of the Ctrl key until you have clicked on all of the cells you want in the formula. Notice how the cells are separated by commas. Why is this so?