Quality video. Very insightful for beginners such as myself. I have a question, during the course of video, you kept saying down the row and across the column. I had always thought that in Excel, columns were vertical while rows were horizontal, in line with your statements at the start of the video that (columns are represented alphabetically while rows, numerically). Correct me if I'm wrong. I always tend to mix them up. Once again, thank you for the Video.
Yes, you are very correct. However when you move vertically down you are moving from one row to the other and also if you are moving horizontally you are moving from one column to the other
Please I have a question on mixed referencing. Mixed referencing is the combination of relative and absolute referencing. Then you gave an example of adding numbers using their roll and columns and then locking it with the $ sign like D$13+E$but then in another spreadsheets of you talking about drivers, we were trying to multiply it, you used only locked the first roll which was D$2*D5 that is using 7% in D2 to multiply the roll So my question is why didn’t you lock both like d$2*D$5 because if we locked both and multiply, won’t we get the same answers?
Mixed referencing in formulas refers to fixing either the row or column of a certain cell or all of the cells involved in the formula while allowing the other part to change as the formula is copied to different cells.
Sharp Explanation
Quality video. Very insightful for beginners such as myself. I have a question, during the course of video, you kept saying down the row and across the column. I had always thought that in Excel, columns were vertical while rows were horizontal, in line with your statements at the start of the video that (columns are represented alphabetically while rows, numerically). Correct me if I'm wrong. I always tend to mix them up. Once again, thank you for the Video.
Yes, you are very correct. However when you move vertically down you are moving from one row to the other and also if you are moving horizontally you are moving from one column to the other
Please can we get the file used for this tutorial?? it wasnt shared in the milestone folder
Please I have a question on mixed referencing. Mixed referencing is the combination of relative and absolute referencing. Then you gave an example of adding numbers using their roll and columns and then locking it with the $ sign like D$13+E$but then in another spreadsheets of you talking about drivers, we were trying to multiply it, you used only locked the first roll which was D$2*D5 that is using 7% in D2 to multiply the roll
So my question is why didn’t you lock both like d$2*D$5 because if we locked both and multiply, won’t we get the same answers?
Mixed referencing in formulas refers to fixing either the row or column of a certain cell or all of the cells involved in the formula while allowing the other part to change as the formula is copied to different cells.
My question still hasn’t been answered
Could you share more light on it
Hello