Formulas can be hard to understand if they are written in terms of cell addresses.
You can give any cell a more natural name using the Name Manager under the Formulas tab of the ribbon.
You can also name ranges. A set of contiguous cells is called a range in Excel.
I didn't cover this in class. But, an example of where I use this is in my gradebooks. I might put all the exam scores for a large class in AC11.AC65. If I highlight that range and call it Exam, then when I want a class average I can type average(exam) instead of average(AC11.AC65). It's less cumbersome, and there's less room for error.
No comments:
Post a Comment